Home » RDBMS Server » Server Administration » Trying to putinto archivelog mode-shutdown and can't restart
Trying to putinto archivelog mode-shutdown and can't restart [message #268445] Tue, 18 September 2007 12:06 Go to next message
wbez
Messages: 4
Registered: September 2007
Junior Member
I was trying to put my database in archivelog mode. I shut down and now cant do startup mount command:


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

what do I do next?
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268461 is a reply to message #268445] Tue, 18 September 2007 15:08 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:

ORA-24324
ORA-24324: service handle not initialized
Cause: An attempt was made to use an improper service context handle.
Action: Verify that the service context handle has all the parameters initialized prior to this call.
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268464 is a reply to message #268445] Tue, 18 September 2007 15:36 Go to previous messageGo to next message
wbez
Messages: 4
Registered: September 2007
Junior Member
Thank you for responding, but can you please provide specifics? I am not a dba and very new to this. We have no dba at all here, and need to create backups. So I was just trying to put this data base in archivelog mode to begin working with the back ups. ANY detailed step by step info is appreciated.
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268465 is a reply to message #268461] Tue, 18 September 2007 15:37 Go to previous messageGo to next message
wbez
Messages: 4
Registered: September 2007
Junior Member
at this point I cannot get the TNS LISTENER to acknowledge that database at all either
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268474 is a reply to message #268465] Tue, 18 September 2007 16:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
1:alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
1-1:Shutdown immediate
2:starup mount
3:alter database archivelog;
4:alter database open;

Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268487 is a reply to message #268445] Tue, 18 September 2007 17:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
wbez wrote on Tue, 18 September 2007 13:06
I was trying to put my database in archivelog mode.


Exactly how did you do that? What commands did you issue? What version of the database are you using?
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268769 is a reply to message #268474] Wed, 19 September 2007 11:59 Go to previous messageGo to next message
wbez
Messages: 4
Registered: September 2007
Junior Member
Thank you for the response. I will try addint the alter system log_archive_format . . . . statement you specified to my process. At this point my database is down and I can't bring it back up, short of shutting down the server. I did the shutdown immediate statment yesterday and the startup mount statement didn't work. So I can't get back onto the datebase to issue any statements at this point. DO I NEED to shutdown the server? I have other databases on it that I would like not to affect if possible.
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #268771 is a reply to message #268769] Wed, 19 September 2007 12:07 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You database is already shutdown you need to start it again

sqlplus 'sys as sysdba'

then startup mount;
Re: Trying to putinto archivelog mode-shutdown and can't restart [message #269174 is a reply to message #268771] Thu, 20 September 2007 23:18 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello wbez,

Complementing DreamzZ suggestion and considering:
wbez wrote
I have other databases on it that I would like not to affect if possible.


When you run:
env |grep ORACLE_SID
Do you see the database sid that you want to startup?

If no... issue the following commands: (are you on the server or remote?)
ORACLE_SID=<your database sid>
export ORACLE_SID
sqlplus /nolog
conn sys as sysdba


Then post your status after this suggestion above.
Regards,


mson77

============
Please inform:
Your OS and oracle version (4 decimals).
Above I consider that your platform is linux/unix (non-windows).

[Updated on: Thu, 20 September 2007 23:28]

Report message to a moderator

Re: Trying to putinto archivelog mode-shutdown and can't restart [message #270225 is a reply to message #269174] Wed, 26 September 2007 03:35 Go to previous message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hello wbez,
I think your services not listening to TNS Listener. Check the status of the listener.
C:\> LSNRCTL STATUS
View the Instance ready UNKNOWN or BLOCKED.
If it is blocked then restart your service in the services window.
and check the status of the listener.
and try to start the instance again.
thats my opinion.
Try it...

Naveen
Previous Topic: Error while creating database on 10.2 enterprise eidition
Next Topic: Can't change NLS_LANG in Oracle XE
Goto Forum:
  


Current Time: Sat Dec 10 18:20:55 CST 2016

Total time taken to generate the page: 0.07282 seconds