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
Uncategorized 09 Apr 2012 SQL Server: Linked Server using hoping and SETSPN Hello Friends,Since last few days I was working on SETSPN and creating linked server in Microsoft SQL Server. Build around 4 virtual servers using 2 Windows 2003 and 2 Windows… Ingress Team No Comments
Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Error - Solution 05 Apr 2012 Resolving Error ORA-01115, ORA-01110 and ORA-15081 connecting Database If you are getting error ORA-01115, ORA-01110 and ORA-15081 after you connected to a database or while connecting to the database accessing header of SQL as mentioned below.SQL*Plus: Release 11.2.0.2.0… Ingress Team 4 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
Uncategorized 02 Apr 2012 Oracle 11g EM DBconsole: WARNING: Database instance unavailable Hello,If you are receiving above error when accessing the DBConsole it is possible that there is some problem with EM repository.It is always better to drop the em repository and… Ingress Team 1 Comment
Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Enterprise Manager 02 Apr 2012 Oracle 11g Enterprise Manager Switching Accessibility Mode Disabled to Enabled If you receive a message accessing Oracle Enterprise Manager : 11g saying Accessibility Mode DisabledFollow the below steps1. vi $ORACLE_HOME/j2ee/OC4J_EM/applications/em/em/WEB-INF/uix-config.xml2. Change the value of the accessibility-mode property from inaccessible to accessible.4.… Ingress Team 1 Comment
Database - Oracle - DBA - 11g - ASM 17 Aug 2011 Oracle 11g Release 2: ASM Intelligent Data Placement (IDP) Intelligent Data Placement is a new concept that is introduced in Oracle 11g Release 2.As we know that the data stored in disk (HDD) is mostly in circular manner on… Ingress Team No Comments
Database - Oracle - DBA - 11g - RAC - Administration 17 Aug 2011 Oracle 11g Release 2: CTSS and NTP Service CTSS daemon service is a new service introduced in Oracle 11g Release 2 for the time synchronization between the nodes. As I have mentioned earlier few of the details about… Ingress Team No Comments
Database - Oracle - DBA - 11g - RAC - Administration 17 Aug 2011 Oracle 11g Release 2: Cluster Verify Components (CLUVFY) CVU is used for component verfication and can be used at any stage. It is used for multiple verfication like basic, free disk space, check Oracle clusterware stake. It is… Ingress Team No Comments
