Oracle

Password management

By default, CC-IN2P3 interactive servers have one client for each DBMS. For Oracle, the sqlplus client is available and can be used by loading the oracle environment.

The Oracle environment is not loaded in your session by default. To load the sqlplus client, run the following command:

% ccenv oracle

replace <login> and <service_name.in2p3.fr> variables with your correspondent values

% sqlplus <login>@<service_name.in2p3.fr>

Once the Oracle environment loaded, you can change your password. Take cate not to put the password between quotes or double quotes.

# replace <login> and <newpassword> variables with your correspondent values
SQL> ALTER USER <login> IDENTIFIED BY <newpassword>;
User altered.