Invalid Objects !!! Its Impacts

Sometimes the packages become invalid. Have you observed what happens to it and what happens to the procedures or programs accessing these packages?

We will try to find it in this session -

Advanced Topics!!!

Coming Soon!!!!
In
bignfatdba.blogspot.com

Checkout this blog for advanced Topics.

Resource Role is a must for Apps

If we revoke resource role then while patching it will throw errors.

Example:

CREATE OR REPLACE PUBLIC SYNONYM qp_list_headers_all_b FOR QP.qp_list_headers_b
AD Worker error: The following ORACLE error:
ORA-01031: insufficient privileges

Unix - Oracle Common DBA Handy Commands for General Admin Workz

Find out Which Server you are In:
oracle@myServer::/offline [BNFD] $ uname -aHP-UX myServer B.11.00 A 9000/800 1126424671 two-user license
du - estimate file space usage
Displays the free disk space in the / filesystem.df -kvi
1. to ckeck system activity History on UNIX :/var/adm/syslog/syslog.log
2. Ask Sysadmin to get the pwefview statistical analysis for that data
unix Find/Replace
:1,$ s/sun/mars/g
:1,$ s/mars/sun/g
sed 's/sun/mars/g' pasand.ctl > mars.ctl
sed 's/mars/sun/g' mars_ora_3770.trc > sun.ctl
The SCP command for different server copy :
scp *.dbf oracle@bnfd.usa.com:/stage/oracle/mars/
be at the source and then go to the sourec directory:
scp filename with path username@destination servername:path of the dir and file
Example:
scp us_exp_140705.dmp oracle@bnfd.usa.com:/stage/oracle/mars/
Find and Remove :
Find file which are more tha 30 days old and remove them from udump:
find . -atime +30 -name '*' -exec rm -f {} \;
find /d1/app/oracle/orasrv/admin/BNFD/arch -atime +3 -name '*' -exec rm -f {} \;
Common Vi Editor Commands:
ctrl + d = 1 page down
ctrl + u= 1 page up
to delete above (all)
1+d+shift+g
to delete everything below the cursor:
d+shift+g

The SCP command for different server copy :
scp *.dbf oracle@bnfd.usa.com:/q764/data01/
be at the source and then go to the sourec directory:
scp filename with path username@destination servername:pathe of the dir and file
Unix command :
gzip -d arch135.arc.gz - - for unziping the files
spool c:\d760.csv -- to spool to the excel file

General DBA Responsibilities!!!

Q: What was your responsibility in the previous company?
Ans: I was responsible for managing the space -- i. e Monitoring the growth of the datafiles and resolve space related issues.
-> Troubleshooting the issues related to backup failures.
-> creating policies for taking backups.
-> Recovering database in situations and preparing standby servers.
-> Taking Logical and physical backups adhering strictly to the policies.
-> creating database on demand.
-> Allocate and manage system privilege.
-> Plan and implement backup policies & strategies.
-> Minimize datbase down time and in situations contact Oracle corp. for technical support.
DBA Responsibilities:
User Management:
Oracle Account Management Policy contains the following parts:
• Account Locking • Password Aging and Expiration • Password History • Password Complexity Verification