Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
3 comments
257 views