OraFAQ Forum: Server Administration » Trying to putinto archivelog mode-shutdown and can't restart

Home » RDBMS Server » Server Administration » Trying to putinto archivelog mode-shutdown and can't restart

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trying to putinto archivelog mode-shutdown and can't restart [message #268445]

Tue, 18 September 2007 12:06

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?

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

wbez
Messages: 4
Registered: September 2007

Junior Member

at this point I cannot get the TNS LISTENER to acknowledge that database at all either

Report message to a moderator

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

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;

Report message to a moderator

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

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?

Report message to a moderator

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

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.

Report message to a moderator

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

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;

Report message to a moderator

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

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:04:30 CDT 2024