Create an Alias with an Encrypted Connection
The following example shows how to create an alias called 'oracledb' for a gateway user called 'fred', which looks up encrypted user connection information when connecting to the local oracle database 'localora' as the DBMS user 'fred' with the password 'secret'.
To create an alias that uses an encrypted connection
1. Create an alias that references an encrypted username/password (that is, username and password are an asterisk ("*")):
Windows:
gwalias oracle oracledb localora * *
UNIX:
In UNIX, "*" is a special character and needs to be escaped.
gwalias oracle oracledb localora \* \*
2. Create an encrypted username/password for the new alias:
gwsetlogin oracle oracledb fred fred secret