Home » RDBMS Server » Enterprise Manager » Problem about startup database with ASM
Problem about startup database with ASM [message #221036] Fri, 23 February 2007 06:03 Go to next message
kennydotcom
Messages: 5
Registered: February 2007
Location: THAILAND
Junior Member

I create new database with ASM and create complete.
Detail
1. one disk group and 2 disk member by extent
2. after create database. I open em it not show problem.
3. restart server again.
4. after restart server. all oracle Service started already.
5. open em.
6. found error message about these:
Database instance can not start.
Agent not start.
Listener start.
7. try to connect by sqlplus. it show message "Connect an iden instance".
8. startup database it show connected.

"I want to open servar and user can connect database". It now can not connect.
Re: Problem about startup database with ASM [message #221112 is a reply to message #221036] Fri, 23 February 2007 23:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

I want to open servar and user can connect database". It now can not connect

Any error message you got when you try to connect ?

regards
Taj
Re: Problem about startup database with ASM [message #221232 is a reply to message #221112] Sun, 25 February 2007 21:16 Go to previous messageGo to next message
kennydotcom
Messages: 5
Registered: February 2007
Location: THAILAND
Junior Member

after to restart database service. I can connect my database, but I restart server again and open em againg database can't start.
  • Attachment: ora-error.JPG
    (Size: 99.91KB, Downloaded 873 times)
Re: Problem about startup database with ASM [message #221233 is a reply to message #221232] Sun, 25 February 2007 22:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
In your above page your database status is down. means your database is not open. you have to first open your database through below command.
conn sys as sysdba
sql>startup



regards
Taj
Re: Problem about startup database with ASM [message #221234 is a reply to message #221233] Sun, 25 February 2007 22:26 Go to previous messageGo to next message
kennydotcom
Messages: 5
Registered: February 2007
Location: THAILAND
Junior Member

Hi,
I can startup database by manual but I want automatic startup database when I open server.
Re: Problem about startup database with ASM [message #221236 is a reply to message #221234] Sun, 25 February 2007 22:38 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
What is your OS system
1.Windows.
go .. start .... run ... services.msc <<enter>>
change STARTUP TYPE of OracleService<sid> MANUAL to AUTOMATIC.

if linux version then first which Oracle Version.
according your version you can use DBSTART or DBSHUT script for automatic start on boot.


regards
Taj
Re: Problem about startup database with ASM [message #221244 is a reply to message #221236] Sun, 25 February 2007 23:21 Go to previous message
kennydotcom
Messages: 5
Registered: February 2007
Location: THAILAND
Junior Member

Now, I will set automatic already but it can not automatic database.
Previous Topic: Agent Connection to Instance
Next Topic: add targets to OEM
Goto Forum:
  


Current Time: Fri Mar 29 00:16:47 CDT 2024