Thinking Out Loud

September 19, 2007

drop database

Filed under: oracle — mdinh @ 9:40 pm

Note: I had to modify the screen shot to remove domain name of the company.

The drop database command can be useful in a testing environment for cleaning up data files, controlfiles, and log files.

d1.jpg

Note: database must be mounted EXCLUSIVE and not open for this operation.

d2.jpg

One disappointment is that it did not delete the directory beneath DIAGNOSTIC_DEST.

Here are all the directories still left behind.

d3.jpg

This is what I executed to remove the remaining directories in my environment.

find /ora* -user oracle -type d -name PRIME -exec rm -rfv {} \;

ALWAYS be careful when using rm -rf command.

Advertisements

September 12, 2007

Oracle 11gR1 Listener Log Location

Filed under: oracle — mdinh @ 10:42 pm

I am just getting my feet wet with 11gR1.

When I executed lsnrctl status, I get the following:

<click image to enlarge>

l1

The Listener Log File is in XML format.

Where’s the regular listener.log file?

It is located one directory above under trace.

<click image to enlarge>

l2.jpg

This all relates to the new parameter DIAGNOSTIC_DEST in 11g.

REFERENCE:

Oracle® Database Reference 11g Release 1 (11.1)

September 6, 2007

Oracle 11gR1 install on CentOS 5 Notes

Filed under: CentOS,linux,oracle,RedHat — mdinh @ 4:42 pm

Note:438765.1

Requirements for Installing Oracle 11gR1 32bit RDBMS on RHEL 5 & OEL 5

Surprisingly straight forward using the above notes.

useradd -u 503 oracle

passwd oracle

groupadd -g 521 dba

groupadd -g 522 oinstall

usermod -g oinstall -G dba oracle

rpm -qa compat-libstdc++-33 \
elfutils-libelf-devel \
glibc-devel \
gcc \
gcc-c++ \
libaio-devel \
libstdc++-devel \
sysstat \
unixODBC \
unixODBC-devel |sort

rpm -qa binutils \
elfutils-libelf \
glibc \
glibc-common \
libaio \
libgcc \
libstdc++ \
make |sort

1.jpg

2.jpg

3.jpg

4.jpg

5.jpg

6.jpg

7.jpg

8.jpg

9.jpg

10.jpg

11.jpg

Blog at WordPress.com.