Home » RDBMS Server » Server Administration » Database upgrade using dbua
icon5.gif  Database upgrade using dbua [message #255615] Wed, 01 August 2007 05:27 Go to next message
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,
Re: Database upgrade using dbua [message #255617 is a reply to message #255615] Wed, 01 August 2007 05:40 Go to previous messageGo to next message
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
icon3.gif  Re: Database upgrade using dbua [message #255620 is a reply to message #255615] Wed, 01 August 2007 05:48 Go to previous messageGo to next message
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.
Re: Database upgrade using dbua [message #255622 is a reply to message #255615] Wed, 01 August 2007 05:54 Go to previous messageGo to next message
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
Re: Database upgrade using dbua [message #255627 is a reply to message #255622] Wed, 01 August 2007 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Re: Database upgrade using dbua [message #255846 is a reply to message #255615] Thu, 02 August 2007 01:29 Go to previous messageGo to next message
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,
Re: Database upgrade using dbua [message #255961 is a reply to message #255846] Thu, 02 August 2007 10:08 Go to previous messageGo to next message
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.
Re: Database upgrade using dbua [message #256130 is a reply to message #255615] Fri, 03 August 2007 02:00 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
The pmon,smon and other background processes.

Regards,
Re: Database upgrade using dbua [message #256274 is a reply to message #256130] Fri, 03 August 2007 11:19 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
No You Can't disable or delete BACKGROUND Processes.
But you disable ARCN.
Re: Database upgrade using dbua [message #256348 is a reply to message #255846] Sat, 04 August 2007 00:17 Go to previous message
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
Previous Topic: "GRANT CONNECT" only possible as SYSDBA
Next Topic: TEMP tablespace full in AIX oracle9i
Goto Forum:
  


Current Time: Thu Dec 08 12:31:57 CST 2016

Total time taken to generate the page: 0.15641 seconds