Oracle database connection background info

For Oracle database TESTAPPS 

Bit of background :

http://www.orafaq.com/wiki/JDBC

http://www.dba-oracle.com/t_oracle_sid_instance_name_service_name.htm 

** ora1, ora2, ora3 and ora4 redacted server names - 

Thin driver

Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle.

It provides its own TCP/IP version of Oracle's SQL*Net protocol.

Because it is 100% Java, this driver is platform independent and can also run from a Web Browser (applets).

Oracle is replacing identifying databases by the SID with the new services approach. There is a third approach, TNSNames, which can be used if configured in the file tnsnames.ora correctly.

The Thin driver offers these kinds of URL formats for all of them:

SID (no longer recommended by Oracle to be used):

jdbc:oracle:thin:[<user>/<password>]@<host>[:<port>]:<SID>

Services:

jdbc:oracle:thin:[<user>/<password>]@//<host>[:<port>]/<service>

TNSNames:

jdbc:oracle:thin:[<user>/<password>]@<TNSName>

Also -

https://stackoverflow.com/questions/31570461/unable-to-connect-to-connect-to-oracle-12c-with-sid-but-service-name-works

12c and service names -

You're in a multitenant environment.

You should always use the SERVICE name when connecting to a 12c instance.

SID in a multitenant will always take you to the container database.

The pluggables running in the container will only be reachable by their service name.

Remember databases use self registration so listener will know about each database regardless.

When connection to ncs - the services works but not the SID as would be expected as on 12c.

(user status.java script throughout this changing the connection details to test the jdbc connection string)

[oracle@ORA01 admin]$ srvctl status database -db umb -v

Instance umbapps1 is running on node ora01 with online services oam,oms,prodcat,umb. Instance status: Open.

Instance umb2 is running on node ora02 with online services cch,cdcs,cmc,cng,cxs,ec,frm,ncs,nis,oms,pal,prodcat,umb2. Instance status: Open.

Instance umbapps3 is running on node ora03 with online services cch,cdcs,cmc,cng,cxs,ec,frm,ncs,nis,oam,pal,umb3. Instance status: Open.

Instance umbapps4 is running on node ora04 with online services cch,cdcs,cmc,cng,cxs,ec,frm,ncs,nis,oam,oms,pal,prodcat,umb4. Instance status: Open.

[oracle@ORA01 test_cub]$ sqlplus GUEST/.......@ora-scan:1521/ncs

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 8 04:43:34 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Wed Aug 08 2018 04:01:15 -04:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

GUEST@ora-scan:1521/ncs

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Using SID

[oracle@ORA01 test_cub]$ sqlplus GUEST/……………….@ora-scan:1521:ncs

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 8 04:43:44 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

ERROR:

ORA-12545: Connect failed because target host or object does not exist

To list full details about each service :

--check cardinality

oracle@ORA01 ~]$ crsctl status resource ora.umb.cch.svc -f |grep -i car

CARDINALITY=4
CARDINALITY_ID=0

[oracle@ORA01 test_cub]$ srvctl config service -d umbapps -s ncs

Service name: ncs

Server pool:

Cardinality: 3

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

AQ HA notifications: false

Global: false

Commit Outcome: false

Failover type:

Failover method:

TAF failover retries:

TAF failover delay:

Failover restore: NONE

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: NONE

Edition:

Pluggable database name:

Maximum lag time: ANY

SQL Translation Profile:

Retention: 86400 seconds

Replay Initiation Time: 300 seconds

Drain timeout:

Stop option:

Session State Consistency: DYNAMIC

GSM Flags: 0

Service is enabled

Preferred instances: umb2,umb3,umb4

Available instances: umb1

CSS critical: no

So the connection using services i.e. ncs works

Test connection using java connection string

[oracle@ORA01 test_cub]$ /home/oracle/test_cub status

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

CORE 12.2.0.1.0 Production

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

Global Name

UMBAPPS

Test JDBC connection

Connection using - jdbc:oracle:thin:@ora-scan:1521/ncs

but not the services jdbc:oracle:thin:@ora-scan:1521:ncs as would be expected.

[oracle@ORA01 test_cub]$ test_cub status

Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at status.main(status.java:17)

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:271)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:317)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)

... 6 more

No tnsnames services for ncs

[oracle@ORA01 admin]$ pwd

/u01/app/oracle/product/12.2.0/dbhome/network/admin

[oracle@ORA01 admin]$ ls -la | grep tns

-rw-------. 1 oracle oinstall 916 Apr 3 23:30 tnsnames_abp.ora

-rw-------. 1 oracle oinstall 916 Apr 3 23:34 tnsnames_cch.ora

-rw-------. 1 oracle oinstall 916 Apr 3 22:19 tnsnames_cmc.ora

.....(cut for brevity)

i.e.

[oracle@ORA01 admin]$ sqlplus  GUEST/………..@ncs

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 8 05:01:37 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

For ODS database

srvctl status database -db ods –v

Instance ods1 is running on node ora01 with online services ods_1. Instance status: Open.

Instance ods2 is running on node ora02 with online services ods_2. Instance status: Open.

Instance ods3 is running on node ora03 with online services ods_3. Instance status: Open.

Instance ods4 is running on node ora04 with online services ods_4. Instance status: Open.

The service connection and the tnsnames connection both work.

[oracle@ORA01 test_cub]$ test_cub status

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

CORE 12.2.0.1.0 Production

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

Global Name

ODS

Test JDBC connection

Connection using - jdbc:oracle:thin:@ora-scan:1521:ods

[oracle@ORA01 admin]$ sqlplus edw/……..@ods

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 8 04:56:20 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Wed Aug 08 2018 04:53:03 -04:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

We could do this to get the SID to work :

http://oracleinaction.com/12c-use_sid_as_service_listener_name/

Getting latest RAC version update

This is the response from oracle support on how to determine the latest patch/update required for a RAC database.

"RAC patches are released as GI PSU.
To know about the latest update available for all the version at anytime, refer below to the document and keep this document handy

Download Reference for Oracle Database / GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases ( Doc ID 2118136.2 )"

Patching Grid Infrastructure - 6880880 / 28714316

Quick notes on patch 6880880 (latest OPatch) and the October CPU (patch 28714316) for grid.

You could patch grid and the database together but this for Grid only.

Just did a quick cut & paste of the output with some redaction (server names etc).

https://oracle-base.com/articles/13c/cloud-control-13cr1-installation-on-oracle-linux-6-and-7

https://updates.oracle.com/download/6880880.html

Patch 28714316 - GI Oct 2018 Release Update 12.2.0.1.181016

oracle@serveroem grid]$ pwd

/u01/app/12.2.0/grid

[oracle@serveroem grid]$ unzip p6880880_122010_LINUX.zip

Archive:  p6880880_122010_LINUX.zip

replace OPatch/opatchprereqs/oui/knowledgesrc.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: A

  inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml

  inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml

  inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml

  inflating: OPatch/opatchprereqs/opatch/rulemap.xml

  ,,,,,,

  inflating: OPatch/scripts/opatch_jvm_discovery.bat

  inflating: OPatch/scripts/viewAliasInfo.sh

[oracle@serveroem grid]$ cd OPatch

[oracle@serveroem OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.16

OPatch succeeded.

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:00:17 2018

OPATCHAUTO-72083: Performing bootstrap operations failed.

OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..

OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:00:17 2018

Time taken to complete the session 0 minute, 0 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ grep -i crs= /u01/app/oraInventory/ContentsXML/inventory.xml

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ cd ..

[oracle@serveroem grid]$ oui/bin/runInstaller -updateNodeList -silent CRS=false ORACLE_HOME="/u01/app/12.2.0/grid"

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 4087 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

'UpdateNodeList' failed.

[oracle@serveroem grid]$ pwd

/u01/app/12.2.0/grid

[oracle@serveroem grid]$ cd OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:03:52 2018

OPATCHAUTO-72083: Performing bootstrap operations failed.

OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..

OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:03:53 2018

Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:38:21 2018

OPATCHAUTO-72083: Performing bootstrap operations failed.

OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..

OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:38:22 2018

Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ cd ..

Software only install of grid –

 [oracle@serveroem grid]$ ./gridSetup.sh

Launching Oracle Grid Infrastructure Setup Wizard...

--- Once grid installed then try patch again.

[oracle@serveroem grid]$ pwd

/u01/app/12.2.0/grid

[oracle@serveroem grid]$ cd OP*

 [oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:43:57 2018

Error: This Java instance does not support a 64-bit JVM.

Please install the desired version.

OPatchauto session completed at Mon Nov 26 07:43:57 2018

Time taken to complete the session 0 minute, 0 second

opatchauto bootstrapping failed with error code 1.

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ls -la

total 220

drwxr-xr-x 14 oracle oinstall  4096 Nov 26 06:54 .

drwxr-xr-x 68 oracle oinstall  4096 Nov 26 07:41 ..

drwxr-xr-x  6 oracle oinstall  4096 Nov 26 06:54 auto

drwxr-x---  2 oracle oinstall  4096 Oct 23 06:27 config

-rwxr-x---  1 oracle oinstall   589 Oct 23 06:27 datapatch

-rwxr-x---  1 oracle oinstall   627 Oct 23 06:27 datapatch.bat

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 docs

-rwxr-x---  1 oracle oinstall 23550 Oct 23 06:27 emdpatch.pl

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 jlib

drwxr-x---  5 oracle oinstall  4096 May 13  2018 jre

drwxr-xr-x 11 oracle oinstall  4096 Nov 26 06:54 modules

drwxr-xr-x  5 oracle oinstall  4096 Nov 26 06:54 ocm

-rwxr-x---  1 oracle oinstall 48433 Oct 23 06:27 opatch

-rwxr-x---  1 oracle oinstall  1442 Oct 23 06:32 opatchauto

-rwxr-x---  1 oracle oinstall   393 Oct 23 06:32 opatchauto.cmd

-rwxr-x---  1 oracle oinstall 16326 Oct 23 06:27 opatch.bat

-rwxr-x---  1 oracle oinstall 10122 Jun 15  2016 opatchdiag

-rwxr-x---  1 oracle oinstall  9422 Jun 15  2016 opatchdiag.bat

-rwxr-x---  1 oracle oinstall  4290 Oct 23 06:27 opatch_env.sh

-rwxr-x---  1 oracle oinstall  2551 Oct 23 06:27 opatch.pl

drwxr-xr-x  4 oracle oinstall  4096 Nov 26 06:54 opatchprereqs

-rwxr-x---  1 oracle oinstall  3159 Oct 23 06:27 operr

-rwxr-x---  1 oracle oinstall  4218 Oct 23 06:27 operr.bat

-rw-r-----  1 oracle oinstall  3177 Oct 23 06:27 operr_readme.txt

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 oplan

drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 oracle_common

drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 plugins

-rw-r-----  1 oracle oinstall  2980 Oct 23 06:27 README.txt

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 scripts

-rw-r-----  1 oracle oinstall    27 Oct 23 06:27 version.txt

[oracle@serveroem OPatch]$ cd jre

[oracle@serveroem jre]$ cd bin

[oracle@serveroem bin]$ ls

ControlPanel  java  javaws  jcontrol  jjs  keytool  orbd  pack200  policytool  rmid  rmiregistry  servertool  tnameserv  unpack200

[oracle@serveroem bin]$ ls -la

total 436

drwxr-xr-x 2 oracle oinstall   4096 May 13  2018 .

drwxr-x--- 5 oracle oinstall   4096 May 13  2018 ..

-r-xr-xr-x 1 oracle oinstall   6264 May 13  2018 ControlPanel

-r-xr-xr-x 1 oracle oinstall   5730 May 13  2018 java

-r-xr-xr-x 1 oracle oinstall 104523 May 13  2018 javaws

-r-xr-xr-x 1 oracle oinstall   6264 May 13  2018 jcontrol

-r-xr-xr-x 1 oracle oinstall   5881 May 13  2018 jjs

-r-xr-xr-x 1 oracle oinstall   5893 May 13  2018 keytool

-r-xr-xr-x 1 oracle oinstall   6029 May 13  2018 orbd

-r-xr-xr-x 1 oracle oinstall   5897 May 13  2018 pack200

-r-xr-xr-x 1 oracle oinstall   5997 May 13  2018 policytool

-r-xr-xr-x 1 oracle oinstall   5881 May 13  2018 rmid

-r-xr-xr-x 1 oracle oinstall   5893 May 13  2018 rmiregistry

-r-xr-xr-x 1 oracle oinstall   5909 May 13  2018 servertool

-r-xr-xr-x 1 oracle oinstall   6061 May 13  2018 tnameserv

-r-xr-xr-x 1 oracle oinstall 230044 May 13  2018 unpack200

[oracle@serveroem bin]$ mv java java_orig

[oracle@serveroem bin]$ pwd

/u01/app/12.2.0/grid/OPatch/jre/bin

[oracle@serveroem bin]$ ln -s /u01/app/12.2.0/grid/jdk/bin/java java

[oracle@serveroem bin]$ ./java -version

java version "1.8.0_91"

Java(TM) SE Runtime Environment (build 1.8.0_91-b14)

Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

[oracle@serveroem bin]$ pwd

/u01/app/12.2.0/grid/OPatch/jre/bin

n  This worked but need to confirm whether supported, the java with the supplied patch should work

[oracle@serveroem jre]$ cd ..

[oracle@serveroem OPatch]$ ls -la

total 220

drwxr-xr-x 14 oracle oinstall  4096 Nov 26 06:54 .

drwxr-xr-x 68 oracle oinstall  4096 Nov 26 07:41 ..

drwxr-xr-x  6 oracle oinstall  4096 Nov 26 06:54 auto

drwxr-x---  2 oracle oinstall  4096 Oct 23 06:27 config

-rwxr-x---  1 oracle oinstall   589 Oct 23 06:27 datapatch

-rwxr-x---  1 oracle oinstall   627 Oct 23 06:27 datapatch.bat

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 docs

-rwxr-x---  1 oracle oinstall 23550 Oct 23 06:27 emdpatch.pl

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 jlib

drwxr-x---  5 oracle oinstall  4096 May 13  2018 jre

drwxr-xr-x 11 oracle oinstall  4096 Nov 26 06:54 modules

drwxr-xr-x  5 oracle oinstall  4096 Nov 26 06:54 ocm

-rwxr-x---  1 oracle oinstall 48433 Oct 23 06:27 opatch

-rwxr-x---  1 oracle oinstall  1442 Oct 23 06:32 opatchauto

-rwxr-x---  1 oracle oinstall   393 Oct 23 06:32 opatchauto.cmd

-rwxr-x---  1 oracle oinstall 16326 Oct 23 06:27 opatch.bat

-rwxr-x---  1 oracle oinstall 10122 Jun 15  2016 opatchdiag

-rwxr-x---  1 oracle oinstall  9422 Jun 15  2016 opatchdiag.bat

-rwxr-x---  1 oracle oinstall  4290 Oct 23 06:27 opatch_env.sh

-rwxr-x---  1 oracle oinstall  2551 Oct 23 06:27 opatch.pl

drwxr-xr-x  4 oracle oinstall  4096 Nov 26 06:54 opatchprereqs

-rwxr-x---  1 oracle oinstall  3159 Oct 23 06:27 operr

-rwxr-x---  1 oracle oinstall  4218 Oct 23 06:27 operr.bat

-rw-r-----  1 oracle oinstall  3177 Oct 23 06:27 operr_readme.txt

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 oplan

drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 oracle_common

drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 plugins

-rw-r-----  1 oracle oinstall  2980 Oct 23 06:27 README.txt

drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 scripts

-rw-r-----  1 oracle oinstall    27 Oct 23 06:27 version.txt

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:45:20 2018

OPATCHAUTO-72046: Wallet option is not provided.

OPATCHAUTO-72046: Wallet option is required during patching as non-root user.

OPATCHAUTO-72046: Please provide a wallet option or execute as root user.

OPatchauto session completed at Mon Nov 26 07:45:21 2018

Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ sudo su -

[sudo] password for oracle:

Last login: Mon Nov 26 06:03:23 EST 2018 on pts/0

[root@serveroem ~]# cd /u01/app/12.2.0/grid/OPatch

[root@serveroem OPatch]# ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:45:58 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-11-26_07-46-01AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-11-26_07-46-03AM.log

The id for this session is L7NR

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Patch applicability verified successfully on home /u01/app/12.2.0/grid

Bringing down CRS service on home /u01/app/12.2.0/grid

Prepatch operation log file location: /u01/app/oracle/crsdata/serveroem/crsconfig/crspatch_serveroem_2018-11-26_07-46-14AM.log

CRS service brought down successfully on home /u01/app/12.2.0/grid

Start applying binary patch on home /u01/app/12.2.0/grid

Binary patch applied successfully on home /u01/app/12.2.0/grid

Starting CRS service on home /u01/app/12.2.0/grid

Postpatch operation log file location: /u01/app/oracle/crsdata/serveroem/crsconfig/crspatch_serveroem_2018-11-26_07-48-59AM.log

CRS service started successfully on home /u01/app/12.2.0/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:serveroem

CRS Home:/u01/app/12.2.0/grid

Version:12.2.0.1.0

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/28714316/26839277

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28566910

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662603

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662626

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662640

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

OPatchauto session completed at Mon Nov 26 07:49:00 2018

Time taken to complete the session 3 minutes, 2 seconds

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.16

Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/12.2.0/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/12.2.0/grid/oraInst.loc

OPatch version    : 12.2.0.1.16

OUI version       : 12.2.0.1.4

Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2018-11-26_07-51-14AM_1.log

Lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-11-26_07-51-14AM.txt

--------------------------------------------------------------------------------

Local Machine Information::

Hostname: serveroem

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c                                       12.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (5) :

Patch  28662640     : applied on Mon Nov 26 07:48:57 EST 2018

Unique Patch ID:  22450089

Patch description:  "ACFS OCT 2018 RELEASE UPDATE 12.2.0.1.181016 (28662640)"

   Created on 18 Sep 2018, 03:56:19 hrs PST8PDT

   Bugs fixed:

     21129279, 22591010, 23152694, 23181299, 23625427, 24285969, 24346777

.....

      28633255

Patch  28662626     : applied on Mon Nov 26 07:47:59 EST 2018

Unique Patch ID:  22461084

Patch description:  "OCW OCT 2018 RELEASE UPDATE 12.2.0.1.181016 (28662626)"

   Created on 23 Sep 2018, 10:10:55 hrs PST8PDT

   Bugs fixed:

     12816839....

Patch  28662603     : applied on Mon Nov 26 07:47:03 EST 2018

Unique Patch ID:  22485591

Patch description:  "Database Oct 2018 Release Update : 12.2.0.1.181016 (28662603)"

   Created on 5 Oct 2018, 03:26:32 hrs PST8PDT

   Bugs fixed:

     28390273......

      

Patch  28566910     : applied on Mon Nov 26 07:46:30 EST 2018

Unique Patch ID:  22413436

Patch description:  "TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S) (28566910)"

   Created on 28 Aug 2018, 23:01:25 hrs PST8PDT

   Bugs fixed:

     25728967.......

Patch  26839277     : applied on Mon Nov 26 07:46:23 EST 2018

Unique Patch ID:  21578760

Patch description:  "DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)"

   Created on 21 Sep 2017, 03:13:10 hrs PST8PDT

   Bugs fixed:

     26584906,,,,,,

Bugs list removed for brevity..

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@serveroem OPatch]$ pwd

/u01/app/12.2.0/grid/OPatch

Setup grid

[oracle@serveroem grid]$ ./gridSetup.sh

Launching Oracle Grid Infrastructure Setup Wizard...

----running root.sh

[root@serveroem grid]# ./root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/12.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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 script.

Now product-specific root actions will be performed.

To configure Grid Infrastructure for a Cluster or Grid Infrastructure for a Stand-Alone Server execute the following command as oracle user:

/u01/app/12.2.0/grid/gridSetup.sh

This command launches the Grid Infrastructure Setup Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

[root@serveroem grid]# pwd

/u01/app/12.2.0/grid

[root@serveroem grid]# ./root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/12.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

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 script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u01/app/12.2.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/serveroem/crsconfig/roothas_2018-11-26_07-58-06AM.log

2018/11/26 07:58:07 CLSRSC-363: User ignored prerequisites during installation

LOCAL ADD MODE

Creating OCR keys for user 'oracle', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node serveroem successfully pinned.

2018/11/26 07:58:14 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'serveroem'

CRS-2673: Attempting to stop 'ora.evmd' on 'serveroem'

CRS-2677: Stop of 'ora.evmd' on 'serveroem' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'serveroem' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

serveroem     2018/11/26 08:00:38     /u01/app/12.2.0/grid/cdata/serveroem/backup_20181126_080038.olr     476343201

2018/11/26 08:00:38 CLSRSC-327: Successfully configured Oracle Restart for a standalone server