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!

not able to connect with sysdba

Tony007Jan 28 2017 — edited Jan 28 2017

hi am not able to connect with sysdba i have done the following

C:\>tnsping mcor

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 28-JAN-2017 08:54:36

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS

C:\>set ORACLE_HOME=D:\App\OracleUser\product\12.1.0\dbhome_1

C:\>tnsping dbname

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 28-JAN-2017 08:55:39

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

D:\App\OracleUser\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbname)))

OK (110 msec)

C:\>SQLPLUS /NOLOG

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 28 08:55:54 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

SQL> connect /as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

SQL> exit

C:\>set ORACLE_SID=dbname

C:\>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jan 28 08:56:46 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

SQL> connect /as sysdba

ERROR:

ORA-01017: invalid username/password; logon denied

sysconnect.jpg

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2017
Added on Jan 28 2017
5 comments
532 views