| auto open problem [message #226919] |
Mon, 26 March 2007 23:18  |
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  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
