I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
I am preparing to install grid infrastructure 11.2.0.3 on AIX 6.2 USING AIX LPARS. I am getting the following errors in the output when runningn the following command...
when i install grid,the program stop at "loading setup dirver",this 's the log file.
Using paramFile: /u02/grid/install/oraparam.ini
Checking Temp space: must be greater than 120 MB. Actual 3431 MB Passed Checking swap space: must be greater than 150 MB. Actual 20479 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
The commandline for unzip: /u02/grid/install/unzip -qqqo ../stage/Components/oracle.jdk/1.5.0.30.03/1/DataFiles/*.jar -d /tmp/OraInstall2013-05-30_07-35-51PM Using the umask value '022' available from oraparam.ini
Execvp of the child jre : the cmdline is /tmp/OraInstall2013-05-30_07-35-51PM/jdk/jre/bin/java, and the argv is /tmp/OraInstall2013-05-30_07-35-51PM/jdk/jre/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2013-05-30_07-35-51PM/oui/lib/linux64 -Doracle.installer.oui_loc=/tmp/OraInstall2013-05-30_07-35-51PM/oui
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node. Expected Value : n/a Actual Value : n/a List of errors: - Permissons of file "/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"] - Cause: Cause of Problem Not Available - Action: User Action Not Available.
Oracle VM 2 Node RAC cluster Oracle 11G 11.2.0.3.0 Oracle 11g rel 2 GI
on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2
we shutdown vmorarac1 to clone it to vmorarac5
on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211
mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5
I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below
I am trying for 11gR2 3 node RAC ASM on windows 2003-64-bit. I am using one SCAN ip ,placed in /etc/hosts file.I am not using DNS/GNS. Same thing done(/etc/hosts) on other nodes also.
I have run the cluvfy.bat prior to grid software install and passed very well. When i tried to install Grid Software,at prerequisites i got error as "node connectivity".
Even i ignored this error and run the finish.After moving grid software to remote nodes ,it throws error as " [INS-20802] Grid Infrastructure Configuration failed ".
It specified one log,which i am attaching here. In network side ,the ping is ok to all the nodes.
Here i am attaching the error screen shots and error log file.
I have raised SR with Oracle ,but not able to identify the root cause of this problem.I will post the solution once i got from oracle.
I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
I am trying to install ORACLE 11gR2 RAC on CentOS 5.5 .
when run root.sh on first node. I am gettign 2/3 failed command lines but the end went successful
======================================================================= ohasd is starting ADVM/ACFS is not supported on centos-release-5-5.el5.centos ... add nodeapps -n perflabhp03 -A perflabhp03-vip/255.255.254.0/eth0 on node=perflabhp03 ... failed ... PRCR-1001 : Resource ora.net1.network does not exist add scan=perflab-cluster-scan ... failed, Configure Oracle Grid Infrastructure for a Cluster ... failed ... 'UpdateNodeList' was successful. =========================================================================
Because of this output, when see the ./crsctl stat res -t , it showing LISTENER offline for perflahp03, and I can not see any status line for "perflabhp03-vip " and "Scan-listener".
Do I need to reinstall the entire cluster setup because of VIP issue?
We are using Oracle 11g R2 on Windows 2008 R2 Server. I have noticed that there is no Enterprise Manager Installed on test environment ( I haven't did this installation). However I tried to configure the EM by using the following command
emca -config dbcontrol db -repos recreate
but got message that "Database Instance is Unavailable" (while instance is up and running with all listeners)
I checked the sysman directory under "$ORACLE_HOME/hostname_sid/sysman".
how can I configure Enterprise Manager (DB Console) in this scenario ?
I have been reading a lot of documentation regarding oracle services and I have an ok understanding of how they work. However, I have a general question regarding configuring services using Oracle RAC. For instance, if I have a 2 node oracle 11GR2 RAC on a Linux Redhat server. I have an application that connects to a service I have created. I create the service as follows.
srvctl add service -d ORCL_RAC -s APP_SERVICE -r ORCL_RAC1,ORCL_RAC2
1) When I do a 'srvctl status service -d ORCL_RAC', should I see the service running on both nodes of the RAC? Or does it run only one node, then it will fail over to the other when needed? 2) If I have a RAC environment where I see two services created (RAC_SRV1 and RAC_SRV2). I see that RAC_SRV1 is only running on node1 and RAC_SRV2 is only running on node2. There are two applications sharing the same database, one application is using RAC_SRV1 and the other application is using RAC_SRV2. Am I correct in thinking that there is no failover available here? If node1 goes down, the application connecting to RAC_SRV1 will not be able to connect to node2 right? 3) In the case of the scenario in question 2 above, would it be best practise to simply create one service and have both applications connecting to the one service? Could I configure the one service to point connections from one application to node1 and connections from the other application to node2?
I'm installing Oracle Grid 11gr2 on windows 2003 server. I installed successfully without domain controller. But when i try to install with Active Domain controller i faced following error
i have installed grid(crs+asm) on my two linux node(Enterprise linux 5) setup, using openfiler(SAN) , i have configure grid Home like ORACLE_ HOME=/ u01/ home/app/11.2.0/grid.
1) i don't get any instance specific asm parameter file like init+ASM1.ora instead of that i got ab_+ASM1.dat, hc_+ASM1.dat, init.ora, orapw+ASM four files, do i need to create ASM instance specific parameter manually to create diskgroup in the same location,
2) +DATA diskgroup has been created while grid installation, but when i try to create database, its giving me error diskgroup +DATA doesn't exit or not mount, but when i check it shows me mount like below $cd $ORACLE_HOME/dbs (here oracle home is grid home)$export ORACLE_SID=+ASM1$sqlplus / as sysdba>select name,state from v$asm_diskgroup; name state DATA Mounted even i cant able to dismount diskgroup DATA, it throws an error insufficient privilege.
3) After grid installation how can one create diskgroup i mean what needs to exported as ORACLE_SID like in 10g we have $export ORACLE_SID=+ASM1 then creat diskgroup.
Enter the full pathname of the local bin directory: [usr/local/bin]: /usr/local/bin The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed.
2012-12-11 17:31:03: Parsing the host name 2012-12-11 17:31:03: Checking for super user privileges 2012-12-11 17:31:03: User has super user privileges Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Improper Oracle Clusterware configuration found on this host Deconfigure the existing cluster configuration before starting [code]....
CRS-4000: Command Start failed, or completed with errors.
I am trying to setup my environment to prepare for hands on DBA exercises from an OCM handbook for 10g -OCM:Oracle Database 10g Administrator Certified Master Exam Guide
I need access to the following files gc_10205_part1of2.zip, gc_10205_part2of2.zip for 32 bit linux
Apparently the above along with other Grid software was once attainable from the link below but sometime between this year and the last Oracle decided to remove this and other software from public access. URL.....
I doubt Oracle will hear my plea - educational purposes only - so given I want access to the software only.
I am running oracle linux 5.7 on VMware Workstation 9 and trying to install Grid 11gr2, during installation my system freezes and I see out of memory errors. Actually Java installer is eating up too much memory over 1gb. Is there a way ? I can limit memory usage by Java process to a certain extent ?
Tried to use the yum command "yum install gcc" but get the following error. Error: cannot find a valid baseurl for repo:update
I think this is due to the "CentOS-Base.repo" file, which I've tried to update by changing the mirror URL's but no success.Then tried to find the rpms online ([URL]...
I have a single node Oracle E-Biz 12.1.3 Installation.We plan to convert this to a dual node RAC install and I wanted to run by the steps to perform this AND clone over the current production system to the new RAC system (note this will not be using ASM - but will be based on NetApp NFS)
1. Install GRID 11.2.0.3 - installed acorss two nodes, Binaries can be shared - voting disks / cluster rigistry MUST be shared
2. Install Database Software for RAC - Binaries cannot be shared and must be installed on each node independently
3. Configure the GRID for database (database / listeners)
4. Clone over the stand alone system (clone database as RAC)
I will be using SCAN - and therefore would expect all the web services / concurrent manager nodes to point to the SCAN hostname as opposed to individual host names.
I successfully installed clusterwares in 2 nodes but when i installled Oracle 11g Rel 2 (11.2.0.1) RAC database in Oracle linux 5.4 64bit, all the prerequisites are failed. I dont understand why all the prerequisties are failed,
Both nodes are working fine, i used all basics command to check the clusters, but why the database installation prerequisties are failed.
We are trying to set up a RAC blade server in which they are 2nodes and runs under Linux x86-64 machine. We will be installing 11.2.0.3. The ASM disk has been created and we are in stage of installtion of GRID software. During the GUI installation we are getting below error.
INS-06003: Failed to setup passwordless SSH connectivity with the following
The SSH are working fine when we do manually. But through GUI during installtion it is not. The port which we are using here for connectivity is 2222 instead of the default ports. As per the one of thread in OTN discussion I checked port specification of /etc/ssh/ssh_config file in both the servers. It is 2222.
I am trying to apply 14275572 this patch on our local database
DB : ORC it's on 11g (11.2.0.3.0) OS : Redhat 5 (x86_64).
14275605 applied succesfully but 14275572 applying this patch getting below errors.
[Jan 5, 2013 7:37:36 PM] --------------------- Prerequisite for apply --------------------- [Jan 5, 2013 7:37:36 PM] Running prerequisite checks... [Jan 5, 2013 7:37:36 PM] Patch "14275572" is ignored as it is not a "Fusion Applications patch". [Jan 5, 2013 7:37:36 PM] Check if patch "14275572" is a no-op patch. [Jan 5, 2013 7:37:36 PM] None of the selected patches are no-op. patches.. [code]...
This patch requires some components to be installed in the home. Either the Oracle Home doesn't have the components or this patch is not suitable for this Oracle Home.OPatch failed with error code 39.
Running a Dell x86_64 machine using CentOS 6.4 Install using the command: rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpmOracle XE installs without any errors.
However: When during database configuration we get the Database Configuration failed error The logs all show similar errors, here's a snippet: Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 BEGIN dbms_backup_restore.zerodbid(0); END; *ERROR at line
1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=1q6xlf1.bcohome.bco.com)(PORT=1521))'Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter system enable restricted session*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter database "XE" open resetlogs*ERROR at line 1:ORA-01034: ORACLE not available
I try to install the Grid Control 10.2.0.5 on Solaris 10 in an existing (empty) Database Oracle 10.2.0.4. All steps work without problems except
-- OMS Configuration (in Configutaion Assistants)
emca_repos_create15_25_32.log :
Quote: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:647) [code].......
ORA_NLS10 is set to $ORACLE_HOME/nls/data of DB
Also tried to set to $ORACLE_HOME/nls/data of oms10g but get Problems to start opmn and later on it report also ORACLE_HOME and NLS Parameter set incorrectly. I checked MetaLink / Internet without success.
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.