Database Administration (MOSC)

MOSC Banner

Remote sys connection

edited Feb 13, 2019 2:52AM in Database Administration (MOSC) 19 commentsAnswered

Hi

I can't open a remote sysdba connection in oracle 18c.

I suppose that i have a problem with the orapwd file because:

SQL> grant sysdba to dni;

grant sysdba to dni

*

ERROR at line 1:

ORA-01994: Password file missing or disabled

SQL> select * from V_$PWFILE_USERS;

no rows selected

I've created the orapwd in that way:

orapwd create file='/u01/app/oracle/product/18.0.0/dbhome_1/dbs/orapwdexpweb' password=w******

I supose that te name is correct:

select INSTANCE_NAME from v$instance;

INSTANCE_NAME

----------------

expweb

And i have configurated  the remote_login_passwordfile parameter:

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center