Thursday, August 9, 2018

rootupgrade.sh failed 18c

 sh rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/18.0.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
y
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/18.0.0/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/vm33/crsconfig/rootcrs_vm33_2018-08-08_05-26-12PM.log
2018/08/08 17:27:55 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.
2018/08/08 17:27:55 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/08/08 17:29:04 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/08/08 17:29:04 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.
2018/08/08 17:29:20 CLSRSC-595: Executing upgrade step 3 of 19: 'GetOldConfig'.
2018/08/08 17:29:20 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/08/08 17:29:33 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2018/08/08 17:32:53 CLSRSC-693: CRS entities validation completed successfully.
2018/08/08 17:33:02 CLSRSC-515: Starting OCR manual backup.
2018/08/08 17:33:22 CLSRSC-516: OCR manual backup successful.
2018/08/08 17:33:34 CLSRSC-486:
 At this stage of upgrade, the OCR has changed.
 Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.
2018/08/08 17:33:34 CLSRSC-541:
 To downgrade the cluster:
 1. All nodes that have been upgraded must be downgraded.
2018/08/08 17:33:34 CLSRSC-542:
 2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2018/08/08 17:33:34 CLSRSC-615:
 3. The last node to downgrade cannot be a Leaf node.
2018/08/08 17:33:49 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/08/08 17:33:49 CLSRSC-595: Executing upgrade step 4 of 19: 'GenSiteGUIDs'.
2018/08/08 17:33:53 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.
2018/08/08 17:34:00 CLSRSC-363: User ignored prerequisites during installation
2018/08/08 17:34:19 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.
2018/08/08 17:34:36 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.
2018/08/08 17:34:36 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.
CLSCH-2005 : Oracle Cluster Health Analysis Service (OCHAD) failed due to a Grid Infrastructure Management Repository error.

Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor



2018/08/08 17:34:44 CLSRSC-180: An error occurred while executing the command '/u01/app/12.2.0/grid/bin/chactl query model'
Died at /u01/app/18.0.0/crs/install/orachm.pm line 1036.


Soltuon:
=========

srvctl stop cha
srvctl remove cha

re-run rootupgrade.sh

Thursday, June 21, 2018

opatchauto failed : 'ERROR: Invalid Patch location: /media/sf_Downloads/patch/27486326

Error:

2018-06-20 15:36:24,766 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='
Analysis for applying patches has failed:
'}
2018-06-20 15:36:24,767 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Host:vm32'}
2018-06-20 15:36:24,767 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='CRS Home:/u01/app/12.1.0.2'}
2018-06-20 15:36:24,768 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='Analysis for patches has failed.'}
2018-06-20 15:36:24,769 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='ERROR: Invalid Patch location: /media/sf_Downloads/patch/27486326

'}
2018-06-20 15:36:24,771 INFO  [1] com.oracle.cie.common.util.reporting.CommonReporter - Reporting console output : Message{id='null', message='OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.'}



Solution:

If file system shared from windows to linux on virtualbox then grid user permission should be like below

$ id grid
uid=501(grid) gid=54321(oinstall) groups=54321(oinstall),504(asmadmin),506(asmdba),507(asmoper),488(vboxsf)



Tuesday, April 3, 2018

Linux Error: 29: Illegal seek

Error

 lsnrctl start listener

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 02-APR-2018 18:37:22

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
   Linux Error: 29: Illegal seek


Workaround

  cat /etc/hosts
127.0.2.1 localhost ---> add this entry in /etc/hosts


Wednesday, February 28, 2018

libmawt.so: libXext.so.6: cannot open shared object file: No such file or?

yum -y install libXext*i686*

How to fix /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

yum -y install glibc*i686*

How to add raw disk for oracle rac in Linux 6?


1.Partition disk

 fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0xbb9171e3.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-652, default 652):
Using default value 652

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.


2. Repeat above disk for all

3. cat /etc/udev/rules.d/60-raw.rules
# Enter raw device bindings here.
#
# An example would be:
#   ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
#   ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdd1", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sde1", RUN+="/bin/raw /dev/raw/raw4 %N"
ACTION=="add", KERNEL=="raw*", OWNER="grid", GROUP=="asmdba", MODE=="0666"


4./sbin/start_udev
Starting udev:                                             [  OK  ]

5.

ls -lrt /dev/raw/
total 0
crw-rw-rw-. 1 grid asmdba 162, 0 Feb 28 07:19 rawctl
crw-rw-rw-. 1 grid asmdba 162, 2 Feb 28 07:19 raw2
crw-rw-rw-. 1 grid asmdba 162, 1 Feb 28 07:19 raw1
crw-rw-rw-. 1 grid asmdba 162, 4 Feb 28 07:19 raw4
crw-rw-rw-. 1 grid asmdba 162, 3 Feb 28 07:19 raw3