This blog is about error "insufficient Privileges" while connecting as sys as sysdba
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
When logging into the new ORACLE_HOME (to be upgraded)
I received this error. (ORA-01031)
OS: HP-UX 11.11 64 bit
OS_GROUP other than DBA My groups is USERS
Reason: in rdbms/lib config.c is hard-coded the group as "dba"
Solution:
1. Navigate to new ORACLE_HOME/rdbms/lib
2. Look for config.c
3. Backup config.o as config.o_bk
4. Backup config.c as config.c_bk
5. Open config.c
Change the lines as
Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
#define SS_DBA_GRP "dba"
#define SS_OPER_GRP "dba"
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};
Changed Section
Previous entry
/* SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access. */
/* Refer to the Installation and User's Guide for further information. */
#define SS_DBA_GRP "users"
#define SS_OPER_GRP "users"
char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP};
6. run
make -f ins_rdbms.mk config.0 ioracle
once finished,
try to login as sysdba
it should work.
Cheers!!!!
Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.
You are encouraged to leave a comment.
You are encouraged to leave a comment.
Thursday, August 19, 2010
Issue with Oracle DB Upgrade 9.2.0.5 to 10.2.0.4 (Apps DB)
Subscribe to:
Post Comments (Atom)
Let us be Friends...
Popular Posts
-
1. Installation of the Demantra Base Application or Patches Create a C:/Tmp folder on the machine where the setup.exe will be executed pri...
-
The Following Error was detected while doing Cloning of DB Tier. The actual Fact was: The server was heavily loaded, so the control file cre...
-
Secure Sockets Layer (SSL) SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data inte...
-
In this Blog, I am going to explain you the way you can get the Translation Synchronization Patch for the Language you license thro OAM. T...
-
This blog describes the process of re-creating an existing Applications Release 12 database instance using the export and import utilities....
-
This blog speaks about the Login Page Issue on R12.1.1 instance. Suddenly the login page was throwing an error - 404 /OA_HTML/AppsLogin was ...
-
Primary Node: Host name: genius.chainsys.com IP : 192.168.2.236 File locations: apps - /oracle/D1/apps (SHARED) db - /oracle/PROD/db inst - ...
-
Hi, everybody should come across, while during a clone, you might have experienced very poor performance while running txkWfClone.sh profil...
-
Happy and Prosperous New Year 2010!!! Today I need to discuss an issue while planning to upgrade my 12.1.1 instance to 12.1.2 using the patc...
-
The Oracle Universal Installer supports the installation of several active Oracle homes on the same host. An Oracle home is a directory into...
No comments:
Post a Comment