Posts Tagged ‘Oracle’

Oracle: When Windows XP’s Firewall blocks Oracle connection

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

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, [...]

Subscribe to RSS Feed Follow me on Twitter!