Steps to drop your 10g database: bash$sqlplus “/ as sysdba” SQL*Plus: Release 10.2.0.3.0 – Production on Tue Jun 24 17:40:08 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production With the Partitioning, OLAP and Data Mining options SQL> shutdown immediate Database closed. Database [...]
Archive for the ‘Oracle’ Category
Oracle: When Windows XP’s Firewall blocks Oracle connection
November 15th, 2006
No Comments
When client try to make connection to the listener (default using port 1521), the listener spawn new user-process. This user process use random port to handle the client’s request. Mainly, oracle use two main program, which are ” oracle.exe” for oracle-instance, and “tnslsnr.exe” for listener. We can check it through “Task Manager” Windows firewall support [...]
Oracle: Rename the Oracle SID in Oracle 9i
November 14th, 2006
1 Comment
Some of my fellows ask me how to change the oracle SID. For those who never done these steps see that this is a difficult thing, but it’s quite simple though. 1. Login as sysdba [ora9i@training01 ~]$ sqlplus “/ as sysdba” SQL*Plus: Release 9.2.0.4.0 – Production on Mon Nov 13 16:23:56 2006 Copyright (c) 1982, [...]
