Database - Oracle - DBA - 11g - Error - Solution, Database - Oracle - DBA - 11g - RAC - Administration 24 Apr 2012 Resolved: PRCR-1079 ORA-00119 CRS-2674 CRS-2528 Oracle 11g Release 2 Cannot Start Database Issue: Cannot start the database with SRVCTL start database -d testdbsrvctl start database -d testdbPRCR-1079 : Failed to start resource ora.testdb.dbORA-00119: invalid specification for system parameter %sCRS-2674: Start of 'ora.testdb.db'… Ingress Team No Comments
Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration 17 Apr 2012 Oracle 11g Release 2 Real Application Cluster ERROR ORA-12505 with Java JDBC Recently I was facing an issue with JAVA when trying to connect my Oracle 11g Release 2 RAC Database that was using SCAN Listener.Below is the test program that I… Ingress Team 5 Comments
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
