ORACLE: ====================== /u01/app/oracle/product/10.2.0/asm/network/admin TNS Listener set shmsys:shminfo_shmmax=4294967295 TNS listener CSN_TNS = (DESCRIPTION = (LOAD_BALANCE = off) (FAILOVER = on) (ADDRESS_LIST = (ADDRESS = ( PROTOCOL = tcp)(HOST = 172.16.0.11)(PORT = 1521)) (ADDRESS = ( PROTOCOL = tcp)(HOST = 172.16.200.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = csn.newstep.com) (FAILOVER_MODE = (TYPE = session)(METHOD = basic)) ) ) #The following is used by all cdr process CDR_TNS_1 = (DESCRIPTION = (LOAD_BALANCE = off) (FAILOVER = on) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(HOST = 172.16.0.11)(PORT = 1521)) (ADDRESS = (PROTOCOL = tcp)(HOST = 172.16.200.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = cdr.newstep.com) (FAILOVER_MODE = (TYPE = session)(METHOD = basic)) ) ) CSN31_CSN03 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = csn03)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = csn31.newstep.com) ) ) /u01/app/oracle/product/10.2.0/network/admin/tnsnames.ora /u01/app/oracle/product/10.2.0/asm/network/admin/tnsnames.ora CSN_CSN09 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.10.53)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = csn.newstep.com) ) ) CSN_BACKUP_TNS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ( PROTOCOL = tcp)(HOST = 172.24.30.10)(PORT = 1521)) (ADDRESS = ( PROTOCOL = tcp)(HOST = 172.24.40.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = csn.newstep.com) ) ) instances to start: /var/opt/oracle/oratab [what DB instances to start] RESTART DB: [when DB is not mounted] clean-up backup cd $ORACLE_HOME cd bin hdbshut hdbstart