Virtual boxguest additions error - Modprobe vboxguest failed

If you see your guest additions are failing because of below error.

Error building the module:
modprobe vboxguest failed

OR
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.0.4 Guest Additions for Linux........
VirtualBox Guest Additions installer
Removing installed version 6.1.4 of VirtualBox Guest Additions...
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules.  This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Kernel headers not found for target kernel
4.1.12-124.24.3.el6uek.x86_64. Please install them and execute
  /sbin/rcvboxadd setup
modprobe vboxguest failed
The log file /var/log/vboxadd-setup.log may contain further informa

SOLUTION:  well in my case below solution worked for oracle vm 6.1

     yum install kernel-uek-devel

## Fedora 34/33/32/31/30 and CentOS 8 / RHEL 8 ##
dnf update kernel*

## CentOS/RHEL 7/6/5 ##
yum update kernel*

uname -r 
ls -ltr /usr/src/kernels/
yum install kernel-uek-devel-$(uname -r)
reboot

Virual Box group - Vboxsf permission issue on /media/sf_directory_name..

The Ideal way of getting access to these files is to allow VirtualBox to automount the shared folder (which will show up under /media/sf_directory_name) and then to add your regular OS user to the vboxsf group (as root #).

Syntax:

# usermod -aG vboxsf <OSUser>

In My case:     

[root@ol6 oracle]# usermod -aG vboxsf oracle

  By default, it looks it look like this

drwxrwx--- 1 root vboxsf 40960 MAY 11:37 sf_directory

so the vboxsf group has full access. By adding your user to that group,

you gain full access. So you no need to worry about changing their permissions

 

Oracle VM Server  Goes To Black Screen After Logging in 

After installing oracle linux6, i was able to play for some time and then i tried installing guest additions which is failing pathetically when i rebooted it starting giving a blank page.

I tried below things,

1. Increasing RAM

2. Increasing Video Memory

3. Disabling 3D Acceleration , NA/PEX

Trust me nothing worked out for me ...Wasted 24 hours on this nasty bug

Solution:

Switch  VMSVGA to VboxSVGA (which is no longer supported!) corrects the problem.

How to use internet from Oracle Virtual Machine 

 Hello again !  Well after a lot many days am trying to play with VM's again like installing a new VM, setting up internet , install databases and learn new things on the way.

So, i could not able to access internet inside my VM and the OS is Oracle Linux Server release 6.4

SOLUTION:

Here is the little trick , go to your host machine and check network connections 

Control Panel\Network and Internet\Network Connections

here you gonna see the type of the wifi your using , use the same adapter name in Oracle VM under 

network tab and choose Promiscuous  mode Allow for all VM's

Do the same thing for Adapter 2 as well and allow mode for all VM's

Now go to ur VM and see.. TADA !! try ping google.com too and u can see its connecting to internet

Happy learning !!

 

 

How to find sysadmin password in oracle apps r12?

How to find sysadmin password in oracle apps r12?

1)conect to database as apps schema
2)create package and package body.
3)fire select statement you will get sysadmin passwod.
************************select statement t********
SELECT Usr.User_Name,
       Usr.Description,
       XXARTO_GET_PWD.Decrypt (
          (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
                             Fnd_Web_Sec.Get_Guest_Username_Pwd,
                             Usertable.Encrypted_Foundation_Password)
                     FROM DUAL)
                     AS Apps_Password
             FROM applsys.Fnd_User Usertable
            WHERE Usertable.User_Name =
                     (SELECT SUBSTR (
                                Fnd_Web_Sec.Get_Guest_Username_Pwd,
                                1,
                                INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
                                       '/')
                                - 1)
                        FROM DUAL)),
          Usr.Encrypted_User_Password)
          Password
  FROM applsys.Fnd_User Usr
 WHERE Usr.User_Name = '&User_Name';

****************************************************

oradev@ctsst $ sqlplus apps/deal123

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 20 04:47:24 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> CREATE OR REPLACE PACKAGE XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXARTO_GET_PWD; 2 3 4
5 /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY XXARTO_GET_PWD AS
2 FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
3 RETURN VARCHAR2 AS
4 LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
5 (java.lang.String,java.lang.String) return java.lang.String';
6 END XXARTO_GET_PWD;
7 /

Package body created.

SQL> SELECT Usr.User_Name,
2 Usr.Description,
3 XXARTO_GET_PWD.Decrypt (
4 (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
5 Fnd_Web_Sec.Get_Guest_Username_Pwd,
6 Usertable.Encrypted_Foundation_Password)
7 FROM DUAL)
8 AS Apps_Password
9 FROM applsys.Fnd_User Usertable
10 WHERE Usertable.User_Name =
11 (SELECT SUBSTR (
12 Fnd_Web_Sec.Get_Guest_Username_Pwd,
13 1,
14 INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
15 '/')
16 - 1)
17 FROM DUAL)),
18 Usr.Encrypted_User_Password)
19 Password
20 FROM applsys.Fnd_User Usr
21 WHERE Usr.User_Name = '&User_Name';
Enter value for user_name: SYSADMIN
old 21: WHERE Usr.User_Name = '&User_Name'
new 21: WHERE Usr.User_Name = 'SYSADMIN'

USER_NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
System Administrator
welcome123

Thanks for visiting my blog .Happy learning !!!!!!!!!

How to Decrypt APPS Password in 11i/R12

STEP 1 : Login instance with sqlplus:

SQL>  CREATE FUNCTION apps.decrypt_pin_func(in_chr_key IN  VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)

 RETURN VARCHAR2

 AS LANGUAGE JAVA NAME                           'oracle.apps.fnd.security.WebSessionManagerProc.decrypt (java.lang.String,java.lang.String) return java.lang.String';

 Function created.

SQL>  SELECT ENCRYPTED_FOUNDATION_PASSWORD from APPS.fnd_user where  USER_NAME='GUEST';

 ENCRYPTED_FOUNDATION_PASSWORD

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

ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312 ->place it in below query

STEP 2 : To Get the Apps Password 

SQL>  SELECT APPS.decrypt_pin_func ('GUEST/ORACLE','ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312') from  dual;

 APPS.DECRYPT_PIN_FUNC ('GUEST/ORACLE','ZHBBD9066F53BC9E88B94FA8CB63E4B78E084C83D24F3A312'

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

 APPSPASS  (this is your apps user password)

[UNEXPECTED]Data dictionary corruption - timestamp mismatch

Issue: 

Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/adop.log
===========================================================================

Validating configuration on node: [appsserver1].
    Log: /obin/oracle/EBSCNV2E/fs_ne/EBSapps/log/adop/55/20200719_042953/prepare/validate/appsserver
        [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.

Verifying data dictionary.
    [UNEXPECTED]Data dictionary corrupted:
    [UNEXPECTED]Data dictionary corruption - timestamp mismatch
    APPS            RCV_LCM_WEB_SERVICE            V_20190112_0223 APPS            INL_INTEGRATION_GRP            V_20190112_0223 TS mismatch: 18-MAR-19 03:10:47 07-JUL-20 23:09:30
    APPS            INV_RULE_GEN_PVT               V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            GMI_MO_PURGE                   V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            GMI_PICK_RELEASE_PUB           V_20191026_0338 APPS            GMI_RESERVATION_UTIL           V_20191026_0338 TS mismatch: 26-OCT-19 06:18:01 07-JUL-20 23:11:40
    APPS            PA_PURGE_COSTING               V_20190112_0223 APPS            PAAPIMP_PKG                    V_201


SOLUTION:

SQL> !vi $AD_TOP/patch/115/sql/adzddtsfix.sql

SQL> @$AD_TOP/patch/115/sql/adzddtsfix.sql
exec dbms_utility.invalidate(5666082,NULL,0);
exec dbms_utility.invalidate(6541212,NULL,0);

SQL> !vi adzddtsfixout.sql

SQL> @adzddtsfixout.sql

PL/SQL procedure successfully completed.

SQL> @$ORACLE_HOME/rdbms/admin/utlrp

TIMESTAMP

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

COMP_TIMESTAMP UTLRP_BGN  2020-07-19 04:43:19

and Re-check  the issue, it will be done :)  Enjoy