|
|
|
|
| Re: problem in opening the databae [message #291941 is a reply to message #291927] |
Mon, 07 January 2008 05:19   |
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 #292115 is a reply to message #291952] |
Mon, 07 January 2008 21:55 |
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 #292296 is a reply to message #292115] |
Tue, 08 January 2008 08:22 |
joy_division
Messages: 4963
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
...yeah, where is that terminal emulator that supports IM speak ??