Binoy Kumar

OCR   If ocr has been deleted, then check the ocr mirror is ok and viceversa. It may be prudent to use the ocr mirror to create the ocr. If the ocr mirror and ocr have been deleted, then it may be restored from the ocr backups   Voting Disk   If there are multiple voting disk and one was accidentally deleted, then check if there are any backups of this voting disk. If there are no backups then we add one using the crsctl add votedisk command.   Socket files in /tmp/.oracle or /var/tmp/.oracle   If these files are deleted then stop the crs on that node and restart it agai. If the socket files for cssd is deleted then the crs may not come down then bounce the node.   SCLS directories   These are created by root.sh   If any of the above files cannot be restored then we will have to follow the following steps   Shutdown the crs stack on all nodes using command crsctl stop crs as root user Backup the entire crs home Execute <crs_home>/install/rootdelete.sh on all nodes Execute <c...

Use the following command to add configuration information to an existing ASM instance: srvctl add asm -n mynode_name -i myasm_instance_name -o myoracle_home If, however, you choose not to add the –I option, then the changes are propogated throughout the entire ASM instance pool. To remove an ASM instance, use the following syntax: srvctl remove asm -n mynode_name [-i myasm_instance_name] In order to enable an ASM instance, use the following syntax: srvctl enable asm -n mynode_name [-i ] myasm_instance_name In order to disable an ASM instance use the following syntax: srvctl disable asm -n mynode_name [-i myasm_instance_name] Note that you can also use the SRVCTL utility to start, stop, and get the status of an ASM instance. See the examples below. To start an ASM instance, do the following: srvctl start asm -n mynode_name [-i myasm_instance_name] [-o start_options] [-c <connect_str> | -q] To stop an ASM instance, type the following syntax: srvctl stop asm -n mynode_name [-i myas...

1. Stop Oracle 10g on one of RAC nodes. $ export ORACLE_SID=RAC1 $ srvctl stop instance -d RAC -i RAC1 $ srvctl stop asm -n orarac1 $ srvctl stop nodeapps -n orarac1   2. Start Oracle 10g on one of RAC nodes. $ export ORACLE_SID=RAC1 $ srvctl start nodeapps -n orarac1 $ srvctl start asm -n orarac1 $ srvctl start instance -d RAC -i RAC1   3. Stop/start Oracle 10g on all RAC nodes. $ srvctl stop database -d RAC $ srvctl start database -d RAC     www.pursootsinfotech.com

With most network protocols, you can issue the oradebug ipc command to see the interconnects that the database is using. For example: oradebug setmypid oradebug ipc These commands dump a trace file to the location specified by the DIAGNOSTIC_DEST initialization parameter. The output may look similar to the following: SSKGXPT 0x1a2932c flags SSKGXPT_READPENDING info for network 0 socket no 10 IP 172.16.193.1 UDP 43749 sflags SSKGXPT_WRITESSKGXPT_UP info for network 1 socket no 0 IP 0.0.0.0 UDP 0... In the example, you can see the database is using IP 172.16.193.1 with a User Datagram Protocol (UDP) protocol. Also, you can issue the oradebug tracefile_name command to print the trace location where the output is written. Additionally, you can query the V$CLUSTER_INTERCONNECTS view to see information about the private interconnect. For example: SQL> SELECT * FROM V$CLUSTER_INTERCONNECTS;NAME IP_ADDRESS IS_ SOURCE ----- ----...

System Requirements for all nodes: AIX 5L version 5.3 maintenance Level 02 or later Hardware Allocate swap space equivalent to 1.5 x physical memory 1GB of disk space in the /tmp directory 64 – bit kernel / processor is required OS filesets bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.client.rte xlC.aix50.rte 7.0.0.4 or later clC.rte 7.0.0.1 or later C/C++ Compiler IY65361 IY65362 AIX PTF for APARs IY89080 IY92037 IY68989 IY68874 IY70031 IY76140 JDK IY63533 – SDK 1.4 64-bit 1.4.2.1 IY65305 – SDK 1.4 32-bit 1.4.2.2 IY58350 – SDK 1.3.1.16 32-bit Shell Limits and Network Tuning Parameters Ensure ssh2 functions on all nodes Soft File size = -1 (Unlimited) Soft CPU time = -1 (Unlimited) Soft Data segment = -1 (Unlimited) Soft Stack size = -1 (Unlimited) maxuproc = 65536 ipqmaxlen = 512 rfc1323 = 1 sb_max = 2*655360 Set u-limit for Oracle account as follows: sudo -u root ulimit -a time(seconds) unlimited file(block...

OS : AIX 5L Oracle 10g RAC Error message on one of the nodes PRKH - 1010 : Unable to communicate with CRS services I faced a typical issue.     The localconfig command has been used for a single instance RDBMS. There is absolutely no requirement to run localconfig on RAC system and it should never be used on RAC system as it will destroy the CRS configuration When the localconfig reset was run on only one system the following things happened. Ocr.loc was created at /etc/oracle/ora.loc. Cat /etc/oracle/ocr.loc is like : Ocrconfig_loc=<$ORACLE_HOME>/cdata/localhost/local.ocr Local_only=true   Cat /etc/inittab is like H1:35:respaw:/etc/init.d/init.evmd run >/dev/null 2>&1</dev/null H3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&2 </dev/null H1:35:respawn:/etcc/init.d/init.dcssd run >/dev/null 2>&1 </dev/null<<< this one   As root Run the following scripts $ORA_CRS_HOME/install/rootdelete.sh $ORA_CRS_HOME/install/rootdeinstall...

cd /tmp touch ora.nemo.LISTENER_NEMO.lsnr.cap vi ora.nemo.LISTENER_NEMO.lsnr.cap and paste the following in the file NAME=ora.nemo.LISTENER_NEMO.lsnr TYPE=application ACTION_SCRIPT=<FULL PATH TO ORACLE_HOME>/bin/racgwrap ACTIVE_PLACEMENT=0 AUTO_START=1 CHECK_INTERVAL=600 DESCRIPTION=CRS application for Listener on node FAILOVER_DELAY=0 FAILURE_INTERVAL=0 FAILURE_THRESHOLD=0 HOSTING_MEMBERS=cea1 OPTIONAL_RESOURCES= PLACEMENT=restricted REQUIRED_RESOURCES= RESTART_ATTEMPTS=5 SCRIPT_TIMEOUT=600 USR_ORA_ALERT_NAME= USR_ORA_CHECK_TIMEOUT=0 USR_ORA_CONNECT_STR=/ as sysdba USR_ORA_DEBUG=0 USR_ORA_DISCONNECT=false USR_ORA_FLAGS= USR_ORA_IF= USR_ORA_INST_NOT_SHUTDOWN= USR_ORA_LANG= USR_ORA_NETMASK= USR_ORA_OPEN_MODE= USR_ORA_OPI=false USR_ORA_PFILE= USR_ORA_PRECONNECT=none USR_ORA_SRV= USR_ORA_START_TIMEOUT=0 USR_ORA_STOP_MODE=immediate USR_ORA_STOP_TIMEOUT=0 USR_ORA_VIP=   (All the parameters used above are documented in 10g R2 Docs) then run crs_register ora.nemo.LISTENER_NEMO.lsnr...