INSTALLING ORACLE ON A NEW SERVER

[Chris Chaoman]

I have built a L1000 server and installed HP-UX 11.0 (sever P1).
I have copied /oraclesys and /home/oracle/* from server D1 to P1 as requested by the DBA.

When running svrmgrl the user is getting an error "Permission denied". All the files do have rwx permissions.
Does Oracle need to be re-installed on the new server P1?
What kernel parms need to be changed to permit oracle to run on P1?

[Devender Khatana]

Hi,

You need to change kernel parameters as per system configuration. But it will not stop svrmgrl from running. This seems to be due to non existance of oracle user and dba group on the new system. Also set the directory permissions accordingly.

You do not require to install it but need to set some prelimary steps.

HTH,
Devender

[Peter Godron]

Chris,
not the standard way of installing oracle.
I would suspect user setup and group (oracle:dba). Are the directory protections ok? Just chown -R oracle:dba the whole /home/oracle and /oraclesys areas.
For the kernel chnages look at the pre-req. document from oracle. You do not specify which version of oracle, so can't give you link.

[Yogeeraj_1]

hi,

this will work if and only if both servers have been configured similarly.

That is, the same patch levels and kernel parameters.

In this case, a simple copy and startup of the database would be fine.

If this is not the case, you will have to make appropriate changes.

which version of oracle database are you running?

revert.

kind regards
yogeeraj

[Victor Fridyev]

Hi,

I also install ORACLE by copying an installation from an early installed "standard" server.
The files must be copied by user root in order to store ownership and permissions. In addition to ORACLE_HOME the files oraenv, coraenv and dbhome from /usr/local/bin (default) might be copied to the target. A good idea to copy oraInventory directory, in order to have a possibility to upgrade the installation by the standard way.
Please check ownership and permissions for the following files and change them according to ones below:
-rwsr-s--x 1 oracle dba 95966296 Mar 13 16:28 /oraclehome/bin/oracle*
-rwsr-s--x 1 oracle dba 95966344 Mar 13 16:18 /oraclehome/bin/oracleO*

HTH

[Steven E. Protter]

Shalom,

Common sysadmin error: Doing the file copy as root. chown -R oracle:dba /home/oracle/*

Adjust the command to your actual needs.

However to get oracle to run, you must do one of the following things:

1) Copy an oracle install image for the binaries onto the server.
2) Install the correct version of oracle and patches using the Oracle Universal Installer, which requires an X windows Interface.

We make and use tar install images of oracle, but for the first install on platform and OS we use the Universal Installer.

SEP

[renarios]

Hi Chris,

What you need to do is make a tarball of your Oracle home on the old server, rcp/scp it to the new server and untar it on the new server. Now all privileges are the same. Don't forget to rcp/scp the oratab, oraenv and coraenv files to the new server.
According OFA, most DBA's decide to create the Oracle software in /u01/app/oracle/, but on HP-UX /opt/oracle is also used.
The oratab is placed in /etc and the *oraenv file are put in /usr/local/bin.
You indeed do have to set the kernel parameters on your new server.

Cheers,

Renarios

[James A. Donovan]

What are the permissions on the $ORACLE_HOME/bin/oracle binary?

The should be 6751 (or, -rwsr-s--x). If they aren't then fix that.

$ chmod 6751 $ORACLE_HOME/bin/oracle