OraChat – Oracle DBAs

Things tried: SQL> select INSTANCE_NAME from v$instance; INSTANCE_NAME —————- +ASM SQL> ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password>; ALTER USER sys IDENTIFIED BY <new_password> REPLACE <old_password> * ERROR at line 1: ORA-01109: database not open We can not change the password for ASM databases via alter user command.Because passwords are managed through password file [...]

When utilizing GPFS with Oracle, configuration and tuning considerations include: When setting up your LUNS it is important to: Create the logical volumes such that they map one to one with a volume group and a volume group be one to one with a LUN which is a single RAID device. Not stripe logical volumes [...]

1) RAC RDBMS and infrastructure directories to be copied from the primary node 2) Setup SSH trusts between the nodes. 3) Export oracle home $ export ORACLE_HOME=/u01/app/oracle/product/9.2.0.4.rac 4) Relink the oracle binaries. $ relink all Check for errors if any. 5) Bring over following files/directories from primary node $ ORACLE_BASE/admin/<sid> $ ORACLE_HOME/network/admin/listener.ora $ ORACLE_HOME/network/admin/tnsnames.ora 6) [...]