ORA-01031: insufficient privileges- Login remoto como Sysdba Oracle database server

Resolvendo o insuficiente priveleges, basta criar o arquivo de senha do banco com o comando orapwd:

Veja um exemplo:

Criando o arquivo de password:


No linux/unix através do shell:

oracle@databsever:~ orapwd file=$ORACLE_HOME/dbs/orapw password=senhadosysdba


No windows via (Command Prompt) orapwd file=%ORACLE_HOME%\database\PWDsid_name.ora password=password_for_sys

Step 2. coloque a linha abaixo initservice_name.ora in UNIX, or init.ora in Windows:


REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

Step 3. Restart a instancia

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2019288 bytes
Variable Size 109051944 bytes
Database Buffers 50331648 bytes
Redo Buffers 6369280 bytes
Database mounted.
Database opened.

Após isso conect no banco.


connect sys/senha_do_sys@nome_da_instancia as sysdba