Home » RDBMS Server » Server Administration » problem in opening the databae (windows xp)
problem in opening the databae [message #291927] Mon, 07 January 2008 04:45 Go to next message
amitraidit
Messages: 10
Registered: January 2008
Location: gwalior
Junior Member

Sir,

i am new in the field, and i have a problem, as we had make our database using dbca,and we have inserted so many records inthat dbase, now the prob is that, few days before an error msg :oracle shutdown in progress,after that every time when i am trying to open the database it display an error:ora-12541:no listener, i have done all the scripiting but it doesn't open.
shall the database is recovered as it was very imp to me.
consider me as a fresh graduate.
Re: problem in opening the databae [message #291933 is a reply to message #291927] Mon, 07 January 2008 05:03 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What does your alert log show?

At the very least, you should really look over:

* 2 Day DBA
* Platform Guide for Microsoft Windows
Re: problem in opening the databae [message #291941 is a reply to message #291927] Mon, 07 January 2008 05:19 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member

Please remember to give details regarding Your OS Platform, Oracle Version & Oracle Error you got in your future posts.

Do not worry your database is safe & fully recoverable. I assume you are on windows.

Run LSNRCTL utility from command line & see all commands available in it. Use status command to see status of your listener. If you can not see that listener is running from status command output then issue start command on listener prompt. this should start your listener. after starting listener restart your instance or wait for 1 minute for instance to register its services with newly started listener. Ensure status command shows listener listening end points & database services it is listening for. If still not successful then please post output of listener status command & start command in your next post along with your OS version + oracle version

Regards

mkbhati
Re: problem in opening the databae [message #291942 is a reply to message #291933] Mon, 07 January 2008 05:21 Go to previous messageGo to next message
amitraidit
Messages: 10
Registered: January 2008
Location: gwalior
Junior Member

sir , actually that's why i am asking you, i don't know where is Alert log, you have to teach me or suggest me.
Re: problem in opening the databae [message #291952 is a reply to message #291942] Mon, 07 January 2008 05:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Show right there in one of the docs I listed above...(Alert Logs).
Re: problem in opening the databae [message #292115 is a reply to message #291952] Mon, 07 January 2008 21:55 Go to previous messageGo to next message
amitraidit
Messages: 10
Registered: January 2008
Location: gwalior
Junior Member

sir, i ask abt the prob yesterday , that our database is not open , as we had created through dbca, every time when trying to open error ora 12541:tns : no listener, for that i create newe listener using net manager, n i issue the command
> set oracle_sid=" "
> sqlplus
> sys/tiger as sysdba
not sql prompt appear in cmd prompt, connected , but in idle instance,
so plz tell me the further steps so that i can open my database

Regards
Re: problem in opening the databae [message #292122 is a reply to message #292115] Mon, 07 January 2008 22:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

"on sql prompt give "startup" command".
SQL> startup


And please go through Ebrain mentioned links.
Re: problem in opening the databae [message #292147 is a reply to message #291927] Tue, 08 January 2008 00:57 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

i am new in the field

How much new are you in this field that you even don't know how to start a database Mad
Re: problem in opening the databae [message #292245 is a reply to message #292115] Tue, 08 January 2008 04:54 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
amitraidit wrote on Mon, 07 January 2008 22:55

i issue the command
> set oracle_sid=" "
> sqlplus
> sys/tiger as sysdba
not sql prompt appear in cmd prompt, connected , but in idle instance,


What is this? Did you really set your oracle_sid to " " ?

You need to set the oracle_sid to the name of your database.

For furutre posts, please read OraFAQ Forum Guide. Please format posts prior to posting and do not use IM talk.
Re: problem in opening the databae [message #292296 is a reply to message #292115] Tue, 08 January 2008 08:22 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
amitraidit wrote on Mon, 07 January 2008 22:55

sir, i ask abt the prob yesterday , that our database is not open , as we had created through dbca, every time when trying to open error ora 12541:tns : no listener, for that i create newe listener using net manager, n i issue the command
> set oracle_sid=" "
> sqlplus
> sys/tiger as sysdba
not sql prompt appear in cmd prompt, connected , but in idle instance,
so plz tell me the further steps so that i can open my database

Regards


Maybe you used IM speak in issuing your Oracle commands.
Re: problem in opening the databae [message #292354 is a reply to message #292296] Tue, 08 January 2008 12:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Laughing ...yeah, where is that terminal emulator that supports IM speak ??
Re: problem in opening the databae [message #294636 is a reply to message #292245] Fri, 18 January 2008 04:42 Go to previous messageGo to next message
amitraidit
Messages: 10
Registered: January 2008
Location: gwalior
Junior Member

hi , i need to know about how to take backup using oem console on oracle 10g on windows platform,or prefeer any web site where i can see step by step of backup
Re: problem in opening the databae [message #294637 is a reply to message #294636] Fri, 18 January 2008 04:44 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a new topic on Entreprise Manager forum for this.
Don't hijack the other topic.

Regards
Michel
Previous Topic: Partioned index.(cannot extent segment size)
Next Topic: Blocking_session in v$session
Goto Forum:
  


Current Time: Sun Dec 11 04:06:18 CST 2016

Total time taken to generate the page: 0.09163 seconds