cancel
Showing results for 
Search instead for 
Did you mean: 

Connect to oracle as sysdba from client side

Former Member
0 Kudos

Hi All,

I have installed Oracle10g on windows XP. When I am connecting to Oracle as sysdba from the server it can be connected. But whenever I am trying to connect from the client side as sysdba it's showing :

ERROR:

ORA-12560: TNS:protocol adapter error

How can I connect as sysdba from client machine?

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Souvik,

You need to run oracle service before starting database. In windows, you can start it as following :

RUN --> services.msc --> oracleserviceSID

Also, make sure tnsnames.ora and listener.ora files are correctly configured.

Once the services are started and above configuration files are adapted, start the database.

Regards,

Ankit Gupta

uwe_theisinger
Explorer
0 Kudos

Hi Souvik,

try following synax

sqlplus sys@dbname as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 24 15:13:33 2011

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

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

But there some requirements:

1st --> you need a passwordfile on server side

2nd --> set Oracle Parameter remote_login_passwordfile to value exclusive

regards

Uwe

Former Member
0 Kudos

It seems a pure Oracle issue, Try to google the error or post this query on Oracle Forum.

*Oracle 10.2.0.1 is not supported by SAP, Here the error is with your listener. Start the listener and try to connect.

Regards,

NIck Loy

yuvaraj_r2
Participant
0 Kudos

Hi,

Check the following

Is Database up?

Is listener running in the server side?

try tnsping from client machine

tnsping INSTANCENAME

Regards,

Yuva.

Former Member
0 Kudos

Sir,

I think you are not getting my problem correctly...........When I am connecting as scott/tiger it gets connected. But I am unable to connect as sysdba from my client machine. Refer to the following:

C:\Users\souvik.nandi>sqlplus scott/tiger@orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 24 13:41:01 2011

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

SQL>

SQL>

SQL>

SQL>

SQL> conn /as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Warning: You are no longer connected to ORACLE.

Edited by: Souvik Nandi 0812 on Feb 24, 2011 1:39 PM

yuvaraj_r2
Participant
0 Kudos

Hi,

Try this way

conn sys/<passwd> as sysdba;

Regards,

Yuva.