| ORA-12203 error. [message #455065] |
Mon, 10 May 2010 01:30  |
ateeqrahman786
Messages: 52
Registered: December 2009
Location: Hyderabad,India
|
Member |
|
|
I am facing a peculiar problem with installation of 8.0.6 database on win 2003 server. I have installed the software and when i try to connect INTERNAL, i get an ORA-12203 error. I cant create a database because of the same error.
I do the following steps:
1) Open the server manager.
2) issue the following command
svrmgr> connect internal
password:
when i type password and press ENTER, i get the following error:
ORA-12203:TNS :unable to connect to destination
Some info abt TNS and Listener Status
This is the tns entry
orcl.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 134.50.0.10)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
--------------------------------------------
This is the lsnrctl status
Alias - LISTENER
Listener Parameter File - D:\orant\NET80\admin\listener.ora
Listener log file - D:\orant\NET80\LOG\LISTENER.LOG
Services Summary...
ORCL has 1 service handler(s) //My SID=ORCL
extproc has 1 service handler(s)
The command completed successfully.
-------------------------------------------------
I have checked the entries in registry and they have correct ORACLE_HOME and other file locations.
Best Regards,
Atiq
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
