OraFAQ Forum: Server Administration » Database upgrade using dbua

Home » RDBMS Server » Server Administration » Database upgrade using dbua

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

Database upgrade using dbua [message #255615]

Wed, 01 August 2007 05:27

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
The details of or setup are below.

Quote:

1)The OS is HP-UX
2)The oracle db version is 9.2.0.8
3)I have installed oracle 10g software of the same server as the 9i database.[different homes and software owners)
4)I created a 10g database with the same oracle_sid as oracle 9i
5)Now i used export/import to upgrade 9i to 10g database.[this was to test the objects]
6)Now i am planning to upgrade the original 9i database to 10g using dbua.
7)I modified the oratab and commented out 10g database and added 9i db details(as it cannot have multiple entries with same sid)
8)Now i invoked dbua through 10g software owner(is this right),but when i select the database to upgrade,it gives "database not mounted"
9)But the db is up and open

Can someone help me here.

Regards,

Report message to a moderator

Re: Database upgrade using dbua [message #255617 is a reply to message #255615]

Wed, 01 August 2007 05:40

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

 i select the database to upgrade,it gives "database not mounted"

After mount the database try this operation.

shutdown and then startup mount

Report message to a moderator

Re: Database upgrade using dbua [message #255620 is a reply to message #255615]

Wed, 01 August 2007 05:48

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Thanks Arju,
Even with the database mounted,i am getting the same error.

Quote:

SQL> select status from v$instance;

STATUS
------------
MOUNTED

I am getting ora-01507:database not mounted.

Report message to a moderator

Re: Database upgrade using dbua [message #255622 is a reply to message #255615]

Wed, 01 August 2007 05:54

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
The database needs to be open,I opened the db.The problem was the wrong oracle_home in oratab.I had given /ora92/ instead of /ora92

Report message to a moderator

Re: Database upgrade using dbua [message #255627 is a reply to message #255622]

Wed, 01 August 2007 06:01

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Re: Database upgrade using dbua [message #255846 is a reply to message #255615]

Thu, 02 August 2007 01:29

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
While upgrading in the last step,i cancelled the upgrade.But now i check that oracle services are created and started.Does anyone know if this can be disabled or deleted.

Regards,

Report message to a moderator

Re: Database upgrade using dbua [message #255961 is a reply to message #255846]

Thu, 02 August 2007 10:08

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

pooja_g wrote on Thu, 02 August 2007 00:29

Hi,
While upgrading in the last step,i cancelled the upgrade.But now i check that oracle services are created and started.Does anyone know if this can be disabled or deleted.

Regards,

Which Oracle Services?Can you named that.

Report message to a moderator

Re: Database upgrade using dbua [message #256130 is a reply to message #255615]

Fri, 03 August 2007 02:00

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
The pmon,smon and other background processes.

Regards,

Report message to a moderator

Re: Database upgrade using dbua [message #256274 is a reply to message #256130]

Fri, 03 August 2007 11:19

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

No You Can't disable or delete BACKGROUND Processes.
But you disable ARCN.

Report message to a moderator

Re: Database upgrade using dbua [message #256348 is a reply to message #255846]

Sat, 04 August 2007 00:17

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
that oracle services are created and started.Does anyone know if this can be disabled or deleted.

YOu can delete oracle services through ORADIM utility.
but why you want to delete this service.

Regards
Taj

Report message to a moderator

Previous Topic:	"GRANT CONNECT" only possible as SYSDBA
Next Topic:	TEMP tablespace full in AIX oracle9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:39:25 CDT 2024