How to run ora_setup once the shareplex installation or upgrade is completed.
The ora_setup program establishes SharePlex as an Oracle user. You cannot commence replication until ora_setup has been run for the source and target instances to establish SharePlex as an Oracle user.
The ora_setup program (Oracle Setup) establishes a master Oracle account with full DBA privileges and creates SharePlex internal tables and indices in the SharePlex schema. The SharePlex account will be used by all of the SharePlex for Oracle processes when replication is active.
NON RAC INSTALL:
To run ora_setup:
1. Log onto UNIX as a non-root user with DBA privileges.
2. Make Sure that the values for ORACLE_SID and ORACLE_HOME directory paths are valid.
3. Make sure that the SP_SYS_VARDIR environment variable points to the variable-data directory for the SharePlex instance for which you are running ora_setup. If not set it: export SP_SYS_VARDIR=/full pathname of variable-data directory
4. Change directories to the bin sub-directory of the SharePlex product directory:
$ cd /product_dir/bin
5. If sp_cop is running, run sp_ctrl and shut down sp_cop with the following
command - SharePlex cannot be running when you run ora_setup:
$ ./sp_ctrl
sp_ctrl> shutdown
6. From the bin sub-directory of the SharePlex product directory, run the ora_setup program.
$ ./ora_setup
Follow the prompts and enter the required information as needed. The ora_setup program creates or updates the existing shareplex user and executes your tablespace selection and completes the Oracle setup process.
RAC INSTALL:
To run ora_setup:
1. Log onto UNIX as a non-root user with DBA privileges.
2. Make Sure that the values for ORACLE_SID and ORACLE_HOME directory paths are valid.
3. Make sure that the SP_SYS_VARDIR environment variable points to the variable-data directory for the SharePlex instance for which you are running ora_setup. If not set it: export SP_SYS_VARDIR=/full pathname of variable-data directory
4. Change directories to the bin sub-directory of the SharePlex product directory:
$ cd /product_dir/bin
5. If sp_cop is running, run sp_ctrl and shut down sp_cop with the following command - SharePlex cannot be running when you run ora_setup:
$ ./sp_ctrl
sp_ctrl> shutdown
6. From the bin sub-directory of the SharePlex product directory, run the ora_setup program:
$ ./ora_setup
For a clustered instance enter the SYSTEM account password appended with @alias_name, where alias_name is the TNS alias, for example manager@ora.
For a clustered instance, append the password with @alias_name, where alias_name is the TNS alias, for example splex@ora. This puts the correct login information into the SharePlex for RAC paramdb file.
Follow the prompts and enter the required information as needed. The ora_setup program creates or updates the existing shareplex user and executes your tablespace selection and completes the Oracle setup process.
For more details about this please refer to SHAREPLEX INSTALL GUIDE OR SHAREPLEX RAC INSTALL GUIDE .
