Archive for June, 2008
How to make changes to spfile / pfile or generate spfile / pfile on a RAC database
Not all init.ora parameters can be changed using ‘alter system set’ commands. For example audit_syslog_level parameter
SQL> alter system set audit_syslog_level=local0.warning scope=both;
alter system set audit_syslog_level=local0.warning scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
In this scenario you need [...]
afpub.sql
Never ever run this script when the instance is up and running. Wondering what will happen if you run … pretty simple … nobody can login to the instance including SYSADMIN user even with the correct password.
Oracle Ebusiness Suite security best practices document suggests to run this script to grant and revoke permissions to/from applsys [...]
Script to list profile option values for a specific user
col profile_option_name for a35
col profile_option_value for a30
col profile_option_id for 9999
set lines 500
select
p.profile_option_name,
substr(decode(v.level_id,10001,’Site’,10002,’Application’,
10003,’Repsonsibiltiy’,10004,’User’,10005,’Server’,10006,’Organisation’),1,15) profile_level,
substr(fu.user_name,1,12) user_name,
v.level_value,
v.profile_option_value
from
fnd_profile_options p,
fnd_profile_option_values v,
fnd_user fu
where
p.profile_option_id = v.profile_option_id
and v.level_value = fu.user_id
and fu.user_name like upper(‘&USER_NAME’)
/
