Web ADI error : BNE_UIX_PHYSICAL_DIRECTORY is not configured

Error :

Soultion :

1. Go into the responsibility: System Administrator

2. Navigate to Profile -> System -> Profile: BNE%Directory%

3. Remove any value in the profile BNE_UIX_PHYSICAL_DIRECTORY

4. Bounce the web server and retest the issue.

Perform the below If you still have the issue,

We had this issue in clone instance where production was working fine. We checked the profile option values in production and updated the corresponding values (according to clone server) in profile option "BNE%Directory%".

Ex :

Profile : BNE UIX Physical Directory 
Value :  /**/*******/apps/apps_st/comn/webapps/oacore/html/cabo


- Bounce opmn after the update. 

opmn/apache is exiting with status 2 in EBS R12.2

Issue :

bash-3.2$ ./adopmnctl.sh start

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 2

adopmnctl.sh: check the logfile /a01/appsclone/CLONE/fs2/inst/apps/CLONE_ahqtest/logs/appl/admin/log/adopmnctl.txt for more information ...


What was found in log?

Log file :

/a01/appsclone/CLONE/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1/diagnostics/logs/OPMN/opmn/opmn.log


Error found in log :

[2019-01-01T10:42:16+03:00] [opmn] [NOTIFICATION:1] [90] [ons-internal] ONS server initiated
[2019-01-01T10:42:16+03:00] [opmn] [TRACE:32] [] [internal] Host: ahqtest; Remote Port: 6233; Local Port: 6133; Pid: 15885; 11.1.1.9.0
[2019-01-01T10:42:16+03:00] [opmn] [TRACE:1] [522] [pm-internal] PM state directory exists: /a01/appsclone/CLONE/fs2/FMW_Home/webtier/instance
s/EBS_web_CLONE_OHS1/config/OPMN/opmn/states
[2019-01-01T10:42:16+03:00] [opmn] [NOTIFICATION:1] [675] [pm-internal] OPMN server ready. Request handling enabled
[2019-01-01T10:42:16+03:00] [opmn] [ERROR:1] [17] [ons-listener] 127.0.0.1;6133: BIND (Address already in use)
[2019-01-01T10:43:05+03:00] [opmn] [TRACE:32] [] [internal] ORACLE_HOME: /a01/appsclone/CLONE/fs2/FMW_Home/webtier
[2019-01-01T10:43:05+03:00] [opmn] [TRACE:32] [] [internal] ORACLE_INSTANCE: /a01/appsclone/CLONE/fs2/FMW_Home/webtier/instances/EBS_web_CLONE
_OHS1

Fix :

To resolve the issue test the following steps in a development instance and then migrate accordingly:

1. Stop all services.

2. Rename the directory: OPMN/opmn/states  (eg. /u01/EBS/1225/fs1/FMW_Home/webtier/instances/EBS_1/config/OPMN/opmn/states in the example above.)

bash-3.2$ cd -

/a01/appsclone/CLONE/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1/config/OPMN/opmn

mv states states_orig

rm -rf states

3. Restart the services and confirm the error no longer occurs.

bash-3.2$ ls

instance.properties  opmn.xml_orig        states               wallet

opmn.xml             ports.prop           states_orig

bash-3.2$ ./adopmnctl.sh start

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /a01/appsclone/CLONE/fs2/inst/apps/CLONE_ahqtest/logs/appl/admin/log/adopmnctl.txt for more information ...

bash-3.2$ ./adapcctl.sh start

You are running adapcctl.sh version 120.0.12020000.6

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /a01/appsclone/CLONE/fs2/inst/apps/CLONE_ahqtest/logs/appl/admin/log/adapcctl.txt for more information ...

References :

E-Business Suite Technology Stack OPMN Process Fails To Start With Error "Check Adopmnctl.txt" (Doc ID 2174221.1)

Step by step : Oracle database 18c installation in RHEL 7 64-bit

Hello,

OS :


Red Hat Enterprise Linux 7: 3.10.0-123.el7.x86_64 or later

Oracle User Environment Configuration Checklist :

If you have an existing Oracle software installation, and you are using the same user to install this installation, then unset the following environment variables: $ORACLE_HOME,$ORA_NLS10, and $TNS_ADMIN, $ORACLE_BASE, $ORACLE_SID


Storage Checklist for Oracle Database

At least 7.5 GB for Oracle Database Enterprise Edition.
At least 7.5 GB for Oracle Database Standard Edition 2.

Minimum Operating System Resource Parameter Settings


semmsl 250

semmns 32000

semopm 100

semmni 128

shmall Greater than or equal to the value of shmmax, in pages /proc/sys/kernel/shmall

shmmax Half the size of physical memory in bytes /proc/sys/kernel/shmmax

shmmni 4096

panic_on_oops 1

file-max 6815744

aio-max-nr 1048576

ip_local_port_range Minimum: 9000

ip_local_port_range Maximum: 65500

rmem_default 262144

rmem_max 4194304

wmem_default 262144

wmem_max 1048576

Packages for Red Hat Enterprise Linux 7 : 

bc

binutils-2.23.52.0.1-12.el7.x86_64

compat-libcap1-1.10-3.el7.x86_64

compat-libstdc++-33-3.2.3-71.el7.i686

compat-libstdc++-33-3.2.3-71.el7.x86_64

glibc-2.17-36.el7.i686

glibc-2.17-36.el7.x86_64

glibc-devel-2.17-36.el7.i686

glibc-devel-2.17-36.el7.x86_64

ksh

libaio-0.3.109-9.el7.i686

libaio-0.3.109-9.el7.x86_64

libaio-devel-0.3.109-9.el7.i686

libaio-devel-0.3.109-9.el7.x86_64

libX11-1.6.0-2.1.el7.i686

libX11-1.6.0-2.1.el7.x86_64

libXau-1.0.8-2.1.el7.i686

libXau-1.0.8-2.1.el7.x86_64

libXi-1.7.2-1.el7.i686

libXi-1.7.2-1.el7.x86_64

libXtst-1.2.2-1.el7.i686

libXtst-1.2.2-1.el7.x86_64

libgcc-4.8.2-3.el7.i686

libgcc-4.8.2-3.el7.x86_64

libstdc++-4.8.2-3.el7.i686

libstdc++-4.8.2-3.el7.x86_64

libstdc++-devel-4.8.2-3.el7.i686

libstdc++-devel-4.8.2-3.el7.x86_64

libxcb-1.9-5.el7.i686

libxcb-1.9-5.el7.x86_64

make-3.82-19.el7.x86_64 make-3.82-19.el7.x86_64

nfs-utils-1.3.0-0.21.el7.x86_64 (for Oracle ACFS)

net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware)

python-2.7.5-34.0.1.el7 (x86_64) (for Oracle ACFS Remote)

python-configshell-1.1.fb18-1.el7.noarch (for Oracle ACFS Remote)

python-rtslib-2.1.fb57-3.el7.noarch (for Oracle ACFS Remote)

python-six-1.9.0-2.el7.noarch (for Oracle ACFS Remote)

smartmontools-6.2-4.el7.x86_64

sysstat-10.1.5-1.el7.x86_64

targetcli-2.1.fb41-3.el7.noarch (for Oracle ACFS Remote)

Running Oracle Database Setup Wizard to Install Oracle Database


Log in as the Oracle installation owner user account (oracle) that you want to own the software binaries.

Download the Oracle Database installation image files (db_home.zip) to a directory of your choice. For example, you can download the image files to the /tmp directory.

Create the Oracle home directory and extract the image files that you have downloaded in to this Oracle home directory. For example:

$ mkdir -p /u01/app/oracle/product/18.0.0/dbhome_1

$ chgrp oinstall /u01/app/oracle/product/18.0.0/dbhome_1

$ cd /u01/app/oracle/product/18.0.0/dbhome_1

$ unzip -q /tmp/db_home.zip

From the Oracle home directory, run the runInstaller command to start the Oracle Database Setup Wizard.

$ cd /u01/app/oracle/product/18.0.0/dbhome_1

$ ./runInstaller

In the Select Configuration Option screen, select Create and configure a single instance database.

Select your installation type.

When prompted run root.sh as root user.


[root@prodapp /]# /appstier2/app/oracle/product/18.0.0/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= orauser
    ORACLE_HOME=  /appstier2/app/oracle/product/18.0.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
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.

References :

Requirements for Installing Oracle Database 18c on OL7 or RHEL7 64-bit (x86-64) (Doc ID 2426806.1)