Topic: Database Administration >> ORA-12154: TNS:could not resolve service name"
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-12154: TNS:could not resolve service name" |
| vikhardba |
Posted: Sep 23, 2007 07:34:30 AM |
Total Post: 86
Joined: Apr, 2007
|
Hi to One and All,
ISSUE :
------
I am using Oracle 9i on Win 2000 platform, unable to access Enterprise manager "OEM" console, when doing so, i am getting ORA-12154: TNS:could not resolve service name" error message. Where as listener and tns working fine. Also, able to connect to sql prompt..
WAT TRIED TO RESOLVE THE ISSUE:
-------------------------------
1. Checked that the instance database name is being typed in correctly.
2. Checked the tnsnames.ora file to validate that the instance name has been typed correctly.
3. Deleted and recreated, listener and tns respectively but no luck.
Following are the contents in my listener.ora, tnsnames.ora and sqlnet.ora
--------------------------------------------------------------------------
LISTENER.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohammed-efc2c5)(PORT = 1522))
)
)
AAA =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohammed-efc2c5)(PORT = 1530))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = test)
)
)
# PLSExtProc
TNSNAMES.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
# MODOSE
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohammed-efc2c5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = test)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TO_AAA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohammed-efc2c5)(PORT = 1530))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
SQLNET.ora
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) -- even i tried making this line uncomment, still issue is existing.
So, any help would be appreciated, thanks in advance.
Regards,
Vikhar
|
|
|
 Mohammed Taj |
| Posted: Sep 23, 2007 01:58:38 PM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
how many oracle home install or how many client install on your PC.
If more than one oracle home installation in your pc then configure each tnsnames.ora file ...and try.
Regards
Mohammed Taj
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:00:47 PM | |
|
Total Post: 418
Joined: Jun, 2008
|
Ensure that Oracle Management service is up and running.
For more details visit:
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 746 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 250 |
| Ramesh Jois | 245 |
| neeraj sharma | 243 |
| Bishal Khetan | 207 |
|
|
