OraFAQ Forum: Server Administration » Oracle 10g Installation Doubt

Home » RDBMS Server » Server Administration » Oracle 10g Installation Doubt

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

Oracle 10g Installation Doubt [message #229511]

Mon, 09 April 2007 01:18

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

Report message to a moderator

Re: Oracle 10g Installation Doubt [message #229515 is a reply to message #229511]

Mon, 09 April 2007 01:23

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

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)

Report message to a moderator

Re: Oracle 10g Installation Doubt [message #229523 is a reply to message #229519]

Mon, 09 April 2007 01:35

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

Report message to a moderator

Re: Oracle 10g Installation Doubt [message #229529 is a reply to message #229523]

Mon, 09 April 2007 01:42

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

Report message to a moderator

Re: Oracle 10g Installation Doubt [message #229543 is a reply to message #229529]

Mon, 09 April 2007 02:04

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

Report message to a moderator

Previous Topic:	apex....
Next Topic:	Datafiles in oracle 9

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:56:56 CDT 2024