Wednesday, January 6, 2021

libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

 

Issue : When running rapidwiz thrown below error message.


rapidwiz]# Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/ebs_12.2.0/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
 at java.lang.ClassLoader$NativeLibrary.load(Native Method)
 at java.lang.ClassLoader.loadLibrary0(Unknown Source)
 at java.lang.ClassLoader.loadLibrary(Unknown Source)
 at java.lang.Runtime.load0(Unknown Source)
 at java.lang.System.load(Unknown Source)
 at java.lang.ClassLoader$NativeLibrary.load(Native Method)
 at java.lang.ClassLoader.loadLibrary0(Unknown Source)
 at java.lang.ClassLoader.loadLibrary(Unknown Source)
 at java.lang.Runtime.loadLibrary0(Unknown Source)
 at java.lang.System.loadLibrary(Unknown Source)
 at sun.security.action.LoadLibraryAction.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
 at sun.awt.DebugHelper.<clinit>(Unknown Source)
 at java.awt.Component.<clinit>(Unknown Source)
Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard.  Program will exit.




Solution :

[root@ebsdbdev01 ~]# yum install libXtst.i686

Loaded plugins: refresh-packagekit, security, ulninfo
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXtst.i686 0:1.2.2-2.1.el6 will be installed
--> Processing Dependency: libXi.so.6 for package: libXtst-1.2.2-2.1.el6.i686
--> Running transaction check
---> Package libXi.i686 0:1.7.2-2.2.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================================================================================================
 Package                                 Arch                                 Version                                          Repository                                         Size
=======================================================================================================================================================================================
Installing:
 libXtst                                 i686                                 1.2.2-2.1.el6                                    public_ol6_latest                                  18 k
Installing for dependencies:
 libXi                                   i686                                 1.7.2-2.2.el6                                    public_ol6_latest                                  36 k

Transaction Summary
=======================================================================================================================================================================================
Install       2 Package(s)

Total download size: 54 k
Installed size: 86 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): libXi-1.7.2-2.2.el6.i686.rpm                                                                                                                             |  36 kB     00:00
(2/2): libXtst-1.2.2-2.1.el6.i686.rpm                                                                                                                           |  18 kB     00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                   43 kB/s |  54 kB     00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libXi-1.7.2-2.2.el6.i686                                                                                                                                            1/2
  Installing : libXtst-1.2.2-2.1.el6.i686                                                                                                                                          2/2
  Verifying  : libXi-1.7.2-2.2.el6.i686                                                                                                                                            1/2
  Verifying  : libXtst-1.2.2-2.1.el6.i686                                                                                                                                          2/2

Installed:
  libXtst.i686 0:1.2.2-2.1.el6

Dependency Installed:
  libXi.i686 0:1.7.2-2.2.el6

Complete!


[root@ebsdbdev01 ~]# find / -iname libXtst.so.6
/usr/X11R6/lib/libXtst.so.6
/usr/lib64/libXtst.so.6
/usr/lib/libXtst.so.6

Tuesday, January 5, 2021

How to change apps& sysadmin password in R12.2

 

How to change apps user password in R12.2.4


Important Note: These steps must be carried out on the run file system.

Step 1. Shut down the application tier services using the

   [applmgr@document appl]$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password.

[applmgr@document appl]$ FNDCPASS apps/apps  0 Y system/ manager   SYSTEM APPLSYS <new apps passwd>

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS newpasswd



3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don't start any other application tier services.


4. Change the "apps" password in WLS Datasource as follows:
Log in to WLS Administration Console. http://document.subnet.vcn.oraclevcn.com:8000/OA_HTML/AppsLogin


Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the “Summary of JDBC Data Sources” page, select EBSDataSource
On the “Settings for EBSDataSource” page, select the Connection Pool tab.
Enter the new password in the “Password” field.
Enter the new password in the “Confirm Password” field.
Click Save.

Check whether you are able to connect to db using apps
sqlplus apps/<newpassword> from application tier.

Before Starting all the services. Run Autoconfig.
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh

Now start the services.
Start all the application tier services using the
$INST_TOP/admin/scripts/adstrtal.sh script.

 

How to change the SYSADMIN password

 

[applmgr@document appl]$  FNDCPASS apps/*** 0 Y system/manager USER SYSADMIN new_password


What is Apps Schema?

 

Apps is a schema which does not contain any tables of itself. We can say APPS is the shared runtime schema for all E-Business Suite products. It contains all the synonyms of all the table in Oracle apps. But it also contains packages, functions, procedures. The default password is apps.

 

What is Applsys Schema?

 Applsys schema contains all the tables required for administarative purpose. The default password is apps. All the technical products’ database objects are consolidated into a single schema called Applsys

 

What is Applsyspub schema?

 Applsyspub schema is responsible for password checking.The default password is pub.Applsyspub is used for authentication by having read only views.

 

Why should Apps & Applsys passwords always be the same?

The need to have the same password for Apps and Applsys is because when you sign on to apps, intially it connects to a public schema called APPLSYSPUB. This validates AOL username and password that we enter (operations/welcome using guest user account. Once this is verified we select responsibility, this is validated by APPLSYS schema and then it connects to APPS schema.

 

 

Find Application URL From Database and Context File in Oracle App R12.2

 

 Find Application URL From Database and Context File in Oracle App R12.2

solution 1:

SQL> select home_url from icx_parameters;

 

HOME_URL

--------------------------------------------------------------------------------

http://document.subnet.vcn.oraclevcn.com:8000/OA_HTML/AppsLogin

 

 

solution 2:

 

[applmgr@document appl]$ grep -i login $CONTEXT_FILE;

         

<login_page oa_var="s_login_page">http://document.subnet.vcn.oraclevcn.com:8000/OA_HTML/AppsLogin</login_page>

 


Monday, January 4, 2021

Change Weblogic admin password in Oracle EBS R12.2

 

Change Weblogic admin password in Oracle EBS R12.2

 

In Oracle E-Business suite R12.2 there many changes in Tech Stack components. Oracle 10.1.3 Application server is now replaced by Oracle Weblogic server. The default admin user name "weblogic" will be created during Installation and it will use the same password that has been configured during Installation.

As per the security policies and business requirement you may require to change the weblogic admin password. There are two supported options for changing the weblogic admin password. First if the you know the password and want to change for security reasons (or) If you lost/forgotten the weblogic amdin domain password.

In this demonstration i will show how to change the weblogic admin user password if the password is known.

 Login to weblogic to server console:


 Login using the current weblogic admin username and  password.



 Select the lock and edit button


Click on Domain link


                                            - Click on Security TAB

Click on "Advanced" TAB


 Provide the new password which you want to configure for weblogic admin user


                                        Click on "save"



 Verify settings updated successfully and then click on "Activate changes"



Verify all changes has been activated successfully.




- Now click on "Security Realms"



 Click on "myrealm"


 select "users and groups" and select weblogic User:


Provide same password as we have provided above for node manager.


Make sure the settings has been updated successfully.


After this we need to edit the configuration file "boot.properties" for all managed and admin server  using text editor and update the password field with the above configured password ( new password)

- take  backup of the following files:

$FMW_HOME/user_projects/domains/EBS_domain_/servers/AdminServer/security/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_/servers/forms-c4ws_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_/servers/forms_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_/servers/oacore_server1/data/nodemanager/boot.properties

$FMW_HOME/user_projects/domains/EBS_domain_/servers/oafm_server1/data/nodemanager/boot.properties


"$FMW_HOME/user_projects/domains/EBS_domain_" is the absolute PATH for your EBS weblogic domain.


PATH ="/u01/appl_document/appl/DOCUMENT/fs1/FMW_Home/user_projects/domains/EBS_domain_DOCUMENT/"



[applmgr@document nodemanager]$ cat boot.properties

#Tue Oct 22 05:16:35 AST 2013

TrustKeyStore=DemoTrust

password=oracle12345

username={AES}svCfxC1/zM76552t7otwoOMiQNApJavwuur0OfMqsrk\=

[applmgr@document nodemanager]$ cat orig.boot.properties

#Tue Oct 22 05:16:35 AST 2013

TrustKeyStore=DemoTrust

password={AES}kwT8uzUoZs78Mb9glRKksdfp+w+JKf5EogRPliLHLPE\=

username={AES}svCfxC1/zM76552t7otwoOMiQNApJavwuur0OfMqsrk\=

[applmgr@document nodemanager]$

 



Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...