Home » RDBMS Server » Networking and Gateways » ORA-12203 error. (8.0.6, win 2003 server)
ORA-12203 error. [message #455065] Mon, 10 May 2010 01:30 Go to next message
ateeqrahman786
Messages: 51
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
Re: ORA-12203 error. [message #455070 is a reply to message #455065] Mon, 10 May 2010 01:45 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://forums.oracle.com/forums/thread.jspa?messageID=4285442
IF you are same user the answer the questions asked

sriram
Re: ORA-12203 error. [message #455071 is a reply to message #455070] Mon, 10 May 2010 01:46 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Please go through MOS Note: 214124.1 and 61621.1

sriram
Re: ORA-12203 error. [message #455074 is a reply to message #455071] Mon, 10 May 2010 01:51 Go to previous messageGo to next message
ateeqrahman786
Messages: 51
Registered: December 2009
Location: Hyderabad,India
Member
sorry for my ignorance,

where can i find these notes? Are these available on oracle support? MOS Note: 214124.1 and 61621.1
Re: ORA-12203 error. [message #455078 is a reply to message #455074] Mon, 10 May 2010 01:55 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
https://support.oracle.com/CSP/ui/flash.html
Previous Topic: oracle tomcat conflict port 8080
Next Topic: error ORA-02019: while selecting table from oracle10g to SQL Server 2005
Goto Forum:
  


Current Time: Thu Nov 27 13:01:45 CST 2014

Total time taken to generate the page: 0.09415 seconds