Monthly Archives: January 2014

Create New Application user from existing user in EBS R12

We can create new application user from existing user with same responsibility, Which can be achieved from FNDLOAD utility.

Here I would like to create new user with name ‘APPADMIN’ (Target user) from existing user SYSADMIN (Source user).
SOURCE USER : SYSADMIN
TARGET USER : APPADMIN

To find the responsibilities of source user:
set pages 1200
set lines 200
SELECT frt.RESPONSIBILITY_NAME, furg.end_date
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,fnd_responsibility_tl frt,fnd_user fu
WHERE fu.user_name = ‘&&username’
AND   fu.user_id = furg.user_id
AND   furg.responsibility_id = fr.RESPONSIBILITY_ID
AND   frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1;
 

STEP 1: Use FNDLOAD to download user SYSADMIN from your instance:

FNDLOAD apps/<apps password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct  SYSADMIN_USER.ldt FND_USER USER_NAME=SYSADMIN

STEP 2: Modify the ldt file (SYSADMIN_USER.ldt for the example above):

Change the line <BEGIN FND_USER “SYSADMIN”> to <BEGIN FND_USER “APPADMIN”>

 
BEGIN FND_USER “APPADMIN”
OWNER = “APPSMGR”
LAST_UPDATE_DATE = “2014/01/06”
START_DATE = “1951/01/01”

STEP 3: Use FNDLOAD to upload new user to your instance:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct  SYSADMIN_USER.ldt  FND_USER   USER_NAME=APPADMIN

STEP 4: Change the password of the new user from application and communicate.

 
Thank You !!

ORA-01031: insufficient privileges when connect as sysdba

Not able to connect Oracle database, When issue command — > sqlplus “/ as sysdba”

[oraprod@oracle-dba ~]$ sqlplus “/ as sysdba”
SQL*Plus: Release 10.2.0.1.0 Production on Wed Jan 22 02:09:17 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
ERROR:
ORA-01031: insufficient privileges

SOLUTION:

SET CORRECT ORACLE SID
———————-
export ORACLE_SID=PROD         — LINUX
D:\oracle>set ORACLE_SID=PROD  — WINDOWS

SET ORACLE_HOME
—————
export ORACLE_HOME=/u01/oracle/product/10.2.0   — LINUX
set ORACLE_HOME=D:\oracle                                           — WINDOWS

SET SQLNET.ORA FILE
——————-
Check sqlnet.ora file for SQLNET.AUTHENTICATION_SERVICES parameter. It should be set to NTS for windows and for linux set it to ALL.

SQLNET.AUTHENTICATION_SERVICES=NTS  —WINDOWS
SQLNET.AUTHENTICATION_SERVICES=ALL  —LINUX

Please reproduce the issue and see if it resolves !!

ORA-27125: unable to create shared memory segment when run DBCA

I have installed 10gR2 on linux environment, When running DBCA it got filed with below error

ORA-27125: unable to create shared memory segment

SOLUTION:

cd $ORACLE_HOME/bin
 
mv oracle oracle.bin
 
 
—- Paste it as one —
 
cat >oracle <<“EOF”
#!/bin/bash
export DISABLE_HUGETLBFS=1
exec $ORACLE_HOME/bin/oracle.bin $@
EOF
 
—- End of paste —

chmod +x oracle

Thank You !!