Giter VIP home page Giter VIP logo

vagrant's Introduction

Vagrant Builds

Just some Vagrant builds I use.

Feel free to copy or fork this stuff. It's unlikely I'll accept pull requests as it's just my playground.

Required Software

What is Vagrant?

If you don't know how to use Vagrant, you might want to read this introduction.

vagrant's People

Contributors

a7rmtwe57x avatar bhaumik04 avatar hakkika avatar hallty-uob avatar mark-lancaster avatar mpaouris avatar oraclebase avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

vagrant's Issues

Question - Dataguard

Thank you Tim for the excellent work put into developing the ol8-19-rac article.

I was wondering what changes I would need to make if I wanted to spin up a second RAC cluster on the same machine to configure the cluster with a physical standby database. Possibly straight forward, likely not.

Thanks in advance.

ORA-12546 TNS:permission denied

@oraclebase Thanks for your swift help with the previous issue. Facing this new issue.

PermissionDenied

It meant that there wasn't enough permission provided for oracle bin. So, I altered the permission using 'chmod' command. But even then it was not working. Upon checking it looks like, every time the content gets overwritten, since the files are newly unzipped every time.

Tomcat compression="on" needs to be added to Connector UpgradeProtocol

Hi Tim

In server.xml for your Vagrant VMs please add compression="on" to the UpgradeProtocol.
It is not inherited from the Connector attributes. Tested in Tomcat 9.0.46

    <Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
               maxThreads="250" scheme="https" secure="true"
               keystoreFile="###KEYSTORE_DIR###/keystore.jks"
               keystorePass="###KEYSTORE_PASSWORD###"
               clientAuth="false" sslProtocol="TLS" sslEnabledProtocols="TLSv1.2"
               URIEncoding="UTF-8"
               compression="on"
               noCompressionUserAgents="gozilla, traviata"
               compressableMimeType="text/html,text/xml,text/plain,text/css,text/javascript,application/javascript,application/json"
               >
      <UpgradeProtocol className="org.apache.coyote.http2.Http2Protocol" compression="on"/>
    </Connector>

Licensing

Hello Tim,
Is it possible for You to state somewhere in the repo the licensing for all the awesome scripts You created.
I would love to use them for few internal things , but I'm not sure if i can / should.
Unless everything is as it should be :)

19c rac installation node1 fails

Hi Tim,

While doing rac 19c installation , dns and node2 are up and no error ,but node1 fails :------
Please find the output , I got while node1 during installation .

Do grid configuration. Sat Dec 26 10:42:27 UTC 2020
default: ******************************************************************************
default: Launching Oracle Grid Infrastructure Setup Wizard...
default: You can find the logs of this session at:
default: /u01/app/oraInventory/logs/GridSetupActions2020-12-26_10-42-27AM
default: You can find the log of this install session at:
default: /u01/app/oraInventory/logs/UpdateNodeList2020-12-26_10-42-27AM.log
default: [WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped.
default: ACTION: Refer to the logs or contact Oracle Support Services.
default: ******************************************************************************
default: Check cluster configuration. Sat Dec 26 10:48:02 UTC 2020
default: ******************************************************************************
default: --------------------------------------------------------------------------------
default: Name Target State Server State details
default: --------------------------------------------------------------------------------
default: Local Resources
default: --------------------------------------------------------------------------------
default: ora.LISTENER.lsnr
default: ONLINE ONLINE london1 STABLE
default: ora.net1.network
default: ONLINE ONLINE london1 STABLE
default: ora.ons
default: OFFLINE OFFLINE london1 STABLE
default: --------------------------------------------------------------------------------
default: Cluster Resources
default: --------------------------------------------------------------------------------
default: ora.london1.vip
default: 1 ONLINE ONLINE london1 STABLE
default: --------------------------------------------------------------------------------
default: ******************************************************************************
default: Unzip database software. Sat Dec 26 10:48:02 UTC 2020
default: ******************************************************************************
default: ******************************************************************************
default: Do database software-only installation. Sat Dec 26 10:57:41 UTC 2020
default: ******************************************************************************
default: Launching Oracle Database Setup Wizard...
default: [FATAL] [INS-35355] The node london2 specified in response file is not part of the Oracle Clusterware detected.
default: CAUSE: The node list for the Oracle RAC database specified in the response file does not match the configuration stored in the OCR.
default: ACTION: Please specify a valid node or add this node london2 to the cluster.
default: ******************************************************************************
default: Run DB root scripts. Sat Dec 26 10:58:23 UTC 2020
default: ******************************************************************************
default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_london1.evilcorp.com_2020-12-26_10-58-23-811090140.log for the output of root script
default: sh: /u01/app/oracle/product/19.0.0/dbhome_1/root.sh: No such file or directory
default: ******************************************************************************
default: Create database. Sat Dec 26 10:58:24 UTC 2020
default: ******************************************************************************
default: [FATAL] java.lang.NullPointerException
default: ******************************************************************************
default: Check cluster configuration. Sat Dec 26 10:58:30 UTC 2020
default: ******************************************************************************
default: ******************************************************************************
default: Output from crsctl stat res -t Sat Dec 26 10:58:30 UTC 2020
default: ******************************************************************************
default: --------------------------------------------------------------------------------
default: Name Target State Server State details
default: --------------------------------------------------------------------------------
default: Local Resources
default: --------------------------------------------------------------------------------
default: ora.LISTENER.lsnr
default: ONLINE ONLINE london1 STABLE
default: ora.net1.network
default: ONLINE ONLINE london1 STABLE
default: ora.ons
default: OFFLINE OFFLINE london1 STABLE
default: --------------------------------------------------------------------------------
default: Cluster Resources
default: --------------------------------------------------------------------------------
default: ora.london1.vip
default: 1 ONLINE ONLINE london1 STABLE
default: --------------------------------------------------------------------------------
default: ******************************************************************************
default: Output from srvctl config database -d rac_db Sat Dec 26 10:58:31 UTC 2020
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1120 : The resource for database rac_db could not be found.
default: PRCR-1001 : Resource ora.rac_db.db does not exist
default: ******************************************************************************
default: Output from srvctl status database -d rac_db Sat Dec 26 10:58:31 UTC 2020
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1120 : The resource for database rac_db could not be found.
default: PRCR-1001 : Resource ora.rac_db.db does not exist
default: ******************************************************************************
default: Output from v$active_instances Sat Dec 26 10:58:32 UTC 2020
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 50: /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus: Permission denied
The SSH command responded with a non-zero exit status. Vagrant
assumes that this means the command failed. The output for this command
should be in the log above. Please read the output to determine what
went wrong.

Metadata file does not match checksum

I have several errors when running vagrant up for ol7_122. I am not sure if I do something wrong, or it is 'the system against me'. It looks like it is having checksum-troubles with yum @ oracle.

error.txt

Is this fixable? :)

Can't connect to RAC instances from host

The public network is defined like this in the Vagrantfiles of the machines:

config.vm.network "private_network", ip: var_public_ip, virtualbox__intnet: "public"

This creates an "internal network" which does not allow host->guest connections.

The alternative of connecting to one of the forwarded ports (1521 on the two nodes forwarded to 1521 and 1522 on the host) does not work - I suspect because the actual connection is moved to a different port after the initial connection to the listener and that will simply not work since communication on an arbitrary port is not allowed between guest and host.

I think this "public" network should be a virtualbox "host-only" network, which allows communication between all guests and the host.

This can be achieved by removing the virtualbox__intnet name from the definition of the network in all Vagrantfiles:

config.vm.network "private_network", ip: var_public_ip

With this change, I can successfully connect to an instance from the host, e.g. by using one of the scan listener IPs and port 1521.

RAC Install issue stuck at rpm part

Hello Guys,

git clone https://github.com/oraclebase/vagrant.git

after following the instruction for RAC installation(DNS Completed, node2-stuck, node1-pending), it gets stuck at the below point for an infinite time. Can you please help me?

**### default:   Installing : 32:bind-utils-9.11.4-26.P2.el7_9.5.x86_64                  36/37**

default: Transaction test succeeded
default: Running transaction
default: Installing : 32:bind-license-9.11.4-26.P2.el7_9.5.noarch 1/37
default: Installing : libXau-1.0.8-2.1.el7.x86_64 2/37
default: Installing : libxcb-1.13-1.el7.x86_64 3/37
default: Installing : libaio-0.3.109-13.el7.x86_64 4/37
default: Installing : libICE-1.0.9-9.el7.x86_64 5/37
default: Installing : libSM-1.2.2-2.el7.x86_64 6/37
default: Installing : libaio-devel-0.3.109-13.el7.x86_64 7/37
default: Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 8/37
default: Installing : compat-libcap1-1.10-7.el7.x86_64 9/37
default: Installing : ksh-20120801-142.0.1.el7.x86_64 10/37
default: Installing : libX11-common-1.6.7-3.el7_9.noarch 11/37
default: Installing : libX11-1.6.7-3.el7_9.x86_64 12/37
default: Installing : libXext-1.3.3-3.el7.x86_64 13/37
default: Installing : libXi-1.7.9-1.el7.x86_64 14/37
default: Installing : libXrender-0.9.10-1.el7.x86_64 15/37
default: Installing : libXrandr-1.5.1-2.el7.x86_64 16/37
default: Installing : libXtst-1.2.3-1.el7.x86_64 17/37
default: Installing : libXxf86misc-1.0.3-7.1.el7.x86_64 18/37
default: Installing : libdmx-1.1.3-3.el7.x86_64 19/37
default: Installing : libXinerama-1.1.3-2.1.el7.x86_64 20/37
default: Installing : libXv-1.0.11-1.el7.x86_64 21/37
default: Installing : libXxf86vm-1.1.4-1.el7.x86_64 22/37
default: Installing : libXxf86dga-1.1.4-2.1.el7.x86_64 23/37
default: Installing : xorg-x11-utils-7.5-23.el7.x86_64 24/37
default: Installing : libXt-1.1.5-3.el7.x86_64 25/37
default: Installing : libXmu-1.1.2-2.el7.x86_64 26/37
default: Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 27/37
default: Installing : 1:smartmontools-7.0-2.el7.x86_64 28/37
default: Installing : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64 29/37
default: Installing : sysstat-10.1.5-19.el7.x86_64 30/37
default: Installing : libstdc++-devel-4.8.5-44.0.3.el7.x86_64 31/37
default: Installing : geoipupdate-2.5.0-1.el7.x86_64 32/37
default: Installing : GeoIP-1.5.0-14.el7.x86_64 33/37
default: Installing : 32:bind-libs-lite-9.11.4-26.P2.el7_9.5.x86_64 34/37
default: Installing : 32:bind-libs-9.11.4-26.P2.el7_9.5.x86_64 35/37
### default: Installing : 32:bind-utils-9.11.4-26.P2.el7_9.5.x86_64 36/37

Thanks
Ajay Kumar

Disk full issue cannot proceed on grid installation

I have lots of errors when I tried the Oracle19c on Linux 8. Not sure why disk becomes full. Please help.

default: ******************************************************************************
default: Do grid software-only installation. Sun Apr 2 11:51:58 UTC 2023
default: ******************************************************************************
default: Preparing the home to patch...
default: Applying the patch /u01/software/34773504/34762026...
default: Successfully applied the patch.
default: The log can be found at: /tmp/GridSetupActions2023-04-02_11-51-58AM/installerPatchActions_2023-04-02_11-51-58AM.log
default: Launching Oracle Grid Infrastructure Setup Wizard...
default:
default: [WARNING] [INS-41808] Possible invalid choice for OSASM Group.
default: CAUSE: The name of the group you selected for the OSASM group is commonly used to grant other system privileges (For example: asmdba, asmoper, dba, oper).
default: ACTION: Oracle recommends that you designate asmadmin as the OSASM group.
default: [WARNING] [INS-41809] Possible invalid choice for OSDBA Group.
default: CAUSE: The group name you selected as the OSDBA for ASM group is commonly used for Oracle Database administrator privileges.
default: ACTION: Oracle recommends that you designate asmdba as the OSDBA for ASM group, and that the group should not be the same group as an Oracle Database OSDBA group.
default: [WARNING] [INS-41812] OSDBA and OSASM are the same OS group.
default: CAUSE: The chosen values for OSDBA group and the chosen value for OSASM group are the same.
default: ACTION: Select an OS group that is unique for ASM administrators. The OSASM group should not be the same as the OS groups that grant privileges for Oracle ASM access, or for database administration.
default: [WARNING] [INS-40109] The specified Oracle Base location is not empty on this server.
default: ACTION: Specify an empty location for Oracle Base.
default: [WARNING] [INS-32044] Specified location (/u01/app/19.0.0/grid) is on a volume without enough disk space on nodes:
default: [ol8-19-rac2].
default:
default: These nodes will be ignored and not participate in the configured Grid Infrastructure.
default: CAUSE: Specified location is on a volume with insufficient disk space. Required disk space: 6.9 GB.
default: [FATAL] [INS-32070] Could not remove the nodes [ol8-19-rac2] corresponding to following error code: INS-32044.
default: CAUSE: Installer requires that a minimum of 2 nodes remain for the Oracle Grid Infrastructure configuration to proceed.
default: ACTION: Ensure that at least 2 nodes remain for the configuration to proceed, otherwise specify a single cluster node information.
default: ADDITIONAL INFORMATION:
default: - [INS-32044] Specified location (/u01/app/19.0.0/grid) is on a volume without enough disk space on nodes: [ol8-19-rac2]. These nodes will be ignored and not participate in the configured Grid Infrastructure.
default:
default: - Cause: Specified location is on a volume with insufficient disk space. Required disk space: 6.9 GB.
default:
default:
default: Moved the install session logs to:
default: /u01/app/oraInventory/logs/GridSetupActions2023-04-02_11-51-58AM
default: ******************************************************************************
default: Run grid root scripts. Sun Apr 2 11:57:32 UTC 2023
default: ******************************************************************************
default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory
default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory
default: Check /u01/app/19.0.0/grid/install/root_ol8-19-rac1_2023-04-02_11-57-32-702896729.log for the output of root script
default: sh: /u01/app/19.0.0/grid/root.sh: No such file or directory
default: ******************************************************************************
default: Do grid configuration. Sun Apr 2 11:57:33 UTC 2023
default: ******************************************************************************
default: Launching Oracle Grid Infrastructure Setup Wizard...
default:
default: [FATAL] [INS-32603] The central inventory was not detected.
default: ACTION: The -executeConfigTools flag can only be used for an Oracle home software that has been already installed using the configure or upgrade options. Ensure that the orainstRoot.sh script, from the inventory location, has been executed.
default: Moved the install session logs to:
default: /u01/app/oraInventory/logs/GridSetupActions2023-04-02_11-57-33AM
default: ******************************************************************************
default: Create additional diskgroups. Sun Apr 2 11:57:35 UTC 2023
default: ******************************************************************************
default: /vagrant/scripts/oracle_grid_software_config.sh: line 48: /u01/app/19.0.0/grid/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Check cluster configuration. Sun Apr 2 11:57:35 UTC 2023
default: ******************************************************************************
default: /vagrant/scripts/oracle_grid_software_config.sh: line 63: /u01/app/19.0.0/grid/bin/crsctl: No such file or directory
default: ******************************************************************************
default: Unzip database software. Sun Apr 2 11:57:35 UTC 2023
default: ******************************************************************************
default: ******************************************************************************
default: Do database software-only installation. Sun Apr 2 11:59:07 UTC 2023
default: ******************************************************************************
default: Preparing the home to patch...
default: Applying the patch /u01/software/34773504/34762026...
default: Successfully applied the patch.
default: The log can be found at: /tmp/InstallActions2023-04-02_11-59-08AM/installerPatchActions_2023-04-02_11-59-08AM.log
default: Launching Oracle Database Setup Wizard...
default:
default: [FATAL] [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster.
default: CAUSE: Before you can install Oracle RAC, you must install Oracle Grid Infrastructure (Oracle Clusterware and Oracle ASM) on all servers to create a cluster.
default: ACTION: Oracle Grid Infrastructure for Clusterware is not installed. Install it either from the separate installation media included in your media pack, or install it by downloading it from Electronic Product Delivery (EPD) or the Oracle Technology Network (OTN). Oracle Grid Infrastructure normally is installed by a different operating system user than the one used for Oracle Database. It may need to be installed by your system administrator. See the installation guide for more details.
default: Moved the install session logs to:
default: /u01/app/oraInventory/logs/InstallActions2023-04-02_11-59-08AM
default: ******************************************************************************
default: Run DB root scripts. Sun Apr 2 12:04:45 UTC 2023
default: ******************************************************************************
default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_ol8-19-rac1_2023-04-02_12-04-45-806820172.log for the output of root script
default: sh: /u01/app/oracle/product/19.0.0/dbhome_1/root.sh: No such file or directory
default: ******************************************************************************
default: OJVM Patch for DB Software. Sun Apr 2 12:04:46 UTC 2023
default: ******************************************************************************
default: ******************************************************************************
default: Patch Oracle Grid Infrastructure Software. Sun Apr 2 12:04:46 UTC 2023
default: HOSTNAME=localhost.localdomain
default: ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
default: ******************************************************************************
default: ******************************************************************************
default: Unzip software. Sun Apr 2 12:04:46 UTC 2023
default: ******************************************************************************
default: Can't call method "uid" on an undefined value at /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/auto/database/bin/module/DBUtilServices.pm line 29.
default: ******************************************************************************
default: Patch Oracle Grid Infrastructure Software. Sun Apr 2 12:04:46 UTC 2023
default: HOSTNAME=ol8-19-rac2
default: ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
default: ******************************************************************************
default: ******************************************************************************
default: Unzip software. Sun Apr 2 12:04:46 UTC 2023
default: ******************************************************************************
default: 34773504/34762026/34765931/files/lib/libserver19.a/kdst1011.o: write error (disk full?). Continue? (y/n/^C)
default: warning: 34773504/34762026/34765931/files/lib/libserver19.a/kdst1011.o is probably truncated
default: /vagrant_scripts/oracle_software_patch.sh: line 26: opatchauto: command not found
default: ******************************************************************************
default: Create database. Sun Apr 2 12:05:15 UTC 2023
default: ******************************************************************************
default: [FATAL] java.lang.NullPointerException
default: ******************************************************************************
default: Save state of PDB to enable auto-start. Sun Apr 2 12:05:17 UTC 2023
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 32: /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Check cluster configuration. Sun Apr 2 12:05:17 UTC 2023
default: ******************************************************************************
default: ******************************************************************************
default: Output from crsctl stat res -t Sun Apr 2 12:05:17 UTC 2023
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 44: /u01/app/19.0.0/grid/bin/crsctl: No such file or directory
default: ******************************************************************************
default: Output from srvctl config database -d cdbrac Sun Apr 2 12:05:17 UTC 2023
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1027 : Failed to retrieve database cdbrac
default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered
default: CRS-0184 : Cannot communicate with the CRS daemon.
default: ******************************************************************************
default: Output from srvctl status database -d cdbrac Sun Apr 2 12:05:17 UTC 2023
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1027 : Failed to retrieve database cdbrac
default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered
default: CRS-0184 : Cannot communicate with the CRS daemon.
default: ******************************************************************************
default: Output from v$active_instances Sun Apr 2 12:05:18 UTC 2023
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 59: /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Setup End. Sun Apr 2 12:05:18 UTC 2023
default: ******************************************************************************

default: sed: can't read /home/oracle/scripts/server.xml: No such file or directory

Getting the following error for new ol8_19 and ol7_19 VMs.

Screen Shot 2021-06-19 at 12 49 38 pm

I think the following lines in ords_software_installation.sh should be modified from:
sed -i -e "s|###AJP_SECRET###|${AJP_SECRET}|g" ${SCRIPTS_DIR}/server.xml
sed -i -e "s|###AJP_ADDRESS###|${AJP_ADDRESS}|g" ${SCRIPTS_DIR}/server.xml

to:
sed -i -e "s|###AJP_SECRET###|${AJP_SECRET}|g" ${CATALINA_BASE}/conf/server.xml
sed -i -e "s|###AJP_ADDRESS###|${AJP_ADDRESS}|g" ${CATALINA_BASE}/conf/server.xml

Impacts multiple VMs

run error on node1

default: Running transaction
default: Preparing : 1/1
default:
default: Running scriptlet: cvuqdisk-1.0.10-1.x86_64 1/1
default:
default: Using default group oinstall to install package
default: Installing : cvuqdisk-1.0.10-1.x86_64 1/1
default:
default: Running scriptlet: cvuqdisk-1.0.10-1.x86_64 1/1
default:
default: Verifying : cvuqdisk-1.0.10-1.x86_64 1/1
default:
default:
default: Installed:
default: cvuqdisk-1.0.10-1.x86_64
default: Complete!
default: ******************************************************************************
default: Do grid software-only installation. Fri Jan 15 03:23:26 UTC 2021
default: ******************************************************************************
default: Preparing the home to patch...
default: Applying the patch /u01/software/31720429/31750108...
default: OPatch command failed while applying the patch. For details look at the logs from /u01/app/19.0.0/grid/cfgtoollogs/opatchauto/.
default: ******************************************************************************
default: Run grid root scripts. Fri Jan 15 03:23:33 UTC 2021
default: ******************************************************************************
default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory
default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory
default: Check /u01/app/19.0.0/grid/install/root_ol8-19-rac1_2021-01-15_03-23-33-682121533.log for the output of root script
default: sh: /u01/app/19.0.0/grid/root.sh: No such file or directory
default: ******************************************************************************
default: Do grid configuration. Fri Jan 15 03:23:34 UTC 2021
default: ******************************************************************************
default:
default: ERROR: The home is not clean. This home cannot be used since there was a failed OPatch execution in this home. Use a different home to proceed.
default: ******************************************************************************
default: Create additional diskgroups. Fri Jan 15 03:23:34 UTC 2021
default: ******************************************************************************
default: /vagrant/scripts/oracle_grid_software_config.sh: line 48: /u01/app/19.0.0/grid/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Check cluster configuration. Fri Jan 15 03:23:34 UTC 2021
default: ******************************************************************************
default: /vagrant/scripts/oracle_grid_software_config.sh: line 63: /u01/app/19.0.0/grid/bin/crsctl: No such file or directory
default: ******************************************************************************
default: Unzip database software. Fri Jan 15 03:23:34 UTC 2021
default: ******************************************************************************
default: ******************************************************************************
default: Do database software-only installation. Fri Jan 15 03:25:01 UTC 2021
default: ******************************************************************************
default: Preparing the home to patch...
default: Applying the patch /u01/software/31720429/31750108...
default: OPatch command failed while applying the patch. For details look at the logs from /u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/opatchauto/.
default: ******************************************************************************
default: Run DB root scripts. Fri Jan 15 03:25:08 UTC 2021
default: ******************************************************************************
default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_ol8-19-rac1_2021-01-15_03-25-08-275219312.log for the output of root script
default: sh: /u01/app/oracle/product/19.0.0/dbhome_1/root.sh: No such file or directory
default: ******************************************************************************
default: OJVM Patch for DB Software. Fri Jan 15 03:25:08 UTC 2021
default: ******************************************************************************
default: ******************************************************************************
default: Patch Oracle Grid Infrastructure Software. Fri Jan 15 03:25:08 UTC 2021
default: HOSTNAME=localhost.localdomain
default: ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
default: ******************************************************************************
default: ******************************************************************************
default: Unzip software. Fri Jan 15 03:25:08 UTC 2021
default: ******************************************************************************
default: Can't call method "uid" on an undefined value at /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/auto/database/bin/module/DBUtilServices.pm line 28.
default: ******************************************************************************
default: Patch Oracle Grid Infrastructure Software. Fri Jan 15 03:25:09 UTC 2021
default: HOSTNAME=ol8-19-rac2
default: ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
default: ******************************************************************************
default: ******************************************************************************
default: Unzip software. Fri Jan 15 03:25:09 UTC 2021
default: ******************************************************************************
default: /vagrant_scripts/oracle_software_patch.sh: line 26: opatchauto: command not found
default: ******************************************************************************
default: Create database. Fri Jan 15 03:27:42 UTC 2021
default: ******************************************************************************
default: [FATAL] java.lang.NullPointerException
default: ******************************************************************************
default: Save state of PDB to enable auto-start. Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 32: /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Check cluster configuration. Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: ******************************************************************************
default: Output from crsctl stat res -t Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 44: /u01/app/19.0.0/grid/bin/crsctl: No such file or directory
default: ******************************************************************************
default: Output from srvctl config database -d cdbrac Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1027 : Failed to retrieve database cdbrac
default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered
default: CRS-0184 : Cannot communicate with the CRS daemon.
default: ******************************************************************************
default: Output from srvctl status database -d cdbrac Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: /u01/app/oracle/product/19.0.0/dbhome_1/bin/srvctl: line 259: /u01/app/oracle/product/19.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory
default: PRCD-1027 : Failed to retrieve database cdbrac
default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered
default: CRS-0184 : Cannot communicate with the CRS daemon.
default: ******************************************************************************
default: Output from v$active_instances Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************
default: /vagrant/scripts/oracle_create_database.sh: line 59: /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus: Permission denied
default: ******************************************************************************
default: Setup End. Fri Jan 15 03:27:44 UTC 2021
default: ******************************************************************************

Getting issue installing/configuring Vagrant using VirtualBox 7.0

Hi!

Please advise. Thanks.

I used the latest VirtualBox version 7.0, I used the latest Git and Vagrant software too. I recently formatted my desktop, so I decided to download all the latest versions of the software I need to have an Oracle 19c RAC database. However, I am getting these errors...

===================================================================
C:\Users\Charmaine L. Medina\vagrant\rac\ol8_19\dns>vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Box 'oraclebase/oracle-8' could not be found. Attempting to find and install...
default: Box Provider: virtualbox
default: Box Version: >= 0
==> default: Loading metadata for box 'oraclebase/oracle-8'
default: URL: https://vagrantcloud.com/oraclebase/oracle-8
==> default: Adding box 'oraclebase/oracle-8' (v2023.07.20) for provider: virtualbox
default: Downloading: https://vagrantcloud.com/oraclebase/boxes/oracle-8/versions/2023.07.20/providers/virtualbox.box
default:
default: Calculating and comparing box checksum...
==> default: Successfully added box 'oraclebase/oracle-8' (v2023.07.20) for 'virtualbox'!
==> default: Importing base box 'oraclebase/oracle-8'...
==> default: Matching MAC address for NAT networking...
==> default: Checking if box 'oraclebase/oracle-8' version '2023.07.20' is up to date...
==> default: Setting the name of the VM: ol8_19_dns
Vagrant is currently configured to create VirtualBox synced folders with
the SharedFoldersEnableSymlinksCreate option enabled. If the Vagrant
guest is not trusted, you may want to disable this option. For more
information on this option, please refer to the VirtualBox manual:

https://www.virtualbox.org/manual/ch04.html#sharedfolders

This option can be disabled globally with an environment variable:

VAGRANT_DISABLE_VBOXSYMLINKCREATE=1

or on a per folder basis within the Vagrantfile:

config.vm.synced_folder '/host/path', '/guest/path', SharedFoldersEnableSymlinksCreate: false
==> default: Clearing any previously set network interfaces...
There was an error while executing VBoxManage, a CLI used by Vagrant
for controlling VirtualBox. The command and stderr is shown below.

Command: ["hostonlyif", "ipconfig", "VirtualBox Host-Only Ethernet Adapter #2", "--ip", "192.168.56.1", "--netmask", "255.255.255.0"]

Stderr: VBoxManage.exe: error: The host network interface named 'VirtualBox Host-Only Ethernet Adapter #2' could not be found
VBoxManage.exe: error: Details: code E_INVALIDARG (0x80070057), component HostWrap, interface IHost, callee IUnknown
VBoxManage.exe: error: Context: "FindHostNetworkInterfaceByName(Bstr(pszName).raw(), hif.asOutParam())" at line 242 of file VBoxManageHostonly.cpp

C:\Users\Charmaine L. Medina\vagrant\rac\ol8_19\dns>vagrant halt

C:\Users\Charmaine L. Medina\vagrant\rac\ol8_19\dns>vagrant destroy -f
==> default: Destroying VM and associated drives...

C:\Users\Charmaine L. Medina\vagrant\rac\ol8_19\dns>

Hi

Hi Dear,
in the https://github.com/oraclebase/vagrant/blob/master/rac/ol8_19/shared_scripts/configure_shared_disks.sh

the owner would be grid but not oracle ,right?

cat > /etc/udev/rules.d/99-oracle-asmdevices.rules <<EOF
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="${ASM_DISK1}", SYMLINK+="oracleasm/asm-crs-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="${ASM_DISK2}", SYMLINK+="oracleasm/asm-crs-disk2", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="${ASM_DISK3}", SYMLINK+="oracleasm/asm-crs-disk3", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="${ASM_DISK4}", SYMLINK+="oracleasm/asm-data-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="${ASM_DISK5}", SYMLINK+="oracleasm/asm-reco-disk1", OWNER="oracle", GROUP="dba", MODE="0660"
EOF

Problem with node1

Hello Tim,
I'm trying to use the ol7_19. The dns and the node2 machine sets up itself and starts without any problems, however when I try to do a vagrant up on node1 I get the following error:
C:/HashiCorp/Vagrant/embedded/gems/2.2.7/gems/net-scp-1.2.1/lib/net/scp.rb:398:in 'await_response_state': scp: /tmp/vagrant-insert-pubkey-1600895252: Cannot allocate memory (RuntimeError)

I have 16GB memory in my laptop and for this version it used to be enough.

Error from the scripts

==> default: Forcing shutdown of VM...
==> default: Destroying VM and associated drives...
Traceback (most recent call last):
36: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/lib/vagrant/action/builtin/wait_for_communicator.rb:16:in block in call' 35: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:63:in wait_for_ready'
34: from /opt/vagrant/embedded/lib/ruby/2.6.0/timeout.rb:108:in timeout' 33: from /opt/vagrant/embedded/lib/ruby/2.6.0/timeout.rb:33:in catch'
32: from /opt/vagrant/embedded/lib/ruby/2.6.0/timeout.rb:33:in catch' 31: from /opt/vagrant/embedded/lib/ruby/2.6.0/timeout.rb:33:in block in catch'
30: from /opt/vagrant/embedded/lib/ruby/2.6.0/timeout.rb:93:in block in timeout' 29: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:88:in block in wait_for_ready'
28: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:192:in ready?' 27: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/lib/vagrant/guest.rb:43:in capability'
26: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/lib/vagrant/capability_host.rb:111:in capability' 25: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/lib/vagrant/capability_host.rb:111:in call'
24: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/guests/linux/cap/public_key.rb:14:in insert_public_key' 23: from /opt/vagrant/embedded/lib/ruby/2.6.0/tempfile.rb:295:in open'
22: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/guests/linux/cap/public_key.rb:19:in block in insert_public_key' 21: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:307:in upload'
20: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:740:in scp_connect' 19: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:391:in connect'
18: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:742:in block in scp_connect' 17: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:337:in block in upload'
16: from /opt/vagrant/embedded/gems/2.2.9/gems/vagrant-2.2.9/plugins/communicators/ssh/communicator.rb:331:in block (2 levels) in upload' 15: from /opt/vagrant/embedded/gems/2.2.9/gems/net-scp-1.2.1/lib/net/scp.rb:284:in upload!'
14: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/channel.rb:272:in wait' 13: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:181:in loop'
12: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:181:in loop' 11: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:181:in block in loop'
10: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:228:in process' 9: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/event_loop.rb:29:in process'
8: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/event_loop.rb:101:in ev_preprocess' 7: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/event_loop.rb:101:in each'
6: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:250:in ev_preprocess' 5: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:540:in each_channel'
4: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:540:in each' 3: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/session.rb:250:in block in ev_preprocess'
2: from /opt/vagrant/embedded/gems/2.2.9/gems/net-ssh-5.2.0/lib/net/ssh/connection/channel.rb:323:in process' 1: from /opt/vagrant/embedded/gems/2.2.9/gems/net-scp-1.2.1/lib/net/scp.rb:369:in block (3 levels) in start_command'
/opt/vagrant/embedded/gems/2.2.9/gems/net-scp-1.2.1/lib/net/scp.rb:398:in `await_response_state': scp: /tmp/vagrant-insert-pubkey-1595053863: Cannot allocate memory (RuntimeError)

how to add disk

Hello Tim,

I want to create new diskgroup and I guess it needs to be done via scripts instead of directly from VBOX as it reads "vagrantfile" when we bringup the machine. can you please share some steps to do that.

Thanks
Ajay

Using Git on Windows Fail on "default: Running: inline script"

The issue:

PS V:\Virtual_Box\vagrant\rac\ol7_183\dns> vagrant up --provision
==> default: Running provisioner: shell...
    default: Running: inline script
: No such file or directorycripts/root_setup.sh
The SSH command responded with a non-zero exit status. Vagrant
assumes that this means the command failed. The output for this command
should be in the log above. Please read the output to determine what
went wrong.

How to fix it:
Download the dos2unix and convert all scritps files to unix format.

V:\Virtual_Box\vagrant\rac\ol7_183\node2\scripts>dos2unix *
dos2unix: Skipping ., not a regular file.
dos2unix: Skipping .., not a regular file.
dos2unix: converting file oracle_user_environment_setup.sh to Unix format...
dos2unix: converting file root_setup.sh to Unix format...
dos2unix: converting file setup.sh to Unix format...

Do it for all files that will run on Linux.

\ol7_183\shared_scripts*
node1\script*
node2\script*
dns\script*

Just sharing the solution

Error when deploying RAC

Hello Tim,
I have run this script multiple time. I single instances or dataguard are deployed without any issues. However, I have not been able to create RAC on 12 or 18c. These error below are just driving me crazy.

The dns and node2 work perfectly, but when I start node1, I get the error that the disk is not unique even after I destroy and redeploy the script. I think the rest of the error are just chain reaction of the first failure. Please advice.

default: default: Installed: default: cvuqdisk.x86_64 0:1.0.10-1 default: default: Complete! default: ****************************************************************************** default: Do grid software-only installation. Sun Dec 30 06:21:30 UTC 2018 default: ****************************************************************************** default: Launching Oracle Grid Infrastructure Setup Wizard... **default: [FATAL] [INS-30516] Please specify unique disk groups. default: CAUSE: Installer has detected that the diskgroup name provided already exists on the system. default: ACTION: Specify different disk group. default: [FATAL] [INS-30530] Following specified disks have invalid header status: [/dev/oracleasm/asm-disk1, /dev/oracleasm/asm-disk3, /dev/oracleasm/asm-disk4] default: ACTION: Ensure only Candidate or Provisioned disks are specified.** default: ****************************************************************************** default: Run grid root scripts. Sun Dec 30 06:22:23 UTC 2018 default: ****************************************************************************** **default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory default: sh: /u01/app/oraInventory/orainstRoot.sh: No such file or directory** default: Check /u01/app/18.0.0/grid/install/root_ol7-183-rac1.localdomain_2018-12-30_06-22-23-942200686.log for the output of root script **default: sh: /u01/app/18.0.0/grid/root.sh: No such file or directory** default: ****************************************************************************** default: Do grid configuration. Sun Dec 30 06:22:24 UTC 2018 default: ****************************************************************************** default: Launching Oracle Grid Infrastructure Setup Wizard... **default: [FATAL] [INS-32603] The central inventory was not detected.** default: ACTION: The -executeConfigTools flag can only be used for an Oracle home software that has been already installed using the configure or upgrade options. Ensure that the orainstRoot.sh script, from the inventory location, has been executed. default: ****************************************************************************** default: Check cluster configuration. Sun Dec 30 06:22:27 UTC 2018 default: ****************************************************************************** default: /vagrant/scripts/oracle_grid_software_config.sh: line 45: /u01/app/18.0.0/grid/bin/crsctl: No such file or directory default: ****************************************************************************** default: Unzip database software. Sun Dec 30 06:22:27 UTC 2018 default: ****************************************************************************** default: ****************************************************************************** default: Do database software-only installation. Sun Dec 30 06:24:40 UTC 2018 default: ****************************************************************************** default: Launching Oracle Database Setup Wizard... **default: [FATAL] [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster. default: CAUSE: Before you can install Oracle RAC, you must install Oracle Grid Infrastructure (Oracle Clusterware and Oracle ASM) on all servers to create a cluster. default: ACTION: Oracle Grid Infrastructure for Clusterware is not installed.** Install it either from the separate installation media included in your media pack, or install it by downloading it from Electronic Product Delivery (EPD) or the Oracle Technology Network (OTN). Oracle Grid Infrastructure normally is installed by a different operating system user than the one used for Oracle Database. It may need to be installed by your system administrator. See the installation guide for more details. default: ****************************************************************************** default: Run DB root scripts. Sun Dec 30 06:24:47 UTC 2018 default: ****************************************************************************** default: Check /u01/app/oracle/product/18.0.0/dbhome_1/install/root_ol7-183-rac1.localdomain_2018-12-30_06-24-47-612572414.log for the output of root script default: sh: /u01/app/oracle/product/18.0.0/dbhome_1/root.sh: No such file or directory default: ****************************************************************************** default: Create database. Sun Dec 30 06:24:47 UTC 2018 default: ****************************************************************************** default: [FATAL] java.lang.NullPointerException default: ****************************************************************************** default: Check cluster configuration. Sun Dec 30 06:24:50 UTC 2018 default: ****************************************************************************** default: ****************************************************************************** default: Output from crsctl stat res -t Sun Dec 30 06:24:50 UTC 2018 default: ****************************************************************************** default: /vagrant/scripts/oracle_create_database.sh: line 35: /u01/app/18.0.0/grid/bin/crsctl: No such file or directory default: ****************************************************************************** default: Output from srvctl config database -d cdbrac Sun Dec 30 06:24:50 UTC 2018 default: ****************************************************************************** default: /u01/app/oracle/product/18.0.0/dbhome_1/bin/srvctl: line 255: /u01/app/oracle/product/18.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory default: PRCD-1027 : Failed to retrieve database cdbrac default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered default: CRS-0184 : Cannot communicate with the CRS daemon. default: ****************************************************************************** default: Output from srvctl status database -d cdbrac Sun Dec 30 06:24:51 UTC 2018 default: ****************************************************************************** default: /u01/app/oracle/product/18.0.0/dbhome_1/bin/srvctl: line 255: /u01/app/oracle/product/18.0.0/dbhome_1/srvm/admin/getcrshome: No such file or directory default: PRCD-1027 : Failed to retrieve database cdbrac default: PRCR-1070 : Failed to check if resource ora.cdbrac.db is registered default: CRS-0184 : Cannot communicate with the CRS daemon. default: ****************************************************************************** default: Output from v$active_instances Sun Dec 30 06:24:51 UTC 2018 default: ****************************************************************************** default: /vagrant/scripts/oracle_create_database.sh: line 50: /u01/app/oracle/product/18.0.0/dbhome_1/bin/sqlplus: Permission denied The SSH command responded with a non-zero exit status. Vagrant assumes that this means the command failed. The output for this command should be in the log above. Please read the output to determine what went wrong.

Thanks

Ol8-19-rac1

It gets stuck for ever after grid root scripts

default: ******************************************************************************
default: Run grid root scripts. Thu Feb 18 23:38:28 UTC 2021
default: ******************************************************************************
default: Changing permissions of /u01/app/oraInventory.
default: Adding read,write permissions for group.
default: Removing read,write,execute permissions for world.
default: Changing groupname of /u01/app/oraInventory to oinstall.
default: The execution of the script is complete.
default: Changing permissions of /u01/app/oraInventory.
default: Adding read,write permissions for group.
default: Removing read,write,execute permissions for world.
default: Changing groupname of /u01/app/oraInventory to oinstall.
default: The execution of the script is complete.
default: Check /u01/app/19.0.0/grid/install/root_ol8-19-rac1_2021-02-18_23-38-28-757613879.log for the output of root script

Pls add support for proxy to yum repos in oracle linux boxes

Steps to reproduce issue in office network or over VPN network -

  1. clone repo
  2. cd dns
  3. vagrant up
    Error logs-
    Firewall. Tue May 31 08:53:38 UTC 2022
    default: ******************************************************************************
    default: ******************************************************************************
    default: Install dnsmasq. Tue May 31 08:53:38 UTC 2022
    default: ******************************************************************************
    default: Loaded plugins: ulninfo
    default: Retype new password: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f8c::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f86::2a7d: Network is unreachable"
    default: Trying other mirror.
    default: https://yum.oracle.com/repo/OracleLinux/OL7/UEKR6/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed to connect to 2600:1417:3f:f86::2a7d: Network is unreachable"

gridSetup.sh not found

Very much grateful for your wonderful work @oraclebase .

I have almost completed the setup using your detailed steps. But struck with one issue.

gridSetup_notfound

It says that the "gridSetup.sh" file is not present under the folder path "u01/app/21.0.0/grid".

I even verified the same to find no files under the mentioned folder.

Folder_grid

Node 2 install fails

DNS up un running
Node2 un un running
Node1 grid configuration fails with:

default: Do grid software-only installation. Wed Nov 18 23:32:46 UTC 2020
default: ******************************************************************************
default: Launching Oracle Grid Infrastructure Setup Wizard...
default: [FATAL] [INS-40718] Single Client Access Name (SCAN):ol7-19-scan could not be resolved.
default:    CAUSE: The name you provided as the SCAN could not be resolved using TCP/IP host name lookup.
default:    ACTION: Provide name to use for the SCAN for which the domain can be resolved.

dnsmasq

Hi, I have a lot of issues with dnsmasq. Here is the sequence.

  1. dns, vagrant up, ok
  2. node2, vagrant up, ok
  3. ssh to node2,
    [vagrant@ol8-21-rac2 ~]$ nslookup ol8-21-scan
    ;; connection timed out; no servers could be reached
    but dns is up, service is running.
  4. reboot dns.
  5. ssh to node2, nslookup will work.
  6. reboot node2
  7. ssh to node2, nslookup fail again.

i cannot figure out what caused this. because of dns issue, when i do node1, it will fail, because it cannot resolve the scan address. anybody else have the same issue? I tried ol7_21 and ol8_21. same issue.

jw

OL7 19C RAC Installation node1 error

Hi Tim,

I was following the steps from your site and I ran into an error very similar to the one in #15 . The only changes I made were amending the file paths and slightly reducing the memory allocated to each node.
I'm not sure if related, but I was also experiencing the "Windows Host Build Failure" issue that is in the README and I got past it using the suggested fix (to restart the DNS node).
If you have any suggestions, that would be great. Thank you very much!

default: Do grid software-only installation. Fri Jan 8 22:45:48 UTC 2021
default: ******************************************************************************
default: Launching Oracle Grid Infrastructure Setup Wizard...
default: [WARNING] [INS-41808] Possible invalid choice for OSASM Group.
default:    CAUSE: The name of the group you selected for the OSASM group is commonly used to grant other system privileges (For example: asmdba, asmoper, dba, oper).
default:    ACTION: Oracle recommends that you designate asmadmin as the OSASM group.
default: [WARNING] [INS-41809] Possible invalid choice for OSDBA Group.
default:    CAUSE: The group name you selected as the OSDBA for ASM group is commonly used for Oracle Database administrator privileges.
default:    ACTION: Oracle recommends that you designate asmdba as the OSDBA for ASM group, and that the group should not be the same group as an Oracle Database OSDBA group.
default: [WARNING] [INS-41812] OSDBA and OSASM are the same OS group.
default:    CAUSE: The chosen values for OSDBA group and the chosen value for OSASM group are the same.
default:    ACTION: Select an OS group that is unique for ASM administrators. The OSASM group should not be the same as the OS groups that grant privileges for Oracle ASM access, or for database administration.
default: [WARNING] [INS-40109] The specified Oracle Base location is not empty on this server.
default:    ACTION: Specify an empty location for Oracle Base.
default: [WARNING] [INS-13014] Target environment does not meet some optional requirements.
default:    CAUSE: Some of the optional prerequisites are not met. See logs for details. gridSetupActions2021-01-08_10-45-48PM.log
default:    ACTION: Identify the list of failed prerequisite checks from the log: gridSetupActions2021-01-08_10-45-48PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
default: The response file for this session can be found at:
default:  /u01/app/19.0.0/grid/install/response/grid_2021-01-08_10-45-48PM.rsp
default:
default: You can find the log of this install session at:
default:  /tmp/GridSetupActions2021-01-08_10-45-48PM/gridSetupActions2021-01-08_10-45-48PM.log
default:
default: As a root user, execute the following script(s):
default:
default:    1. /u01/app/oraInventory/orainstRoot.sh
default:    2. /u01/app/19.0.0/grid/root.sh
default: Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
default: [ol7-19-rac1, ol7-19-rac2]
default: Execute /u01/app/19.0.0/grid/root.sh on the following nodes:
default: [ol7-19-rac1, ol7-19-rac2]
default:
default: Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.
default:
default: Successfully Setup Software with warning(s).
default: As install user, execute the following command to complete the configuration.
default:    /u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -responseFile /u01/app/19.0.0/grid/install/response/gridsetup.rsp [-silent]
default:
default: Moved the install session logs to:
default:  /u01/app/oraInventory/logs/GridSetupActions2021-01-08_10-45-48PM
default: ******************************************************************************
default: Run grid root scripts. Fri Jan 8 22:50:37 UTC 2021
default: ******************************************************************************
default: Changing permissions of /u01/app/oraInventory.
default: Adding read,write permissions for group.
default: Removing read,write,execute permissions for world.
default: Changing groupname of /u01/app/oraInventory to oinstall.
default: The execution of the script is complete.
default: Changing permissions of /u01/app/oraInventory.
default: Adding read,write permissions for group.
default: Removing read,write,execute permissions for world.
default: Changing groupname of /u01/app/oraInventory to oinstall.
default: The execution of the script is complete.
default: Check /u01/app/19.0.0/grid/install/root_ol7-19-rac1.localdomain_2021-01-08_22-50-37-602963170.log for the output of root script
default: Check /u01/app/19.0.0/grid/install/root_ol7-19-rac2.localdomain_2021-01-09_00-03-05-829161842.log for the output of root script
default: ******************************************************************************
default: Do grid configuration. Sat Jan 9 00:03:34 UTC 2021
default: ******************************************************************************
default: Launching Oracle Grid Infrastructure Setup Wizard...
default: The configuration that needs to be performed as privileged user is not completed. The configuration tools can only be executed after that.
default: You can find the logs of this session at:
default: /u01/app/oraInventory/logs/GridSetupActions2021-01-09_00-03-34AM
default:
default: As a root user, execute the following script(s):
default:    1. /u01/app/19.0.0/grid/root.sh
default:
default: Execute /u01/app/19.0.0/grid/root.sh on the following nodes:
default: [ol7-19-rac1, ol7-19-rac2]
default:
default: Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. After the successful root script execution, proceed to re-run the same 'gridSetup.sh -executeConfigTools' command.
default:
default: Successfully Configured Software.
default: ******************************************************************************
default: Create additional diskgroups. Sat Jan 9 00:04:05 UTC 2021
default: ******************************************************************************
default:
default: SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 9 00:04:05 2021
default: Version 19.3.0.0.0
default:
default: Copyright (c) 1982, 2019, Oracle.  All rights reserved.
default:
default: Connected to:
default: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
default: Version 19.3.0.0.0
default: SQL>   2
default: Diskgroup created.
default:
default: SQL>   2
default:
default: Diskgroup created.
default: SQL>
default: SQL> SQL> SQL>
default:
default: NAME                              COMPATIBILITY
default: ------------------------------ ------------------------------------------------------------
default: CRS                               19.0.0.0.0
default: DATA                              19.0.0.0.0
default: RECO                              19.0.0.0.0
default:
default: SQL>
default: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
default: Version 19.3.0.0.0
default: ******************************************************************************
default: Check cluster configuration. Sat Jan 9 00:04:24 UTC 2021
default: ******************************************************************************
default: ******************************************************************************
default: Unzip database software. Sat Jan 9 00:04:24 UTC 2021
default: ******************************************************************************
default: ******************************************************************************
default: Do database software-only installation. Sat Jan 9 00:07:56 UTC 2021
default: ******************************************************************************
default: Launching Oracle Database Setup Wizard...
default: [FATAL] [INS-35355] The node ol7-19-rac2 specified in response file is not part of the Oracle Clusterware detected.
default:    CAUSE: The node list for the Oracle RAC database specified in the response file does not match the configuration stored in the OCR.
default:    ACTION: Please specify a valid node or add this node ol7-19-rac2 to the cluster.
default: ******************************************************************************
default: Run DB root scripts. Sat Jan 9 00:08:09 UTC 2021
default: ******************************************************************************
default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_ol7-19-rac1.localdomain_2021-01-09_00-08-09-790757046.log for the output of root script
default: sh: /u01/app/oracle/product/19.0.0/dbhome_1/root.sh: No such file or directory
default: ******************************************************************************

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.