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

22
Sep

Mounting an Oracle Cloud Object Storage Bucket as a File System on Windows

Create an Object Storage Bucket from the OCI Console.

Object Storage-1
Navigate to Object Storage.
 
Object Storage-2
Click Create Bucket.
 
Object Storage-3
Enter a name for the bucket and click on Create Bucket.

Read more...

11
Aug

Mounting an Oracle Cloud Object Storage Bucket as a File System on Linux

Create an Object Storage Bucket from the OCI Console.

Object Storage-1
Navigate to Object Storage.
 
Object Storage-2
Click Create Bucket.
 
Object Storage-3
Enter a name for the bucket and click on Create Bucket.

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

    Back to Top