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
|
|
|
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 #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
|
|
|
|