I have installed OEM grid standalone and have it working fine. However I would like to install GRID without having to create the DATA group first. In other words install ASM software using a local spfile and password file and then using sqlplus as sysasm create the first disk group and others I tried a software install of grid, but it would not let me start asm because there was no ohasd or css(something).

I have an Oracle database 11gr2 and I want to install Oracle Grid on Oracle Linux 6.4. At first, I have installed Oracle Grid with the tutorial on this website: https://eudba.wordpress.com/2012/08/10/installing-oracle-11g-on-oracle-linux-6-with-asm-eng/ When the grid installation is finished, I have an error that says: "the Oracle grid service can not start". When I want to install the database with oracle user and with ASM, I have an error that I attached it to this question. Can any one help me?

looks like ohasd is getting to much memory (memory leak or something) that cause heavy swapping, is it possible to restart OHAS (till patch is applied) without bouncing databases? "crsctl stop has" puts all resources down :(

I am trying to install GI 19c on Oracle Linux 7 (required for 19c), and have used AsmLib to try to achieve device persistence (owner,group) for ASM devices/disks. Prior to that I used udev rules for the same and was able to achieve the same. Both times I get the same issue while doing ASM disk discovery as explained below. Problem is when I try to invoke the gridSetup.sh from node 1, all checks pass including node readiness, ssh equivalence, scan etc, but the installer fails(not able to find the disks) at discovering ASM disks which are already marked by oracleasm(AsmLib) as asm disks and are owned by grid:oinstall. The installer logs from oui show the below. WARNING: [May 29, 2019 12:32:14 PM] SRVCTL not found as there is no Grid Infrastructure home on the box. INFO: [May 29, 2019 12:32:14 PM] Executing [/u01/app/19.0.0/grid/bin/kfod.bin, nohdr=true, verbose=true, op=dfltdstr] INFO: [May 29, 2019 12:32:14 PM] Starting Output Reader Threads for process /u01/app/19.0.0/grid/bin/kfod.bin INFO: [May 29, 2019 12:32:14 PM] The process /u01/app/19.0.0/grid/bin/kfod.bin exited with code 1 INFO: [May 29, 2019 12:32:14 PM] Waiting for output processor threads to exit. INFO: [May 29, 2019 12:32:14 PM] Parsing Error 49802 initializing ADR INFO: [May 29, 2019 12:32:14 PM] Parsing ERROR!!! could not initialize the diag context Already tried setting ORACLE_BASE env variable and added to path, so adrci is executable. Also verified owner and permissions, (oracle:oinstall) Also checked on permissions for /u01/app/19.0.0/grid/bin/kfod.bin and they are executable by grid user.(grid:oinstall) Also tried various different asm diskstrings like ORCL:VOL*, ORCL*, VOL*, /dev/oracleasm/disks/* etc, but none of them worked. FYI: This is a fresh install of 19c GI onto a 2 node RAC cluster, (2 freshly created virtualbox machines with shared disks) with no prior GI or RDBMS installations on. Any help/assistance is greatly appreciated. Thanks

I have installed OEM 12c and after restarting my oms the agents got the following error:
Heartbeat Status : Agent is blocked Blocked Reason : Plugin mismatch found between agent and repository. I have restarted the agent but sill no success.
Any ideas there ?

I'm trying to use ASMCMD but it doesn't return any result in the command line ASMCMD> ls ASMCMD> ASMCMD> ASMCMD> ASMCMD> lsdg ASMCMD> ASMCMD> pwd ASMCMD> The version of database is 19c, the only environment about oracle grid is the GRID_HOME, but I also have the ORACLE_HOME and ORACLE_BASE, currently my $ORACLE_SID is orcl and my $ORACLE_HOME is /u01/app/oracle/product/19.3.0/dbhome_1. My output about srvctl config asm is:

ASM home: 
Password file: +DATA/orapwasm
Backup of Password file:
ASM listener: LISTENER,LISTENER2
Spfile: +DATA/ASM/ASMPARAMETERFILE/registry.253.1011650339
ASM diskgroup discovery string: /dev/oracleasm/disks/*

First of all, thanks for your time and effort on this, I've been looking into this problem for about two weeks but still haven't figured it out yet. I know it might be due to different root causes, but I would appreciate any tips and hints as well: I am facing more than one problem, but I suspect all of them have the same root cause. Something like a permission problem : I am trying a demo installation in VirtualBox with Grid Infrastructure 11.2.0.1 and Oracle database 11.2.0.1.. The OS is OEL 5.11 and I have used ASM for Storage management. The directory structure is as follows (Sorry I put all of the output completely because there might be something missing and I might have overlooked it) : Under user "grid" which is the Grid Infrastructure owner: [grid@orcl-demo ~]$ ls -l /u01 total 24 drwxrwxr-x 6 grid oinstall 4096 Jul 31 17:49 app drwxr-xr-x 4 oracle oinstall 4096 Aug 2 13:07 installation_source drwxrwxr-x 2 grid oinstall 16384 Jul 30 18:33 lost+found [grid@orcl-demo ~]$ ls -l /u01/app total 16 drwxrwxr-x 3 grid oinstall 4096 Jul 30 21:07 11.2.0 drwxrwxr-x 6 grid oinstall 4096 Aug 2 13:19 grid drwxrwxr-x 8 oracle oinstall 4096 Aug 2 13:31 oracle drwxrwx--- 6 grid oinstall 4096 Aug 2 13:27 oraInventory [grid@orcl-demo ~]$ echo $ORACLE_BASE /u01/app/grid [grid@orcl-demo ~]$ echo $ORACLE_HOME /u01/app/11.2.0/grid Under user "oracle" which is the Database owner : [oracle@orcl-demo ~]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1 [oracle@orcl-demo ~]$ echo $ORACLE_BASE /u01/app/oracle I have used official documentation and some oracle workshop guides to do the installation. Now everything works fine, except for the following things : srvctl start database throws the following : [oracle@orcl-demo ~]$ srvctl start database -d oradb PRCR-1079 : Failed to start resource ora.oradb.db CRS-5011: Check of resource "oradb" failed: details at "(:CLSN00007:)" in "/u01/app/11.2.0/grid/log/orcl-demo/agent/ohasd/oraagent_grid/oraagent_grid.log" CRS-2674: Start of 'ora.oradb.db' on 'orcl-demo' failed ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Process ID: 0 Session ID: 0 Serial number: 0 But I can start the database pretty smoothly using sqlplus : [oracle@orcl-demo ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 6 16:26:50 2019 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 2087780352 bytes Fixed Size 2214936 bytes Variable Size 1258292200 bytes Database Buffers 822083584 bytes Redo Buffers 5189632 bytes Database mounted. Database opened. SQL> From Enterprise manager, I cannot start or stop the database smoothly, though it stops the database, it throws an error like below in the emoms.log file and in the web, it throws an "internal error" : 2019-08-06 16:31:22,297 [EMUI_16_31_19_/console/database/instance/sitemap] WARN jdbc.ConnectionCache _getConnection.353 - Got a fatal exeption when getting a connection; Error code = 1034; Cleaning up cache and retrying 2019-08-06 16:31:22,707 [MetadataLoad https://orcl-demo.training.com:3938/emd/main:A0000000004.xml] ERROR eml.XMLLoader markFileAsError.858 - Error repeated 1 times: ERROR-400|ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory 2019-08-06 16:31:23,013 [EMUI_16_31_19_/console/database/instance/sitemap] ERROR perf.sitemap getBean.3488 - java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:77) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:111) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:472) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:414) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:309) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:405) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:621) So I have to start database manually. But EM still shows the database is down, and I get the following error in the logs : 2019-08-06 16:35:25,948 [XMLLoader0 00000000022.xml] ERROR eml.XMLLoader LoadFiles.696 - Error while processing 00000000022.xml: java.sql.SQLException: ORA-20101: Metric PhysAddress for target type netapp_filer not configured ORA-06512: at "SYSMAN.ECM_CT", line 718 ORA-06512: at line 1 ORA-06512: at "SYSMAN.EMD_LOADER", line 4931 ORA-06512: at line 1 and I have to restart em to make things work. I have tried many, many different solutions, my biggest suspicion was listener, the listener has been configured automatically during Grid installation, and I just added a static listener.ora file (not sure about the contents, though): [grid@orcl-demo ~]$ cat /u01/app/11.2.0/grid/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-demo.training.com)(PORT = 1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = oradb.training.com) (SID_NAME = oradb) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1))) ADR_BASE_LISTENER = /u01/app/grid ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON And the status of listener service is as follows, the UNKNOWN state has happened since adding the static file. If I remove that, all of the statuses will be READY, but I won't be able to browse listener in Enterprise Manager: [grid@orcl-demo ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2019 16:39:23 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl-demo.training.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 06-AUG-2019 15:33:27 Uptime 0 days 1 hr. 5 min. 56 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/orcl-demo/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl-demo.training.com)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM", status READY, has 1 handler(s) for this service... Service "oradb.training.com" has 2 instance(s). Instance "oradb", status UNKNOWN, has 1 handler(s) for this service... Instance "oradb", status READY, has 1 handler(s) for this service... Service "oradbXDB.training.com" has 1 instance(s). Instance "oradb", status READY, has 1 handler(s) for this service... The command completed successfully I tried the installation of both applications using the same user (oracle) but then there will be a lot of issues regarding which home (ORACLE or GRID) should be called. I used the permissions in this document (though for 12c, but it works like a charm). I am stuck! Any Help?

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough? Thank you in advance

Primary database is installed on RHEL 6.1. Standby database software is installed on RHEL 7.0. I am trying to add new standby database by using Grid Control. Database versions are same 11.0.2.0.3. I was able to add standby database on RHEL 6.1 using same method. I used the following link to install ORACLE on RHEL 7.0. Does it have anything to do with oracle group gid is different than RHEL 6.1? On RHEL 7.0, I used oinstall(54321) dba(54322) oper(54323) for gids. On RHEL 6.1, I used oinstall(501) dba(502) oper(503). If it doesnt matter, what should i do?

My database using RAC 11gr2 with two node on Redhat 6. My system running fine, but after some time about 3-4 days. Process "ora.LISTENER.lsnr" change status Online to INTERMEDIATE and then pedding, can not connect any session. I reboot server it fine :) (restart instance or listener is not working) This error exists only node2. This is log of error in */u01/11.2.0/grid/log/node2/agent/crsd/oraagent_grid/oraagent_grid.log* file: [ora.LISTENER.lsnr]{1:32952:11577} [check] Agent::abort last call info: "Agent::Agent refreshAttr" [ora.LISTENER.lsnr]{1:32952:11577} [check] abort command: check [ora.LISTENER.lsnr]{1:32952:11577} [check] tryActionLock { [ora.LISTENER.lsnr]{1:32952:11577} [check] (:CLSN00009:)Utils:execCmd abort request: killing /u01/11.2.0/grid/bin/lsnrctl [ora.LISTENER.lsnr]{1:32952:11577} [check] clsnUtils::error Exception type=2 string= CRS-5014: Agent "/u01/11.2.0/grid/bin/oraagent.bin" timed out starting process "/u01/11.2.0/grid/bin/lsnrctl" for action "check": details at "(:CLSN00009:)" in "/u01/11.2.0/grid/log/node2/agent/crsd/oraagent_grid/oraagent_grid.log" 2017-06-17 09:23:28.859: [ora.LISTENER.lsnr]{1:32952:11577} [check] clsnUtils::error Exception type=2 string= CRS-5017: The resource action "ora.LISTENER.lsnr check" encountered the following error: (:CLSN00009:)Utils:execCmd aborted. For details refer to "(:CLSN00109:)" in "/u01/11.2.0/grid/log/node2/agent/crsd/oraagent_grid/oraagent_grid.log". [ora.LISTENER.lsnr]{1:32952:11577} [check] got lock [ora.LISTENER.lsnr]{1:32952:11577} [check] tryActionLock } [ora.LISTENER.lsnr]{1:32952:11577} [check] abort } [ora.LISTENER.lsnr]{1:32952:11577} [check] (:CLSN00110:) clsn_agent::abort } [ AGFW]{1:32952:11577} Command: check for resource: ora.LISTENER.lsnr node2 1 completed with status: TIMEDOUT [ AGFW]{1:32952:11577} ora.LISTENER.lsnr node2 1 state changed from: ONLINE to: UNKNOWN [ AGFW]{1:32952:11577} ora.LISTENER.lsnr node2 1 would be continued to monitored! [ AGFW]{1:32952:11577} ora.LISTENER.lsnr node2 1 state details has changed from: to: CHECK TIMED OUT [ AGFW]{0:1:4} Generating new Tint for unplanned state change. Original Tint: {1:32952:11577} [ AGFW]{0:1:4} Agent sending message to PE: RESOURCE_STATUS[Proxy] ID 20481:134789 [ora.asm]{2:50449:2} [check] CrsCmd::ClscrsCmdData::stat entity 1 statflag 33 useFilter 0 How to fix this error. Thanks.

I'm studying for the 1Z0-062 exam with John Watson's exam guide and I'm trying to install Grid Infrastructure alongside my Dbhome. The book seems to run an installer that displays a configuration command to run at the end of the grid installation, but I haven't been able to find one. On the Oracle site, whenever I try to find a Windows download for the Grid Infrastructure, I'm simply redirected to the OUI for the 12c Database. Problem is, the OUI won't prompt for any command to run after the installation, and when I try to run it myself it gives out this error: This is the command in question: Grid_home/perl/bin/perl -I Grid_home/perl/lib -I Grid_home/crs/install Grid_home/crs/install/roothas.pl What am I doing wrong?

I am installing 12c Grid Control agent on my server via Enterprise manager. The targer server is a UNIX server with AIX OS on it. I add target host manually, enter authentication information, host name, installation directory, etc. and all goes well untill I click "Deploy Agent" button, then I get the following error: "Shell path is incorrect or not defined.:/bin/bash(SH_PATH),-c(SH_ARGS) on host MyHostName" and details are : "Check the property values in the following files in this order, ssPaths_.properties or sPaths.properties or Paths.properties, in "/u02/app/oracle/middleware/oms/oui/prov/resources" There isn't /u02/app" directory on my target server, only /u01/app/oracle" so I assume the above directory is on the same server as Enterprise manager. Although I did find a directory where I have files of the format ssPaths_.properties - /u01/app/oracle/product/11.2.0.3/oui/prov/resources Since my platform ia AIX, I used file ssPaths_aix.properties On my target server if I run which bash I get /usr/bin/bash and which ssh returns /usr/bin/ssh ahd which sh returns /usr/bin/sh So I edited the ssPaths_aix.properties file so that SH_PATH=/usr/bin/sh but still getting the same error. I have also tried setting to SH_PATH=/usr/bin/bash but nothing seems to make any difference. I am thinking one possibility would be I am editing wrong file. Can anyone help?

We upgraded rac system and I want to ask, could I delete old grid and database version? [oracle@orcl1 app]$ cd 11.2.0.3/ 12.1.0.2/ Middleware/ oraInventory/ 11.2.0.4/ grid/ oracle/ swlib/ I want to ask can I delete manually "rm command line command"11.2.0.3/ and 11.2.0.4 grid files... oracle/product/11.2.0.3 database ... That's my inventory.xml 12.1.0.2.0 2.1.0.6.0 ----------------- EDIT: I started deinstall tool in 11.2.0.3 .. I don'T want to delete grid 12.1.0.2 but I think it can delete 12.1.0.2's grid. right? ######################### CHECK OPERATION START ######################### ## [START] Install check configuration ## Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0.3/dbhome_1 Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database Oracle Base selected for deinstall is: /u01/app/oracle Checking for existence of central inventory location /u01/app/oraInventory Checking for existence of the Oracle Grid Infrastructure home /u01/app/12.1.0.2/grid The following nodes are part of this cluster: orcl1,orcl2 Checking for sufficient temp space availability on node(s) : 'orcl1,orcl2' ## [END] Install check configuration ## Network Configuration check config START Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2015-11-02_08-53-27-AM.log Network Configuration check config END Database Check Configuration START Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2015-11-02_08-53-29-AM.log Use comma as separator when specifying list of values as input Specify the list of database names that are configured in this Oracle home []:

Here is the Logic Volume for example: > lvcreate -L2G -n Lv_OraD1 vg_db > lvcreate -L180G -n Lv_OraD2 vg_db > > lvdisplay /dev/mapper/Lv_OraD* UDEV rule to raw the LV: > vi /etc/udev/rules.d/60-raw.rules > > ACTION=="add", ENV{MAJOR}=="253",ENV{MINOR}=="3", RUN+="/bin/raw /dev/raw/raw1 %N" > ACTION=="add", ENV{MAJOR}=="253",ENV{MINOR}=="4", RUN+="/bin/raw /dev/raw/raw2 %N" > ACTION=="add",KERNEL=="raw[1-9]",OWNER="grid",GROUP="dba",MODE="660" > > start_udev > raw -qa ASM Diskgroup maybe like this: > CREATE DISKGROUP DATA1 NORMAL REDUNDANCY > FAILGROUP Fg1 DISK '/dev/raw/raw1' SIZE 2048M ,'/dev/raw/raw2' SIZE 184320M; The effect: the size up 2G of DISKGROUP DATA1 cannot be used. so any tricks to achieve this result online? > lvreduce -L90G /dev/mapper/Lv_OraD2 > lvextend -L90G /dev/mapper/Lv_OraD1 Thanks.

Software environment: Oracle 12c with RAC running on RHEL The question might sound rather banal, but I wasn't able to find any word on this in the Oracle documentation I read thus far. By searching the net, I came to the conclusion that node evictions usually imply a node reboot, but that doesn't always seem to be the case, some suggest node evictions without node reboots are also possible. If that is indeed the case, when will the node be rebooted and when not? If a node cannot access the minimum required number of voting disks, then that node will be evicted. Will that node always be rebooted because of this eviction? Can one configure this behavior (i.e. change from eviction with reboot to eviction without reboot)?

Hi All, I am getting the following warning when installing RAC DB (11.2.0.4). Does any one has idea what could be the reason? I have tried to search from Metalink but no help. Can I proceed with the warning? What will be the impact if I ignore the warning and proceed? Thanks in advance...

Hi All, During the 11g installation on Win 2012, I am not able to select the available disks which are already stamped using ASM. Any idea what could be the reason? I have tried to select using keyboard space as well but doesn't work out. Appreciate your help. Thanks.

I create an monitoring template for my database on OEM GC, apply it on somes database and now i want to know what database is using this template. Can someone help me please?

I have been asked to setup workstations (VMs) for an instructor's Oracle 11g R2 Workshop. I am finding the documentation that was downloaded from the Oracle Academy site extremely underwhelming. I am supposed to be configuring the environment with a set of ASM disks as LO devices that the students will then use to create an ASM disk group when they install Oracle Grid and as disks for the Fast Recovery Area. My understanding is that the student will be installing Oracle Grid, Oracle Database, then creating a database, and that I do not need to have Oracle installed beforehand. However, the documentation makes use of the oracleasm command which comes with the Oracle installation. Is there a way to set this up without installing Oracle? Has anyone ever setup/taught these workshops? I tried downloading the Oracle ASMLib tool here but it says it needs oracleasm as a dependency.

Grid Control 10.2.0.5. Does anyone know a way to configure a Grid Control notification rule for a failure of the SQL APPLY process on a logical standby database? I'd really like an email notification that the SQL APPLY process has encountered an error and is no longer applying redo to the logical standby. I can get notifications on job failures, database down, listener stops, agent stops monitoring, but don't see how to get notified for this event.