Page Comparison

...

ALTER USER oe IDENTIFIED BY oe; 
ALTER USER oe ACCOUNT UNLOCK;
GRANT ALTER SESSION,      
CONNECT,     
CREATE MATERIALIZED VIEW,     
CREATE VIEW,     
QUERY REWRITE,     
RESOURCE TO oe;     
GRANT EXECUTE ON DBMS_LOCK TO oe;     
ALTER USER OE QUOTA UNLIMITED ON USERS;

c. Logout of the database.

SQL> exit

3. Setup the correct TNS alias. Edit /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/tnsnames.ora

...

5. Ensure the archive log files are managed and not filling up and stopping the database. Install a script that manages the archive logs

a. Logon as root and cd

su - 

 change directory to /usr/local/bin

su - 
cd /usr/local/bin

b. Download an archive management script from the dbvisit.com website named del_arch.sh

...

[root@source bin]# chmod 750 del_arch.sh 

[root@source bin]# chown oracle:dba del_arch.sh 

[root@source bin]# exit

d. As user oracle, add it to the oracle crontab. Run it every 15 minutes and delete all archives older than 4.8 hours (0.2 days)

su - oracle

crontab -e

e. Add the following line to crontab and then save and exit (:wq) This runs the script every 15 minutes and deletes all archives older than 4.8 hours (0.2 days). 

*/15 * * * * /usr/local/bin/del_arch.sh orcl 0.2 > /tmp/del_arch.txt 2>&1

...