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 environment manager Modules:

% module load DataBase/oracle/23.4

% sqlplus <username>@<service>.in2p3.fr

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

SQL> ALTER USER <username> IDENTIFIED BY <new password>;
User altered.