Oracle DBA Tips and Techniques

By Arjun Raja

Archive for February, 2011

INS-07003 Unexpected error occured while accessing the bean store

Posted by Arjun Raja on February 27, 2011

Installation of 11g rel2 ( 11.2.0.2) on AIX throws the following error – [ INS-07003] Unexpected error occured while accessing the bean store- this is the fix to avoid this error.

./runInstaller …

(Embedded image moved to file: pic32494.gif)

You can continue and the installation does go through but to avoid this warning, this is the workaround -.

First of all make a copy of the unix login users .profile.

cp .profile .profile.bkup

Then edit the .profile.

The $PS1 variable and other variables like the ones below must be hashed out before commencing the installation ….

# Command Prompt Setup
#Red=”33[31m” # PROD/PROD DR
#Yellow=”33[33m” # OAT/OAT DR
#Blue=”33[34m” # UAT
#Cyan=”33[36m” # TRN
#Green=”33[32m” # DEV/SIT/TEST
#NC=”33[0m” # No Colour
#BoldON=”33[1m”
#BoldOFF=”33[22m”
# Change two colour variables below to match LPAR env
#MESSAGE=`echo “$Green$BoldON”`
#NOMESSAGE=`echo “$Green$BoldOFF$NC”`
#export MESSAGE NOMESSAGE
#export PS1=”$MESSAGE${ORACLE_SID}$NOMESSAGE:$PWD> ”

Save the .profile and open a new session –

echo $PS1 – you must receive a blank response.

Now start the installer again

./runInstaller …….next screen appears without any warnings…

(Embedded image moved to file: pic07596.gif)

Once complete, restore the original .profile so that future sessions are back to normal.

mv .profile.bkup .profile

Posted in Oracle 11g | Tagged: , | Leave a Comment »

REMOTE_OS_AUTHENT PARAMETER DEPRECATED IN 11G

Posted by Arjun Raja on February 10, 2011

If you have a situation where connections to a newly upgraded 11g database are from a remote box as an OPS$ account….follow this.

Connections will fail with the following error.

ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied.

Reason –

Once an upgrade to 11g is complete, the REMOTE_OS_AUTHENT is set to false by default to stop remote connections to the database.

show parameter os

os_authent_prefix string ops$
os_roles boolean FALSE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE

For remote connections to work, remote_os_authent must be= TRUE.

To achieve this , a database bounce is essential, so incorporate this step as part of the upgrade steps to avoid outage at a later time.

alter system set remote_os_authent=true scope=spfile;

Now bounce the database.

When the database restarts, the foll warning message ( ORA-32004) will appear – ignore it – the database starts without further issues…

SQL>startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance – expected – can be ignored.
ORACLE instance started.

Total System Global Area 977076224 bytes
Fixed Size 2212744 bytes
Variable Size 729812088 bytes
Database Buffers 239075328 bytes
Redo Buffers 5976064 bytes
Database mounted.
Database opened.

show paramter os

os_authent_prefix string ops$ os_roles boolean FALSE
remote_os_authent boolean TRUE
remote_os_roles boolean FALSE

Now connections from remote boxes as OPS$ logins will succeed.

Posted in Uncategorized | Leave a Comment »

APARS REQUIRED FOR 11G REL 2 INSTALLATION ON AIX 5.3

Posted by Arjun Raja on February 9, 2011

Following oslevel patches need to be installed on AIX 5.3 before 11g rel2 can be installed.

check –

/usr/sbin/instfix -i -k ” IZ49516 IZ52331″

IGNORE ALL and continue if these packages are not installed.

Posted in Uncategorized | Leave a Comment »