OraFAQ Forum: Enterprise Manager » Problem about startup database with ASM

Home » RDBMS Server » Enterprise Manager » Problem about startup database with ASM

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

Problem about startup database with ASM [message #221036]

Fri, 23 February 2007 06:03

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.

Report message to a moderator

Re: Problem about startup database with ASM [message #221112 is a reply to message #221036]

Fri, 23 February 2007 23:09

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

Report message to a moderator

Re: Problem about startup database with ASM [message #221232 is a reply to message #221112]

Sun, 25 February 2007 21:16

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 1073 times)

Report message to a moderator

Re: Problem about startup database with ASM [message #221233 is a reply to message #221232]

Sun, 25 February 2007 22:07

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

Report message to a moderator

Re: Problem about startup database with ASM [message #221234 is a reply to message #221233]

Sun, 25 February 2007 22:26

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.

Report message to a moderator

Re: Problem about startup database with ASM [message #221236 is a reply to message #221234]

Sun, 25 February 2007 22:38

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

Report message to a moderator

Re: Problem about startup database with ASM [message #221244 is a reply to message #221236]

Sun, 25 February 2007 23:21

kennydotcom
Messages: 5
Registered: February 2007
Location: THAILAND

Junior Member

Now, I will set automatic already but it can not automatic database.

Report message to a moderator

Previous Topic:	Agent Connection to Instance
Next Topic:	add targets to OEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:02:03 CST 2024