Vpire Blog

By default the listener comes with no password, and anyone can change listener settings through the lsnrctl tool. In Oracle 9i, any computer on your network can stop your listener in the blink of an eye if you do not password protect it. Bookmark It Hide Sites $$(‘div.d823′).each( function(e) { e.visualEffect(‘slide_up’,{duration:0.5}) });

Bookmark It

Hide Sites

To delete a database, you can use the dbca which is more easy. First you just launch the dbca and then choose Delete a Database then choose the database you want to delete. After that you still have some cleanup to do. remove directory $ORACLE_BASE/admin/$ORACLE_SID delete archivelog directory if you have the archivelog turn on [...]

Bookmark It

Hide Sites

If you have turn on archivelogging and you didn’t set where is the destination to store your archivelog, by default it will store in your $recovery_file_dest. You can use the following command to check your flash recovery size and what is the current usage: SQL> SELECT * FROM v$recovery_file_dest; If the recovery log is full, [...]

Bookmark It

Hide Sites

If you had wrongfully setup the destination of your oracle archivelog or disk full and you decided to change the destination or your archivelog, you can use the following command: SQL> ALTER system SET log_archive_dest_1=’location=/tmp’ ;   System altered.   SQL> ALTER system switch logfile;   System altered. After that if you decided that the [...]

Bookmark It

Hide Sites