Home » Infrastructure » Windows » Getting error when starting oracle 10g on windows 2003 server
Getting error when starting oracle 10g on windows 2003 server [message #148062] Tue, 22 November 2005 09:04 Go to next message
rpnalluri
Messages: 3
Registered: November 2005
Location: hyd
Junior Member
Hi,
I have installed oracle 10g on windows 2003 server. This server also have ADS. When i install oracle 10g its running fine. After restarting ther server and when i try to open database from sql plus its giving following error:

ORA-12514
TNS: listner does not currently know of service requested in connect descripter

Even when i am trying to connect from enter prise manger its giving error like database shutdown.

Please let me know what is the solution for this.

Thanks,
Raja.

Report message to a moderator

Re: Getting error when starting oracle 10g on windows 2003 server [message #148148 is a reply to message #148062] Tue, 22 November 2005 22:49 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Are you sure the service_name you provided in the connect descripter is correct?

Can you connect to the database without specifying service_name ?

Report message to a moderator

Re: Getting error when starting oracle 10g on windows 2003 server [message #148155 is a reply to message #148148] Tue, 22 November 2005 23:33 Go to previous messageGo to next message
rpnalluri
Messages: 3
Registered: November 2005
Location: hyd
Junior Member
Hi,

I am not able to connect to database without specifying service_name.
Could you please let me know how to check service_name?

when i am trying to connect from command prompt its giving like shared memory realm does not exist.

Could you please let me know what could be the problem?

Process i did:
I have installed windows 2003 enterprise edition in PIV system with 1 GB RAM. After that i have configured ADS and DNS server for this system.
After that i have installed oracle 10g, when i installed its working fine. After i restart the system its giving problem.

Thanks,
Raja.

Report message to a moderator

Re: Getting error when starting oracle 10g on windows 2003 server [message #148156 is a reply to message #148155] Tue, 22 November 2005 23:37 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Here lies the problem " shared memory realm does not exist" .

Oracle database service is not running.

Go to control panel--> Administrative tools --> services

and there you will find a service named "OracleserviceYOUR_DATABASE_NAME" , start this service and then try to login.

Report message to a moderator

Re: Getting error when starting oracle 10g on windows 2003 server [message #148157 is a reply to message #148156] Tue, 22 November 2005 23:46 Go to previous messageGo to next message
rpnalluri
Messages: 3
Registered: November 2005
Location: hyd
Junior Member
Hi,
Thanks for your quick reply, I have tried this but still i am getting same error.

Thanks,
Raja.

Report message to a moderator

Re: Getting error when starting oracle 10g on windows 2003 server [message #148220 is a reply to message #148157] Wed, 23 November 2005 03:16 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Ok that means ORACLESERVICE is running. So it means that your database is down. Do this

--> Login from SQLPLUS as SYS user.

--> Fire this command

 startup


regards,
tarun

Report message to a moderator

Previous Topic: Oracle 9i in Windows 2003
Next Topic: Oracle Lite 10g 10.02.00.01
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 02:39:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.