|
|
|
|
| Re: SVRMGR30.EXE [message #142129 is a reply to message #142052] |
Thu, 13 October 2005 09:25   |
SJDewar
Messages: 15
Registered: July 2005
|
Junior Member |
|
|
Hi, thanks for replying.
When I enter 'set ORACLE_SID=pimt' (which is the SID for the training database) I still get the message, ORA-12203: TNS: Unable to connect to destination.
I do get the SVRMGR prompt.
Is there anything else I could check/sort?
Thanks,
S.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SVRMGR30.EXE [message #143414 is a reply to message #142046] |
Thu, 20 October 2005 07:02 |
bmahireddy
Messages: 14
Registered: March 2005
|
Junior Member |
|
|
1. Check for correctness of the entry in TNS Names like Host, Port, protocol.
2. Try to ping the host server, if you are unable to ping then it could be network problem
3. Try tnsping, if you are unable to do it then your entry in tnsnames is incorrect
|
|
|
|
| Re: SVRMGR30.EXE [message #145296 is a reply to message #142046] |
Wed, 02 November 2005 05:17 |
SJDewar
Messages: 15
Registered: July 2005
|
Junior Member |
|
|
Hi,
Many thanks for the replies.
Are the entries for SID_NAME in the listener file and the tnsnames file case sensitive?
If the SID_NAME in tnsnames is pimT and the SID_NAME in the Listener file is pimt will this cause a problem?
Thanks,
S.
|
|
|
|
| Re: SVRMGR30.EXE [message #146004 is a reply to message #145296] |
Tue, 08 November 2005 02:44 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
NO in win2k server this wont be an issue.
Please do post your tnsnames.ora listener.ora & sqlnet.ora file here for further investigation.
--Girish
|
|
|
|
| Re: SVRMGR30.EXE [message #146086 is a reply to message #146004] |
Tue, 08 November 2005 09:23 |
SJDewar
Messages: 15
Registered: July 2005
|
Junior Member |
|
|
Hi,
Please see tnsnames, listener and sql.net files.....
tnsname.ora
# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:D:\orant\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
PIME.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.1.247)(PORT = 1521))
(CONNECT_DATA = (SID = pimE))
)
PIMT.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.1.247)(PORT = 1521))
(CONNECT_DATA = (SID = pimT))
)
PIMD.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.1.247)(PORT = 1521))
(CONNECT_DATA = (SID = pimD))
)
PIMP.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.1.247)(PORT = 1521))
(CONNECT_DATA = (SID = pimP))
)
listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= pimd)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= pime)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= pimp)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= pimt)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= 10.21.1.247)
(PIPE= ORAPIPE)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 10.21.1.247)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 10.21.1.247)
(Port= 1526)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = pimd.world)
(SID_NAME = pimd)
)
(SID_DESC =
(GLOBAL_DBNAME = pime.world)
(SID_NAME = pime)
)
(SID_DESC =
(GLOBAL_DBNAME = pimp.world)
(SID_NAME = pimp)
)
(SID_DESC =
(GLOBAL_DBNAME = pimt.world)
(SID_NAME = pimT)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)
sql.net
TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off
Thanks in advance for your help.
S.
|
|
|
|
|
|
| Re: SVRMGR30.EXE [message #147812 is a reply to message #146860] |
Mon, 21 November 2005 04:19 |
SJDewar
Messages: 15
Registered: July 2005
|
Junior Member |
|
|
Hi,
I can connect to the database okay. I'm just concerned about what configuration setting is causing me to get the message...ORA-12203: TNS: Unable to connect to destination, when I start SVRMGR.
Thanks,
S.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
