Sometimes you have a database installed on external storage and you need to move it to a new server. If your Oracle binaries are installed locally then you can't just install a new set of binaries, mount the volumes containing the database files and start the database. This is because Oracle creates directory structures and files under the Oracle binary directories. This article is meant to help you make these changes to your binary installation so it will recognize the new database. It is assumed that the operating systems of the source and target servers are the same and that the version of Oracle on both servers is the same also.
Create Users and Groups
Create any Oracle users and groups on the new server and make sure that the user IDs and group IDs are the same as they are on the source server. You can verify this on UNIX by checking the /etc/passwd file for user IDs and /etc/group for group IDs.
Install Oracle Binaries
The first step is to install the Oracle binaries as normal. Take note of the location of $ORACLE_BASE and $ORACLE_HOME directories and the $ORACLE_SID and substitute them where needed below.
Showing posts with label Oracle DB Installation. Show all posts
Showing posts with label Oracle DB Installation. Show all posts
Operating system configuration settings for Oracle 11g and Solaris 10
Oracle's Health Check utility recommends that you set certain parameters when installing on Solaris 10. Here is a summary of some common parameters and how to set them:
Host Name
RDA Rule A00320: /etc/hosts Format (Missing host.domain)
This rule checks that the host name is configured the way that Oracle wants to see it. To fix this, edit /etc/hosts to append the domain name to the existing host name. Also include the tab-separated bare host name or the server may not boot:
Kernel Parameters
Rule A00330: Kernel Parameters OK? (NOEXEC_USER_STACKUndef)
There is a lot of confusion about how to set kernel parameters since things have changed with Solaris 10. This particular parameter can be set in /etc/system under the "set" section:
There is an additional problem with Solaris when you are doing a preinstallation check with RDA. Some modules are only loaded into memory the first time they are accessed by an application. Therefore, when you run the RDA check before Oracle is installed they will not show correctly, even if they are set correctly. To force the modules to load at boot time you can add these lines to /etc/system under the "forceload" section:
Reboot after making these changes.
Host Name
RDA Rule A00320: /etc/hosts Format (Missing host.domain)
This rule checks that the host name is configured the way that Oracle wants to see it. To fix this, edit /etc/hosts to append the domain name to the existing host name. Also include the tab-separated bare host name or the server may not boot:
123.45.678.90 myhost.domain.local myhost
Kernel Parameters
Rule A00330: Kernel Parameters OK? (NOEXEC_USER_STACKUndef)
There is a lot of confusion about how to set kernel parameters since things have changed with Solaris 10. This particular parameter can be set in /etc/system under the "set" section:
set noexec_user_stack=1
There is an additional problem with Solaris when you are doing a preinstallation check with RDA. Some modules are only loaded into memory the first time they are accessed by an application. Therefore, when you run the RDA check before Oracle is installed they will not show correctly, even if they are set correctly. To force the modules to load at boot time you can add these lines to /etc/system under the "forceload" section:
forceload: sys/shmsys forceload: sys/semsys
Reboot after making these changes.
124861-15 patch prerequisite can be safely ignored when installing Oracle 11g on Solaris 10
When installing 11gr2 db on Solaris 10 the following error comes up:
This can be safely ignored according to MOS doc id 969497.1:
Cause
OUI should only check for this optional patch while installing the Pro*C precompiler.
If Pro*C is not being installed, OUI should not check for this patch.
Support opened Bug 9214210 for this issue
OS Patch:124861-15 - This is a prerequisite condition to test whether the patch "124861-15" is available on the system. Expected Value : Patch 124861-15 Actual Value : Patch missing List of errors: - PRVF-9809 : Proper OS Patch is not found on node "<Node Name>" [Expected = "124861-15" ; Found = "Patch missing"] - Cause: Required OS Patch is not applied. - Action: Apply the required OS Patch.
This can be safely ignored according to MOS doc id 969497.1:
Cause
OUI should only check for this optional patch while installing the Pro*C precompiler.
If Pro*C is not being installed, OUI should not check for this patch.
Support opened Bug 9214210 for this issue
Labels:
Oracle 11g,
Oracle DB Installation,
Solaris 10
Subscribe to:
Posts (Atom)