When running ora_setup in Shareplex 8.6.2 or up, what do the message “NOTE: Appending the tns alias to the password via @ sign is not needed.”imply?
The message may appear to be confusing. Here is the background info and clarification. In Shareplex versions prior to 8.6.2, there used to be the requirement of appending the tnsalias to the passwords when running ora_setup in a sql*net environment.
It is no longer required to append the password with the tnsalias (or connect string) when running ora_setup with sql*net. This applies to Shareplex 8.6.2 and up. It should be noted that this does not do away with specifying tnsalias at all. It needs to be specified when running ora_setup but it does not need to be appended to passwords when entering them for DBA or Shareplex user. The following screen shot will clarify this:
Welcome to the Oracle SharePlex setup process for port nnnn.
This process creates tables and user accounts needed to run Oracle SharePlex replication.
Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQL*net connection) [y] : n 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 TNS alias for which SharePlex should be installed [name] : tns_alias_name
Verifying TNS supplied ... done.
In order to create the SharePlex tables and user account, we must connect to the database as a DBA user
Enter a DBA user for tns_alias_name: system
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter password for the DBA account, which will not echo :
connecting--This may take a few seconds.
validating user name and password. . . This may take a few seconds.
SharePlex objects will need to be created under a special account. You can pick an existing user or create a new one.