Wednesday, 30 December 2020

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




 

Thursday, 7 May 2020

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