[Troubleshoot Socket:000445] Connection Rejected, Filter Blocked Socket While Accessing EBS R12 WebLogic Console

Issue:- The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

Solution:-   

1. Source the env file 

2. Bring Down the application Services 

3. Go to the location ----> cd $EBS_DOMAIN_HOME/config/

4. Take Backup of config.xml Change below parameter 

From: -

    <connection-filter-rule>0.0.0.0/0 * * deny</connection-filter-rule>

 To: -

    <connection-filter-rule>0.0.0.0/0 * * allow</connection-filter-rule>

 5. Bring up the Application Services.

 6.  After start the Admin Server, able to open the login page.

 

How to create directory in oracle database

            How to create directory in oracle database

Syntax:-

Using the 'create directory' statement to create a directory object in an Oracle database. The following statement creates a directory database object that points to a directory on the server:
CREATE OR REPLACE DIRECTORY <directory_name> AS '<UNIXBOX_system_path>';

Note:- 'directory_name’ is unique directory name and ‘UNIXBOX_system_path' specify the full path name of operating system directory of the server.


SQL> CREATE OR REPLACE DIRECTORY testing AS '/u01/TESTING';

SQL> GRANT READ, WRITE ON DIRECTORY testing TO APPS;


To check the Directory created.

SQL>SELECT * FROM DBA_DIRECTORIES;

SQL> SELECT * FROM ALL_DIRECTORIES;

OS Commend to create a directory:-

#mkdir -p /u01/TESTING
#chmod -R 777 /u01/TESTING

#ls -ltr /u01/TESTING

Oracle Apps R12.2 Log Files Location

1. R12.2 Start/Stop Log Files:
$INST_TOP/logs/appl/admin/log
Logfiles for start/stop of services from $ADMIN_SCRIPTS_HOME

Here is an image representing EBS R12.2 Service control (start/stop) logs:
Green color boxes indicate the location of log files

2. Patching log files
a) Online patching files are located in on the non-editioned file system(fs_ne) under:
$NE_BASE/ EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log

3. Log files for concurrent programs/managers
$NE_BASE/ inst/<CONTEXT_NAME>/logs/appl/conc/log
Output files for concurrent programs/managers
$NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out

Here is an image representing EBS R12.2 Non-Editioned file system Logs:

Patching Logfile location:

4. Cloning related Log files:

a) Pre-clone log files in the source instance

     I. Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

    II. Application Tier
$INST_TOP/admin/log/ (StageAppsTier_MMDDHHMM.log)

b) Clone log files in target instance

    I. Database Tier
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_<time>.log

    II. Apps Tier
$INST_TOP/admin/log/ApplyAppsTier_<time>.log

5. AutoConfig log file:
a) Autoconfig log location on application tier:
$INST_TOP/admin/log/$MMDDHHMM/adconfig.log

b) Autoconfig Log Location on Database tier:
$ORACLE_HOME/ appsutil/ log/ $CONTEXT_NAME/ <MMDDHHMM>/ *.log

6.  Installation Related Logs:

Four Phases of R12.2 installation
1) RapidWiz Configuration file saved in below locations:
$TMP/<MMDDHHMM>/conf_<SID>.txt
$INST_TOP/conf_<SID>.txt
<RDBMS ORACLE_HOME>/ appsutil/ conf_<SID>.txt

2) Pre-install system check logs:
$TMP/<MMDDHHMM>/<MMDDHHMM>.log
$TMP/dbPreInstCheck.xxxxx.log
$TMP/wtprechk.xxxx/wtprechk.xxxx.log
<Global Inventory>/logs/installActions<timestamp>.log

3) Database Tier logs:
a) Main installation logs:
RDBMS $ORACLE_HOME/ appsutil/ log/ $CONTEXT_NAME/ <MMDDHHMM>.log

b) ORACLE_HOME installation logs:
RDBMS $ORACLE_HOME/ temp/ $CONTEXT_NAME/ logs/ *.log
<Global Inventory>/logs/*.log

d) Application tier
Both primary(Run) and Secondary Edition (Patch) file systems will each contain these logs:
1. Main Installation logs:
$INST_TOP/logs/<MMDDHHMM>.log

2. FMW and OHS TechStack Installation/Patching logs:
$APPL_TOP/admin/$CONTEXT_NAME/log/*<Global Inventory>/logs/*.log

REPORT THIS AD

3.Forms Oracle Home installation logs:
$APPL_TOP/admin/$CONTEXT_NAME/log/*.log

Here is an image representing the R12.2 Installation logs,

6. Fusion Middleware (FMW_HOME) Log Files:

 a) Log files for OPMN and OHS processes: Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log), HTTP Transaction logs (access.log), security settings related logs.

$IAS_ORACLE_HOME/ instances/ <ohs_instance>/diagnostics/logs

b) Log files for weblogic node manager: Log file is generated by Node Manager and contains data for all domains that are controlled by Node Manager on a given physical machine.

$FMW_HOME/ wlserver_10.3/ common/ nodemanager/ nmHome1/ nodemanager.log

c) Log files for weblogic Oracle Management Service log file: Initial settings AdminServer and Domain level information is written in this log file.
$EBS_DOMAIN_HOME/sysman/log

d) Log files for server processes initiated through WebLogic: Stdout and stderr messages generated by the server instance (server instances like forms, oafm, oacore etc) at NOTICE severity level or higher are written by Weblogic Node Manager to the below directory.
$EBS_DOMAIN_HOME/ servers/ <server_name>/ logs/ <server_name>.out

Here is an image representing EBS R12.2 Fusion Middleware Log files:

Oracle EBS R12.1.1 file location

                                   Oracle EBS R12.1.1 file location

Autoconfig log file:

Apps:
$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log.

Database:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log 

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Startup/Shutdown Log files:
$INST_TOP/logs/appl/admin/log

Apache, OC4J and OPMN:
$LOG_HOME/ora/10.1.3/Apache $LOG_HOME/ora/10.1.3/j2ee $LOG_HOME/ora/10.1.3/opmn

Patch log:
$APPL_TOP/admin/$SID/log/

Concurrent log:
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log

Clone log:
Preclone log files in source instance 

Apps:
$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log) 

Database:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log) 

Clone log files in target instance

Apps :
$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log

Database:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log

Alert Log File:
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

APPL_TOP

[applmgr@saurabh ~]$ cd /oracle/PROD/apps/apps_st/appl

INST_TOP

[applmgr@saurabh ~]$ cd /oracle/PROD/inst/apps/context_name

COMMAN_TOP

[applmgr@saurabh ~]$ cd /oracle/PROD/apps/apps_st/comn

JAVA_TOP  

[applmgr@saurabh ~]$ cd /oracle/PROD/apps/apps_st/comn/java

Database_top  

[applmgr@saurabh ~]$ cd /oracle/PROD/db/tech_st/10.2.0/appsutil/scripts/PROD_saurabh/

Context file:-(.xml)
[applmgr@saurabh ~]$ cd /oracle/PROD/inst/apps/PROD_saurabh/appl/admin

Defaults file location:-(.txt)
[applmgr@saurabh ~]$ cd  /oracle/PROD/apps/app_st/appl/admin/PROD/adalldefault.txt

[applmgr@saurabh ~]$ cd APPL_TOP/admin/<SID> 

Autoconfig log file:-
[applmgr@saurabh ~]$ cd /oracle/PROD/inst/apps/PROD_saurabh/appl/admin/log

HOW TO MAKE SYMBOLS WITH KEYBOARD

HOW TO MAKE SYMBOLS WITH KEYBOARD

Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registered trademark symbol
Alt + 0176 ...°......degre­e symbol
Alt + 0177 ...±....plus-or­-minus sign
Alt + 0182 ...¶.....paragraph mark
Alt + 0190 ...¾....fractio­n, three-fourths
Alt + 0215 ....×.....multi­plication sign
Alt + 0162...¢....the cent sign
Alt + 0161.....¡..... .upside down exclamation point
Alt + 0191.....¿..... ­upside down question mark
Alt + 1...........smiley face
Alt + 2 ......☻.....bla­ck smiley face
Alt + 15.....☼.....su­n
Alt + 12......♀.....f emale sign
Alt + 11.....♂......m­ale sign
Alt + 6.......
♠

♦
...... ­Diamond
Alt + 13......♪.....e­ighth note
Alt + 14......♫...... ­beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s­quare root check mark
Alt + 8236.....∞..... ­infinity
Alt + 24.......↑..... ­up arrow
Alt + 25......↓...... ­down arrow
Alt + 26.....→.....ri­ght arrow
Alt + 27......←.....l­eft arrow
Alt + 18.....↕......u­p/down arrow
Alt + 29......↔... left right arrow