Database Administration (MOSC)

MOSC Banner

can't login with sys/password@sid as sysdba

Hello,

I have installed new Oracle 12.2.0.1 Database/software on AIX Machine and i'm able to connect using SQLPLUS / as sysdba

but if i use for example sqlplus sys/password@sid as sysdba it gives me ORA-01017: invalid username/password; logon denied

Also same if i'm connecting from sql developer.


Please note that i'm able to connect with system user on sql developer


also i tried to reset the sys password by:

alter user sys identified by password;

also tried :

orapwd file=orapwora81 entries=30

and entered sys password

but still have the same error.


SQL> show parameter remote;


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