Working with the Rosetta Database
- For detailed information on the Oracle EM, refer to the following Oracle documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/em_manage003.htm
- For detailed information on Oracle Administration, refer to the following Oracle documentation: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm
Connecting to the Database from UNIX
Administrators can connect to the Rosetta database installed on a UNIX machine.
To connect to the database:
- Log on to the UNIX machine on which the Rosetta database is installed.
- In the command line, type s+ followed by the name of the schema. For example: s+ shr00
s+ is an alias for sqlplus ${ORA_USER_PREFIX}!:1/`get_ora_passwd ${ORA_USER_PREFIX}!:1`). For more information on aliases, see Description of Aliases.
Changing the Database Schema’s Password
To change an existing schema’s password:
- Change the database schema’s password on the Oracle side by logging in to Oracle with the user exl_dba.
- For all application servers, perform the following:
- Stop the server using the dps_stop command.
- Run $dps_dev/system.dir/bin /rosettings.csh
- Select [4] Update database passwords.
- Enter new passwords when prompted.
- Run $dps_dev/system.dir/bin/set_globals.sh
- Restart the server using the dps_start command.