The scripts may be downloaded and used for free.
Warning:
Some of these scripts may be dangerous and can potentially damage or destroy your database or system. Make sure you understand, customize and test all scripts to suite your needs and environment before using them!
|
SQL> SELECT distinct url, email
FROM hr.all_companies
WHERE expertise = 'Oracle'
AND job in ('APPS_DBA', 'DBA', 'CONSULTANT')
AND knowledge = 'Excellent'
AND experience = 'Excellent'
AND commitment = (select MAX(commitment) from hr.all_companies);
URL EMAIL
------------------- --------------------------
ict-oke.com
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
..................We are preparing more usefull DBA/APPS_DBA scripts at this moment.
APPS DBA Scripts:
Release 12
Oracle enterprise linux 4:
| EL_4_EBS.sh |
Shell script; sh EL_4_EBS.sh
Pupose:checks the prerequisites for APPS 12
I have created this script during the installaiton of APPS R12 on Oracle Unbreakable Linux.
You can use this script for a final check, to see if all preparations went well.
NOTE:Check this script first, and customize if necessary
|
DBA Scripts/Views:
| Prepare_database.sh |
Shell script; execute sh prepare_database.sh
Purpose:This script can be used for the creation of the Oracle user and group, the creation of a directory tree(following the OFA stabdards), and for updating the kernel parameters.
NOTE:Check this script first, and customize if necessary
|
| create_users_script.sql |
SQL script; runs as sys user from sqlplus SQL>@create_users_script.sh
Purpose:Creates a script which can be used for re creation of the users in a database.
NOTE:Check this script first, and customize if necessary
|
Most used ROLE Views:
--DBA_ROLES Names all the roles created on the database and wether a password is required to use each role
select * from dba_roles;
--DBA_ROLE_PRIVS Names all users and the roles granted to them in the database
select * from dba_role_privs
order by GRANTEE;
--ROLE_ROLE_PRIVS Identifies all the roles and the roles that are granted to them in the database
select * from role_role_privs
order by ROLE;
--DBA_SYS_PRIVS Identifies all the roles and the user grantees and the granted system priveleges to those roles and users
select * from dba_sys_privs
order by GRANTEE;
--ROLE_SYS_PRIVS Identifies all the system priveleges granted only to roles in Oracle
select * from role_sys_privs
order by ROLE;
--ROLE_TAB_PRIVS Identifies all the object priveleges granted only to roles in Oracle
select * from role_tab_privs
order by TABLE_NAME;
--SESSION_ROLES Identifies all the roles available in the current session of Oracle
select * from session_roles;
Most used Datadictionary Views:
[USER|ALL|DBA]_OBJECTS, [USER|ALL|DBA]_TABLES, [USER|ALL|DBA]_INDEXES, [USER|ALL|DBA]_VIEWS, [USER|ALL|DBA]_SEQUENCES
[USER|ALL|DBA]_USERS, [USER|ALL|DBA]_CONSTRAINTS, [USER|ALL|DBA]_CONS_COLUMNS, [USER|ALL|DBA]_IND_COLUMNS[USER|ALL|DBA]_TAB_COLUMNS, [USER|ALL|DBA]_ROLES, [USER|ALL|DBA]_TAB_PRIVS, [USER|ALL|DBA]_SYS_PRIVS
[USER|ALL|DBA]_SOURCE, [USER|ALL|DBA]_TRIGGERS, ROLE_TAB_PRIVS, ROLE_SYS_PRIVS, ROLE_ROLE_PRIVS, DBA_TABLESPACES, DBA_TS_QUOTAS, DBA_DATAFILES, DBA_SEGMENTS, DBA_EXTENDS, DBA_FREE_SPACE, DBA_PROFILES
Various other usefull Views:
V$FIXED_TABLE, V$SGA, V$PARAMETER, V$OPTION, V$SYSTEM_PARAMETER, V$PROCESS, V$SESSION, V$SESSTAT, V$VERSION, V$INSTANCE, V$THREAD, V$CONTROLFILE, V$DATABASE, V$DATAFILE, V$DATAFILE_HEADER, V$LOG and V$LOGFILE
(Under construction)
OS Scripts:
(Under Construction)
