Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 23ai FREE logon as SYSDBA only via Listener

mpatzwahlFeb 10 2025 — edited Feb 10 2025

Hi,

you know the sentance: i have nothing changed but … today starting login as sysdba is not possible via ipc.

sqlplus sys/pwd as sysdba

ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Hilfe: https://docs.oracle.com/error-help/db/ora-01017/

sqlplus / as sysdba

ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Hilfe: https://docs.oracle.com/error-help/db/ora-01017/

sqlplus sys/pwd@10.0.0.2/FREE as sysdba

=> O K

sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES=(NTS)

SQLNET.NO_NTLM=FALSE

id

uid=54321(oracle) gid=54322(dba) groups=54322(dba),54321(oinstall),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

What is this?

PS: I have also rebuild the password file…

Thanks,

Marco

Comments
Post Details
Added on Feb 10 2025
4 comments
892 views