SQL*Plus (MOSC)

MOSC Banner

Unable to connect sys as sysdba locally

edited Feb 27, 2018 2:17PM in SQL*Plus (MOSC) 4 commentsAnswered ✓

here is my environment

  1. Oracle 12.2
  2. NON-CDB
  3. The oracle user is part of dba and oinstall group as follows$ id oracle uid=1000(oracle) gid=54322(dba) groups=54322(dba),54321(oinstall)
  4. The ORAPW file has been created using ORAPWD utility
  5. ORACLE_HOME and ORACLE_SID set to DBALIAS

Here is my problem:

I can connect using following meethods

a. sqlplus SYS"@DBALIAS" as sysdba ( it asks for password )

b. sqlplus SYS/PW@DBALIAS as sysdba

But when I use following, I get ORA-12154 error

sqlplus '/ as sysdba'

ERROR: ora-12154: TNS: could not resolve the connect identifier specified

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