Home » Infrastructure » Windows » auto open problem
auto open problem [message #226919] Mon, 26 March 2007 23:18 Go to next message
the_who
Messages: 5
Registered: December 2006
Location: Bandung
Junior Member
I have database on WIndows2000 server
I have problem with auto open DB
some DB on some server can open DB autoatically...
but the other can't open automatically..stuck in nomount mode
could someone help me?
what configuration must do?
Thx
Re: auto open problem [message #226981 is a reply to message #226919] Tue, 27 March 2007 00:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
..stuck in nomount mode

Are you check alert<sid>.log file... please check and also post here for further lookup..
and are you trying to open your database manually.
alter database mount;
alter database open;



regards
Taj

[Updated on: Tue, 27 March 2007 01:00]

Report message to a moderator

Re: auto open problem [message #227104 is a reply to message #226981] Tue, 27 March 2007 06:11 Go to previous messageGo to next message
the_who
Messages: 5
Registered: December 2006
Location: Bandung
Junior Member
database off course can open when i use
alter database mount;
alter database open;

because that's not the point what i want to know
i'm want to know
why some DB can open automatically and the other stuck in nomount mode....so i must open manually

when i check at registry it same..
i look at :
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_AINK_AUTOSTART
it's : TRUE

is there anything must i check?

Thx

Re: auto open problem [message #227133 is a reply to message #227104] Tue, 27 March 2007 07:21 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\ORA_AINK_AUTOSTART


The registry value is correct... if it is FALSE then database is not open even database is not started. ( nomount).

your problem may be different because your database is started (nomount) but not mount or open.. you should check your alert<sid>.log file what is reason for this.


regards
Taj
Previous Topic: Oracle 9I patch2 on windows 2000
Next Topic: Oracle 8i installation on WinXP
Goto Forum:
  


Current Time: Wed Dec 07 04:46:53 CST 2016

Total time taken to generate the page: 0.17223 seconds