Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 17 Apr 2012 Add SCAN LISTENER in 11g Release 2 IÂ have built database server with single SCAN LISTENER for some testing purpose. Now I need to add other 2 SCAN LISTENER so was trying to do it with the SRVCTL… Ingress Team No Comments
Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 03 Apr 2012 Oracle 11g Release 2: SRVCTL commands PART 7 [SCAN_LISTENER] SRVCTL command for SCAN Listner:To add SCAN Listenersrvctl add scan_listener [-l lsnr_name_prefix] [-s] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"]srvctl add scan_listener -l scanlistener01To Remove Scan Listenersrvctl remove scan_listener [-f] srvctl remove scan_listener -fNote:… Ingress Team No Comments
Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 03 Apr 2012 Oracle 11g Release 2: SRVCTL commands PART 6 [SCAN] SRVCTL command for SCAN(Single Client Access Name): To Add a SCANsrvctl add scan -n nodenamesrvctl add scan -n linuxrac01To Remove a SCANsrvctl remove scan [-f]Note: Below command is using ordinal_number… Ingress Team No Comments
Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 01 Aug 2011 Oracle 11g Release 2: Viewing Logical Content of OCR (OCRDUMP Utility) The ocrdump utility is used to view the logical conent of the OCR. This is used mostly for troubleshooting. The ocrdump utility enables to view the logical information by writing… Ingress Team 1 Comment
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 20 Jul 2011 Oracle 11g Release 2: SRVCTL commands PART 5 [DISKGROUP] SRVCTL command for Diskgroup: To add the diskgroupThere is no command like srvctl add for Oracle ASM disk groups. Disk groups are automatically added to the Oracle Restart configuration when they… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - 11g - RAC - Administration 19 Jul 2011 Oracle 11g Release 2: Add a Node in the Cluster with addNode.sh Currently we have 2 node cluster in the below example and we will be adding 3rd node to it.There are various methods to add a node to the cluster but here… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - Administration 18 Jul 2011 Oracle 11g Release 2: SRVCTL commands PART 4 [LISTENER] SRVCTL command for Listener:To add/remove listenersrvctl add listener -n node_name -o ORACLE_HOME [-l listener_name]srvctl add listener ân linuxrac01 âo $ORACLE_HOME âl listenerbhavik_test01srvctl remove listener -n node_name [-l listener_name]srvctl remove listener… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command 17 Jul 2011 Oracle 11g Release 2: SRVCTL commands PART 3 [ASM] SRVCTL command for ASMÂ To add/remove the ASMsrvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]srvctl remove asm -l [-f]srvctl add asm -l LISTENERASM01 -p +diskg_data/spfile.orasrvctl remove asm -l LISTENERASM01 -fTo… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command, Database - Oracle - DBA - Administration 17 Jul 2011 Oracle 11g Release 2: SRVCTL commands PART 2 [Instance] SRVCTL command for Instances To add the instancesrvctl add instance âd db_name âi inst_name -n node_namesrvctl add instance -d bhavik_test -i bhavik_test01 -n linuxrac01To Remove the instancesrvctl remove instance âd db_name… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command 17 Jul 2011 Oracle 11g Release 2: SRVCTL commands PART 1 [Database] SRVCTL commandsCheck the Current Version of SRVCTL utilitysrvctl -VÂ For Database:To Add Databasesrvctl add database -d bhavik_test -o /db/oracle/app/oracle/product/11.2/To Remove Databasesrvctl remove database -d bhavik_testTo Start Database with different optionsrvctl start… Ingress Team No Comments