Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Saturday, 19 March 2011

11gR2 dbua sqlplus -S /NOLOG

I encountered this error while running dbua from 11gr2 Home and could not proceed further :(

Error Message:

$ORACLE_HOME/bin/sqlplus -S /NOLOG




After lot of Investigation we found that the problem is setting the env. variables for 11gR2 ORACLE_HOME.

Solution:

Do not set any env variable related to both oracle homes 10g nor 11g and execute dbua manually from 11gR2 home path



cd /11gR2_Home/bin
./dbua




The env where dbua worked for me:




HOME=/export/home/oratest
HZ=
LANG=C
LOGNAME=oratest
MAIL=/var/mail/oratest
PATH=/usr/bin:
SHELL=/bin/sh



Hope this should solve the issue.

Thanks for reading :)

No comments: