Home » RDBMS Server » Server Administration » Oracle 10g Installation Doubt
Oracle 10g Installation Doubt [message #229511] Mon, 09 April 2007 01:18 Go to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi All,

My development server had Oracle 9207 on AIX 5.3. Now i want to install 10gR2 added to that(Software Only). After few days i can remove the Oracle 9i.

Kindly tell me what are the points to remember in installing. B'cos i want to install 10g similar to the 9i directories like ORACLE_BASE, ORACLE_HOME etc.

My existing ORACLE_HOME for 9i is /u01/app/oracle

Thanks in advance

Magesh

Re: Oracle 10g Installation Doubt [message #229515 is a reply to message #229511] Mon, 09 April 2007 01:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can install oracle 10g without problem..
becuase every Oracle Software create separate ORACLE_HOME..
it is not include in ORACLE_HOME of Oracle 9i.


During installation it will ask for Oracle_home of oracle 10g.

that you should define whatever you want.


Regards
Taj

[Updated on: Mon, 09 April 2007 01:44]

Report message to a moderator

Re: Oracle 10g Installation Doubt [message #229519 is a reply to message #229515] Mon, 09 April 2007 01:29 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi Taj,

Thanks for your valued reply. Also kindly clear me the doubts that later can i move my 9i db to 10g by export dump (All the tablespaces and datafiles only)
Re: Oracle 10g Installation Doubt [message #229523 is a reply to message #229519] Mon, 09 April 2007 01:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
later can i move my 9i db to 10g by export dump (All the tablespaces and datafiles only)


First yes you can upgrade.but it is depand on some condition which method you should choose.

1.If database is small then you can go with Original EXPORT/IMPORT option.

2.If database size is big then you should use DBUA database upgrade assistant and upgrade you database.

Regards
Taj
Re: Oracle 10g Installation Doubt [message #229529 is a reply to message #229523] Mon, 09 April 2007 01:42 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi Taj

My total size of the database is

total_size
----------
6.7112E+10


Now tell me whether this could be performed by export/import?

The above result will be found by the following querry:

select a.data_size+b.temp_size+c.redo_size "total_size"
from ( select sum(bytes) data_size
from dba_data_files ) a,
( select nvl(sum(bytes),0) temp_size
from dba_temp_files ) b,
( select sum(bytes) redo_size
from sys.v_$log ) c
/

Thanks
Re: Oracle 10g Installation Doubt [message #229543 is a reply to message #229529] Mon, 09 April 2007 02:04 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Don't export complete database just export SCHEMA level and import in 10g.

or
you should use DBUA becuase if schema size is also big.


Regards
Taj
Previous Topic: apex....
Next Topic: Datafiles in oracle 9
Goto Forum:
  


Current Time: Wed Dec 07 22:14:02 CST 2016

Total time taken to generate the page: 0.22847 seconds