DBA

Oracle virtualbox installation error on linux

This topic may useful for who may face below errors while configure oracle virtual box on Linux.

Download VirtualBox for Redhat 5 64bit

Oracle VirtualBox Download

Install

[root@netbackuptest virtualbox]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID 98ab5139
error: Failed dependencies:
        libSDL-1.2.so.0()(64bit) is needed by VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64

I faced the above error while installing, you need to install SDL-1.2.10-8.el5.* rpm package for your machine.You can get it from your OS DVD.

[root@netbackuptest virtualbox]# rpm -Uvh SDL-1.2.10-8.el5.i386.rpm
warning: SDL-1.2.10-8.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
   1:SDL                    ########################################### [100%]
[root@netbackuptest virtualbox]# rpm -Uvh SDL-1.2.10-8.el5.x86_64.rpm
warning: SDL-1.2.10-8.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing...                ########################################### [100%]
   1:SDL                    ########################################### [100%]

Again I try to Install VirtualBox,

[root@netbackuptest virtualbox]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature:
Preparing...                ########################################### [100%]
   1:VirtualBox-4.1         ########################################### [100%]

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Uninstalling old VirtualBox DKMS kernel modules [  OK  ]
Trying to register the VirtualBox kernel modules using DKMS [FAILED]
  (Failed, trying without DKMS)
Recompiling VirtualBox kernel modules [FAILED]
  (Look at /var/log/vbox-install.log to find out what went wrong)

This time virtulbox was installed but i got a dkms error. this condition , you need to download
dkms-2.1.1.2-1.el5.rf.noarch.rpm package.
dkms-2.1.1.2-1.el5.rf.noarch.rpm

[root@netbackuptest virtualbox]# rpm -Uvh dkms-2.1.1.2-1.el5.rf.noarch.rpm
warning: dkms-2.1.1.2-1.el5.rf.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79                                                                     e6
error: Failed dependencies:
        kernel-devel is needed by dkms-2.1.1.2-1.el5.rf.noarch

Dependencies rpm package need. the above kernel-devel get it from OS DVD.

[root@netbackuptest virtualbox]# rpm -Uvh kernel-devel-2.6.18-238.el5.x86_64.rpm
warning: kernel-devel-2.6.18-238.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID                                                                      37017186
Preparing...                ########################################### [100%]
   1:kernel-devel           ########################################### [100%]
[root@netbackuptest virtualbox]# rpm -Uvh dkms-2.1.1.2-1.el5.rf.noarch.rpm
warning: dkms-2.1.1.2-1.el5.rf.noarch.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79                                                                     e6
Preparing...                ########################################### [100%]
   1:dkms                   ########################################### [100%]

Again I try to install Oracle Virtulbox

[root@netbackuptest virtualbox]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY,                                                                      key ID 98ab5139
Preparing...                ########################################### [100%]
        package VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64 is already installed
 

It show package already Installed, just remove this rpm package and install it again.
[root@netbackuptest virtualbox]# rpm -e VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64
[root@netbackuptest virtualbox]# rpm -Uvh VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm
warning: VirtualBox-4.1-4.1.4_74291_rhel5-1.x86_64.rpm: Header V4 DSA signature: NOKEY,                                                                      key ID 98ab5139
Preparing...                ########################################### [100%]
   1:VirtualBox-4.1         ########################################### [100%]

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Uninstalling old VirtualBox DKMS kernel modules [  OK  ]
Trying to register the VirtualBox kernel modules using DKMS [  OK  ]
Starting VirtualBox kernel modules [  OK  ]
[root@netbackuptest virtualbox]#

Now Everything was okay.
Go to –> Applications –> System Tools –> Oracle VM VirtualBox

ORA-01045: user TESTME lacks CREATE SESSION privilege; logon denied

I just review a answer from OTN forums.

I tested here

SQL> create role testme_role identified by test;

Role created.

SQL> grant create session to testme_role;

Grant succeeded.

SQL> create user testme identified by testme;

User created.

SQL> grant testme_role to testme;

Grant succeeded.

SQL> conn testme/testme;
ERROR:
ORA-01045: user TESTME lacks CREATE SESSION privilege; logon denied

Warning: You are no longer connected to ORACLE.

The issue is caused by the fact that the roles are not active in the user's session. 
Although the roles have been granted, they may not be default roles

SQL> select * from dba_role_privs where grantee='TESTME';

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
TESTME                         TESTME_ROLE                    NO  YES
SQL> SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='CONNECT';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
CONNECT                        CREATE SESSION                           NO

SQL> grant create session to testme;

Grant succeeded.

SQL> conn testme/testme;
Connected.
SQL> select * from session_roles;

no rows selected

SQL> create table abc(empno number);
create table abc(empno number)
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL> grant create table to testme_role;

Grant succeeded.

SQL> conn testme/testme
Connected.
SQL> set role testme_role;
set role testme_role
*
ERROR at line 1:
ORA-01979: missing or invalid password for role 'TESTME_ROLE'

SQL> set role testme_role identified by test;

Role set.

SQL> select * from session_roles;

ROLE
------------------------------
TESTME_ROLE

SQL> create table abc(empno number);

Table created.

SQL>

Hanging the process while installing Oracle Solaris 64bit on virtualbox

If you’re a beginner to install Oracle Solaris 64bit on Virtualbox, You may be get some hanging process while installing solaris at beginning stage like below

SunOS Release 5.10 Version Generic_14.... 64-bit

So They may be more confuse what I mistake, they may thought Everything I was selected Okay like

If you plan to install Solaris 64bit,  We must want to enable VT-x/AMD-v But It was default selected when you’re chooses subject page Solaris 64bit, then they may think what mistake, take a few more hours to analyze this one.

But Answer is simple .

You may select RAM memory size max 1GB RAM while configuration. But Oracle Solaris needs minimum 1536MB memory. then only you start the Oracle Solaris installation page…

csscan: error while loading shared libraries: libnnz10.so: cannot open shared object file

When i trying to execute csscan utility for Oracle 10g home ,I have faced the below errors

[oracle@netbackuptest ~]$ csscan
csscan: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory

I try to fix this error

[oracle@netbackuptest ~]$  ldd `which sysresv`
        linux-vdso.so.1 =>  (0x00007fff33d89000)
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1 (0x00002b026dc36000)
        libnnz11.so => /u01/app/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so (0x00002b0270260000)
        libdl.so.2 => /lib64/libdl.so.2 (0x0000003495000000)
        libm.so.6 => /lib64/libm.so.6 (0x0000003494c00000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003495400000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003498800000)
        libc.so.6 => /lib64/libc.so.6 (0x0000003494800000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00002b027063b000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003494400000)

Everything was okay.but I can see Oracle 11g home path was default on bash_profile environment. So in this case, I need to set oracle 10g home and library path.

[oracle@netbackuptest ~]$ export ORACLE_HOME=/u02/oracle/product/10.2.0/db_1
[oracle@netbackuptest ~]$ export PATH=$ORACLE_HOME/bin
[oracle@netbackuptest ~]$ LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
[oracle@netbackuptest ~]$ export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
[oracle@netbackuptest ~]$ csscan

Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Sat Oct 8 03:39:43 2011

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

Username

Now I can able to run csscan utility.