on 02-24-2011 6:15 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the following
Is Database up?
Is listener running in the server side?
try tnsping from client machine
tnsping INSTANCENAME
Regards,
Yuva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.