I get an end of file on communication channel on database startup because the db_recovery_file_dest_size limit is reached as show in the alert log: Errors in file /u01/app/diag/rdbms/<ORACLE_SID>/<ORACLE_SID>/trace/<ORACLE_SID>_ora_2283.trc: ORA-16038: log 2 sequence# 122 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1: ‘/u01/app/oradata/<ORACLE_SID>/redo02a.log’ ORA-00312: online log 2 thread 1: …
Monthly Archives: May 2010
Service Names, Oracle and AWS
This is the listener (private DNS for ec2): LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = domU-nn-nn-nn-nn-nn-nn)(PORT = 1521)) ) ADR_BASE_LISTENER = /u01/app This is the tnsnames.ora file: <ORACLE_SID> = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <ec2 dns name outside firewall>)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) …
AWS, OEM and Reconfiguring emca
The .bash_profile These variables are important: ORACLE_SID=<ORACLE_SID> ORACLE_UNQNAME=<ORACLE_SID> export ORACLE_HOSTNAME=ec2-nnn-nn-nn-nnn.compute-1.amazonaws.com When having changed the bash profile, reinstantiate the profile: . .bash_profile The Listener and TNS Files This is the listener.ora file: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = domU-nn-nn-nn-nn-nn-nn)(PORT = 1521)) ) ) …
AWS Image and Oracle /etc/init.d Restart Files
This issue could be as a result of non-Oracle DBA changes, tampering or just the image for the AWS Linux+Oracle installation was set up in the wrong way. For Oracle auto startup and shutdown on Linux restart find the common file called /etc/init.d/dbora, which is linked to shutdown script /etc/rc0.d/K01dbora and startup script /etc/rc2.d/S99dbora. Remove …
Continue reading “AWS Image and Oracle /etc/init.d Restart Files”
Temporal Trace File Deletion
First if you don’t have any files with dates that you can delete automatically then change some of them, given that you’re not yet mucking with a production server, where below changes the date on the file to May 22nd, 2010: touch -t 201005220000.00 <filename> And now delete files 3 or more days old with …
AWS Oracle Database Default .bash_profile
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH ## Oracle Setup ## umask 022 ORACLE_BASE=/u01/app ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 ORACLE_SID=<ORACLE_SID> ORACLE_UNQNAME=<ORACLE_SID> JAVA_HOME=${ORACLE_HOME}/jdk export ORACLE_BASE ORACLE_HOME PS1 PATH EDITOR ORACLE_SID ORACLE_UNQNAME export ORACLE_HOSTNAME=ec2-nnn-nnn-nnn-nnn.compute-1.amazonaws.com #this is too busy … PS1=”`whoami`@`uname -n`:[$PWD]`echo …
Continue reading “AWS Oracle Database Default .bash_profile”
Oracle Directories to Watch for Space Usage
Trace files in 11g are called: /u01/app/diag/rdbms/<ORACLE_SID>/<ORACLE_SID>/trace/*.tr? You want to look for tr? (trc and trm) files because the alert log is in the same directory and you don’t really want to delete the alert log unless it uses up too much space, which is unlikely – even when it gets very big. Check the …
Continue reading “Oracle Directories to Watch for Space Usage”
Some Interview Questions to Check Oracle RAC Exposure
A single instance has a view called V$SESSION. Would you use V$SESSION in Oracle RAC? Yes you can but you’re looking for the person you’re interviewing to answer GV$SESSION then you know they have used Oracle RAC multiple instance performance views. In an Oracle RAC environment with heavy insert activity (common on an OLTP environment), …
Continue reading “Some Interview Questions to Check Oracle RAC Exposure”
Amazon Cloud and port 1521
It is blocked by default. It has to be unblocked in the AWS firewall – use ElasticFox or the API to unblock port 1521. Also set the IP address to the source IP address, which is the IP address of the server or website you are currently visiting, or using – in other words your …
Generate pfile on AWS
Create the pfile connected as SYS (assume everything’s in the dbs directory because a recommend AWS EC2 server it is recommended that all storage – including parameter file – all go into Amazon Elastic Block Storage or EBS): create pfile=’$ORACLE_HOME/dbs/pfile<ORACLE_SID>.ora’ from spfile=’$ORACLE_HOME/dbs/spfile<ORACLE_SID>.ora’; pfile traditionally called init.ora This is what’s in the default parameter file for …