How to change ASM SYS Password and Creating SYSASM user 11g.

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 […]

Read the rest of this entry »

GPFS use with Oracle

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 […]

Read the rest of this entry »

RAC instance that use Veritas Clustered System

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/ 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) […]

Read the rest of this entry »