Scripts For DBA

RMAN FILE LOCATION---------------------------------------------------------
show parameter recover;

database version---------------------------------------------------------
    select * from v$version;

tablespace names-----------------------------------------------------------
    select * from dba_tablespace

account unlock-----------------------------------------------------------------------------
    alter user user_name account unlock;
    alter user apps account unlock;

apache restart-------------------------------------------------------------------------------
    cd /usr/local/apache-tomcat/bin/
    ./startup.sh

NLS parameters

SELECT * FROM nls_session_parameters;
Instance parameters (change with ALTER SYSTEM):
SELECT * FROM nls_instance_parameters;
Database parameters (set during database creation):
SELECT * FROM nls_database_parameters;

check patch version 
adident Header (name of patch)

 Permission

chmod
chmod -R 777 /u02

user add
useradd -g dba oraprod

groupadd dba

chown
chown -R applprod.dba /u03/oracle...

Adding up datafile

select * from v$tablespace;
select * from v$datafile;
add datafile
alter tablespace tablespace_name add datafile '/u01/oracle/oradata/prodtest1/system02.dbf' size 50G;

add log file to existing group
sql> ALTER DATABASE ADD LOGFILE MEMBER '/u02/oradata/mydb/redo02.log' TO GROUP 2;

add log file to the new group
alter database add logfile group 5 ('/u01/oracle/oradata/prod/redologt1.dbf','/u01/oracle/oradata/prod/logt2.dbf') size 50m;

 control file creation
"CREATE CONTROLFILE
 SET DATABASE prod
   LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log',"


archive log find old files

find . -mtime +5  -exec rm -f {} \; -print         - delete 

find . -mtime +5  {} \; -print
find /u02/oracle/archive/ -mtime +5;