What privileged account is needed to run ora_setup?
The answer depends on the Shareplex version in question as the requirement is different for Shareplex 7.6 (or higher) and Shareplex 7.5 (or lower):
A: For Shareplex version 7.5 or lower:
The ora_setup program is hardcoded in that it needs to be run by SYSTEM user to create tables and user accounts needed to run SharePlex replication.
B: For Shareplex version 7.6 or higher:
In Shareplex 7.6 or higher, this requirement has been relaxed so the program need not necessarily be run by SYSTEM user but can be run by any DBA user (which also includes SYSTEM user). The following is a sample screen shot:
alvsupu07 # ./ora_setup
Welcome to the Oracle SharePlex setup process.
This process creates tables and user accounts needed to run
Oracle SharePlex replication.
Please note the following:
** In response to prompts, a carriage return will choose the default
given in brackets. If there is no default, a reply must be entered.
** To exit the program while the program is waiting for input, use the
CTRL-C key sequence.
This sequences can be entered by holding down the CONTROL key and
pressing the C key.
Enter the Oracle SID for which SharePlex should be installed [SID_name] :
In order to create the SharePlex tables and user account, we must
connect to the database as a DBA user
Enter a DBA user name : sha75
Enter password for the DBA account, which will not echo :
connecting--This may take a few seconds.