Tuesday, 5 August 2014



ORA-28040: No matching authentication protocol

==============================================

Cause: 

 

 In Oracle database 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.This will cause a Client Softwares (like SQL Developer) to fail with the ORA-28040: No matching authentication protocol error while connecting 12.1 Oracle Database

Solution: 

 Workaround: 

Set SQLNET.ALLOWED_LOGON_VERSION=8 in the $ORACLE_HOME/network/admin/sqlnet.ora file

Tuesday, 27 May 2014

Unable to login RWMS application after fresh installation

====================================================

I have installed Oracle Retail Warehouse Management System(RWMS) on RHEL 6.2. Installation had done successfully but when I tried to login RWMS application , it was showing error "Invalid User / or Password".
I searched a lot on google but didn't get solution. Finally I came to know the following facts:

1. RWMS installation user and application users are different.

2. When we pass credentials and try to login , application validate the user from DMS_USER table.

3. RWMS application's user are stored in DMS_USER table. These tables are owned by RWMS schema user.

4. With fresh installation of RWMS , only PR(Production) facility comes.

Cause: DMS_USER table of RWMS schema is blank.

Solution: 

1. cd <INSTALL_DIR>/rwms14/Install_Data/Source.
    Example: /u01/SIM_INSTALL_DIR/rwms/installer/rwms14/Install_Data/Source/base_dms_user.sql

2. export ORACLE_SID=<rwmsDB> // database of RWMS 

3. export ORACLE_HOME=<oracle_home_path>

4. Login to RWMS schema as: sqlplus <rwms_user>/<rwms_user_password>

5. Run base_dms_user.sql

    SQL>@base_dms_user.sql

6. Provide the username and password as 



7. Password must contain Alphabet and Numbers.

8. Check DMS_USER table, you will get one new record with assigned  username.

Now login into RWMS application with above created username/password and facility should be PR.

Good luck!!!!




Friday, 25 April 2014

How to install java on Linux?

================================================

Hi Friends. Installing Java on windows machine is very easy but when we have to install on Linux machine , it seems a tedious or tough task. It happened with me also. I went through many blogs but didn't find easy steps. So,in this blog I have tried to make it very simple to install java on linux.

1) Go to following link:




2) Download the jdk-X-linux-Y-.tar.gz file.
   
    Here X- Java Version
             Y- Linux arch.(i586-32bit, x64-64bit).

3) As root user, create a directory as 
     
    # mkdir /usr/java

4) Move the downloaded file in /usr/java.

5)  Extract the tar.gz file as
    
      # tar -zxvf  jdk-X-linux-Y-.tar.gz
    
    It will create a directory with jdkXXX name in /usr/java.

6) Open /etc/profile. Add following lines and save the file.
    
     JAVA_HOME=/usr/java/jdkXXX;
     export JAVA_HOME
     PATH=$JAVA_HOME/bin:$PATH;
     export PATH

7)  For existing session do as
     
       # source /etc/profile
    
      To bring it in effect for all users , restart the Linux machine.
      
8) Check java version as
     
     # java -version
   
     It should reflect the current version of java.

I hope you can do it easily.

Wednesday, 16 April 2014

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

================================================================

Cause :

SELINUX parameter of /etc/selinux/config  by default set to enforcing. This value of SELINUX restrict the OPMN process to start.

Symptom :  

After completion of the installation of Oracle EBS , sometime you may get this error. Don't worry about the error , Finish the installation process.



 1) Go to $APPL_TOP.
 2) Source the APPS_CONTEX_NAME.env(APPSVIS_ebsr149.env)
 3) cd $ADMIN_SCRIPTS_HOME
 4) sh adapcctl.sh status

The output of the above script will show error as:

ERROR: error while loading shared libraries libdms2.so: cannot restore segment prot after reloc: Permission denied

Solution :

1) Open /etc/selinux/config as root user.
2) Change the value of SELINUX parameter from 'enforcing' to 'disabled'. Save and exit.
3) To bring the change in effect reboot the system.
4) Start up database and application services.

It worked for me and hope it will help you too.