13
Jun

DataPump Job fails after Database Upgrade

Symptoms:

DataPump job fails with the following errors:

[oracle@ebsdb01 expdp]$ expdp system/manager tables=employees directory=EXPDP dumpfile=emp_data.dmp logfile=expdp.log
 
Export: Release 11.2.0.4.0 - Production on Thu Jun 10 15:19:55 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found

ORA-39097: Data Pump job encountered unexpected error 100

Read more...

3
Jun

Mount Block Volume as a Shared File System on multiple Linux servers on Oracle Cloud

Goal:

A single Block Volume to be mounted on multiple servers.
 
We will attach a block volume on node 1 i.e. erpapp1.
The same block volume will be mounted on node 2 i.e. erpapp2.

 
Create a block volume and attach it to the compute instance.
 

There are two unformatted drives on Node 1:

  • /dev/sdc
  • /dev/sdc
     
    Format the drive.
     

    mkfs.xfs /dev/sdc
    mkfs.xfs /dev/sdc


    [root@erpapp1 ~]# mkfs.xfs /dev/sdd
    meta-data=/dev/sdd isize=256 agcount=4, agsize=3276800 blks
    = sectsz=4096 attr=2, projid32bit=1
    = crc=0 finobt=0, sparse=0, rmapbt=0, reflink=0
    data = bsize=4096 blocks=13107200, imaxpct=25
    = sunit=0 swidth=0 blks
    naming =version 2 bsize=4096 ascii-ci=0 ftype=1
    log =internal log bsize=4096 blocks=6400, version=2
    = sectsz=4096 sunit=1 blks, lazy-count=1
    realtime =none extsz=4096 blocks=0, rtextents=0


    [root@erpapp1 ~]# blkid
    /dev/sda3: UUID="b1d6c458-09df-4003-91f8-274d9bb47090" TYPE="xfs" PARTUUID="de4cf50d-6ab6-4b33-a1bb-b702baadb616"
    /dev/sda1: SEC_TYPE="msdos" UUID="87DD-8565" TYPE="vfat" PARTLABEL="EFI System Partition" PARTUUID="8fb535c2-3a84-4cba-b9d1-46861f4ce6fb"
    /dev/sda2: UUID="72b79731-1dec-4324-849b-ce3027278329" TYPE="swap" PARTUUID="a01c99a8-6311-4a73-9861-a107ea867dc3"
    /dev/sdb: UUID="43b5eb95-de8d-452f-a8c3-8c883bf4c587" TYPE="xfs"
    /dev/sdc: UUID="fd78adbf-d224-4552-b59a-89e93bf7bfcc" TYPE="xfs"
    /dev/sdd: UUID="e958eed2-a136-4395-b8c0-e4718d46c571" TYPE="xfs"

    Read more...

  • 22
    Jan

    ADOP Fails with message " [ERROR]: Domain might be locked by some other WLS user process" and "[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script

    Symptoms:

    While running an ADOP session it fails due to the Weblogic domain being locked by another process.

     

    [applprod@erpapp1 ~]$ adop phase=fs_clone force=yes

    Enter the APPS password:
    Enter the SYSTEM password:
    Enter the WLSADMIN password:

    Validating credentials.

    Initializing.
    Run Edition context : /u01/oracle/EBSPROD/fs2/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml
    Patch edition context: /u01/oracle/EBSPROD/fs1/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml
    Patch file system free space: 273.40 GB

    Validating system setup.
    Node registry is valid.
    [WARNING] SYS.DUAL table has incorrect privileges
    Shut down the application tier services and then run the following commands in the order shown
    sqlplus apps/ @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
    sqlplus apps/
    @ $AD_TOP/sql/adutlrcmp.sql

    Checking for existing adop sessions.
    No pending session exists.
    Starting new adop session.

    ===========================================================================
    ADOP (C.Delta.11)
    Session ID: 48
    Node: erpapp1
    Phase: fs_clone
    Log: /u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/adop.log
    ===========================================================================

    Validating configuration on node: [erpapp1].
    Log: /u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/fs_clone/validate/erpapp1
    [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
    [ERROR]: Domain might be locked by some other WLS user process
    [UNEXPECTED]Error occurred running "perl /u02/oracle/EBSPROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/oracle/EBSPROD/fs2/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml -patchctxfile=/u01/oracle/EBSPROD/fs1/inst/apps/EBSPROD_erpapp1/appl/admin/EBSPROD_erpapp1.xml -phase=fs_clone -logloc=/u02/oracle/EBSPROD/fs_ne/EBSapps/log/adop/48/20190902_123003/fs_clone/validate/erpapp1 -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on erpapp1

    Read more...

    9
    Dec

    Adding a Tablespace or Datafile in Primary Database causes the MRP in Physical Standby Database to terminate with error.

    Symptoms:

    Media Recovery Stopped on standby database after adding datafile on primary.
     

    Error:

    MRP0: Background Media Recovery terminated with error 1111
     
    Alert Logfile:


    Managed Standby Recovery not using Real Time Apply
    MRP0: Background Media Recovery terminated with error 1111
    Errors in file /u01/oracle/diag/rdbms/erpdr/ERPPROD/trace/ERPPROD_pr00_44120.trc:
    ORA-01111: name for data file 58 is unknown - rename to correct file
    ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
    ORA-01157: cannot identify/lock data file 58 - see DBWR trace file
    ORA-01111: name for data file 58 is unknown - rename to correct file
    ORA-01110: data file 58: '/u01/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00058'
    Recovery Slave PR00 previously exited with exception 1111
    MRP0: Background Media Recovery process shutdown (ERPPROD)

     
    Read more...

    22
    Oct

    Oracle Database Startup Failed due to diskgroup being inaccessible

    Symptoms:

    Error starting database with diskgroup is incomplete error.
     

    Try to start the database.


    SQL> startup
    ORACLE instance started.

    Total System Global Area 1.0055E+10 bytes
    Fixed Size 2261888 bytes
    Variable Size 3858762880 bytes
    Database Buffers 6174015488 bytes
    Redo Buffers 19742720 bytes
    ORA-00205: error in identifying control file, check alert log for more info

     
    Error in alert log:
    ALTER DATABASE MOUNT
    This instance was first to mount
    NOTE: Loaded library: System
    ORA-15025: could not open disk "/dev/mapper/mpathe"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    ORA-15025: could not open disk "/dev/mapper/mpathg"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    ORA-15025: could not open disk "/dev/mapper/mpathi"
    ORA-27041: unable to open file
    Linux-x86_64 Error: 13: Permission denied
    Additional information: 9
    SUCCESS: diskgroup DATA was dismounted
    ERROR: diskgroup DATA was not mounted
    ORA-00210: cannot open the specified control file
    ORA-00202: control file: '+DATA/ebstest/controlfile/control01.ctl'
    ORA-17503: ksfdopn:2 Failed to open file +DATA/ebstest/controlfile/control01.ctl
    ORA-15001: diskgroup "DATA" does not exist or is not mounted
    ORA-15040: diskgroup is incomplete
    ORA-15040: diskgroup is incomplete
    ORA-15040: diskgroup is incomplete
    ORA-205 signalled during: ALTER DATABASE MOUNT...


    Read more...

    Back to Top