Operating System - HP-UX
1748033 Members
5079 Online
108757 Solutions
New Discussion юеВ

Re: Moving temp datafile in Oracle

 
SOLVED
Go to solution
T G Manikandan
Honored Contributor

Re: Moving temp datafile in Oracle

What do you mean by moving the shared binaries?

Why is the need?


Revert

suki
Frequent Advisor

Re: Moving temp datafile in Oracle

Hi Mani,
I have copied the /opt/oracle_817 into a different directory for the newly moved instance. But earlier all the 4 instances where using the same /opt/oracle_817 Oracle_Home Directory.
Now the home directory is different for the moved database.
Thanks,
suki.
T G Manikandan
Honored Contributor

Re: Moving temp datafile in Oracle

Why are you moving the oracle_home for the moved instance?
There is no need to move the Oracle_home.Oracle_home is the home directory for the Oracle application and it is common for all the instances.

YOu listener.ora file looks great.
If you are adding another instance then

LISTENERDSDI =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=abc.info.com)(PORT=1521))
)
)
)

SID_LIST_LISTENERDSDI =
(SID_LIST =
(SID_DESC =
(SID_NAME = ABC1)
(ORACLE_HOME = /opt/oracle_817)
)
(SID_DESC =
(SID_NAME = ABC2)
(ORACLE_HOME = /opt/oracle_817)
)
(SID_DESC =
(SID_NAME = ABC3)
(ORACLE_HOME = /opt/oracle_817)
)
(SID_DESC =
(SID_NAME = ABC4)
(ORACLE_HOME = /opt/oracle_817)
)
(SID_DESC =
(SID_NAME = xxx)
(ORACLE_HOME = /opt/oracle_817)
)

)


Revert
suki
Frequent Advisor

Re: Moving temp datafile in Oracle

Hi Mani,
I need to configure each instance as a separate package in a cluster environment.So what I want to keep different Oracle_Home directories.
Thanks,
Suki.
Christian Gebhardt
Honored Contributor

Re: Moving temp datafile in Oracle

From oracle it is not recommended to move or copy an Server-Installation to another place.

With relinking the binaries it will work but OraInstaller will not work correctly on this "new installation" because in the OraInventory the former installation path is hard coded in binary files.

The correct way to separate installations is a new install of oracle binaries.

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b13237a4bc6d611abdb0090277a778c,00.html

Chris