 ORA-12545 Error "Target host or object does not exist", pls HELP [message #109065] |
Mon, 21 February 2005 17:29  |
volverin
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Hi everyone,
I am a newbie in Oracle and I have troubles connecting to a newly created Oracle 9i DB on Windows XP SP2. This is a local installation and I have nothing to do with the network, I don't care about networking, all I wanna do is access the database on my pc from my pc (locally). I created the instance through the database configuration assistant with the configuration of the attached file. When I log on through SQL PLUS, I provide the username and password but no Host String and it is working fine. However when I try to use the Oracle Enterprise Manager Console using any of the accounts working with SQLPlus I get the ORA-12545 Error. I tried to use the Net Manager and Net Configuration Assistant but I didn't get any further. I checked in the services and the OracleOraHome92TNSListener as well as the OracleServiceEAP have started. If anyone can help me, please do so. Below is the tnsnames.ora located in C:\oracle\ora92\network\admin like the rest of the files:
EAP.RDBMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EAP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = EAP)
(SERVER = DEDICATED)
)
)
And the listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vas)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EAP))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
)
)
Finally, the sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-
Attachment: EAP.HTML
(Size: 20.19KB, Downloaded 1873 times)
[Updated on: Mon, 21 February 2005 17:36] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: ORA-12545 Error "Target host or object does not exist", pls HELP [message #135733 is a reply to message #109065] |
Fri, 02 September 2005 05:10  |
aparnapallavi
Messages: 28
Registered: June 2005
|
Junior Member |
|
|
hello
I am having a similar problem as mentioned above but my tns file and listner file are very confusing to use the solution given above. Could anyone help me with this?
tnsnames.ora file
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
JAVADB.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = client2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = javaDB.com)
)
)
INST1_HTTP.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = client2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listner.ora file
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\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 = client2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = javaDB.com)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = javaDB)
)
)
could i simply change all the host names and key names to client2 to get it working?
Pls. help
Aparna
|
|
|
|
|
|
|
|
| Re: ORA-12545 Error "Target host or object does not exist", pls HELP [message #136002 is a reply to message #135990] |
Mon, 05 September 2005 06:08 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
What is the SID of ur database ?
Is it javaDB or javaDB.com ?
Pls make it clear.
See my listener.ora looks like this .
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tarun)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = tanudb1)
)
)
Notice here -- SID_NAME = tanudb1
And tnsnames.ora
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Tarun)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TANUDB1_TARUN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tarun)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tanudb1)
(SERVER = DEDICATED)
)
)
And here SID= tanudb1.
But i think in ur case they differ, it might be the problem.
check it out.
regards,
tarun
[Updated on: Mon, 05 September 2005 06:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
