-
ORA-12560: TNS:protocol adapter error
Hi i have read all the other posts about this error but i cant seem to find on how can i fix this problem. i already tried all the suggestions you told to other people encountering this but it seems it doesnt work on me. here are the details:
(tnsnames.ora)
TREE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
)
(CONNECT_DATA = (SID = tree)(SERVER = DEDICATED))
)
TREE.PH.ENTERWORKS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = TREE))
)
(listener.ora)
# LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tree)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = tree)
)
)
TREE.PH.ENTERWORKS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tree)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TREE)
)
)
(sqlnet.ora)
# SQLNET.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = tree.ph.enterworks.com
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
====================================================================
I was trying to export a table thru Enterprise Manager Console and i always got failed. Also, i tried exporting using a DOS command: "exp userid=ora_88836/ora_88836 file=wyndat.dmp owner=ora_88836" and thru this i get to have an error ORA-12560: TNSrotocol adapter error. Then i tried logging thru the SQL Plus using (ora_88836/ora_88836) with a Host string as tree i got connected then i exited the SQL Plus. Then i tried logging in SQL Plus using (ora_88836/ora_88836) without a Host String i get the error TNSrotocol adapter error.
Thank you!
-
Set Oracle_Sid in environment variable to default to TREE
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
The default domain is wrong...
NAMES.DEFAULT_DOMAIN = tree.ph.enterworks.com
should be
NAMES.DEFAULT_DOMAIN = ph.enterworks.com
-
I am not sure this will solve your problem.
Since you are getting protocol adapter error while using sqlplus without net service names, please check this..
If you have 2 oracle homes in your machine, make the two tnsnames.ora files identical. (ORACLE_HOMEx\network\admin)
Database Administrator
Convergys, Hyderabad, India
-
Thanks guys! i did all your suggestions..it worked..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|