|
|
|
Supreme Being
Group: Administrators
Last Login: 1/26/2010 1:58:14 PM
Posts: 131,
Visits: 377
|
|
| Hi, When i'm trying to sqlplus '/ as sysdba' , i'm getting the following error message: # sqlplus '/ as sysdba' SQL*Plus: Release 9.2.0.7.0 - Production
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error Anyone know what to do? I tried all over the internet to search for the solution but couldn't find a solid one. Thanks,
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: 1/26/2010 1:58:14 PM
Posts: 131,
Visits: 377
|
|
| Here is the solution : You need to do either of the two things. I prefer to do both. 1. Login to your oracle account. 2. set ORACLE_SID=SID 3. set LOCAL=SID 4. check your $ORACLE_HOME/network/admin/sqlnet.ora file for any reference to EZCONNECT; if you have it remove it. This should fix your problem. Remember the "set" command is depending on what shell you are using. If you are using korn shell replace the set with "export" (i.e export ORACLE_SID=SID ) I updated my sqlnet.ora file by taking out the EZCONNECT part out. Here is a diff between my original sqlnet.ora file and the new one: /u01/oracle/product/10.2.0.4/network/admin >diff sqlnet.ora.original.062309 sqlnet.ora
4c4
< NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT)
---
> NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES) Hope this helps. Thanks,
|
|
|
|