Monday, February 1, 2010

isqlplus port number

How can I know Which port to use to start isqlplus from browser.
Solution. Use following file path to get port number of isqlplus(in oracle 10g).

$ORACLE_HOME/install/portlist.ini
Then use following url to start isqlplus

http://host:port/isqlplus

Friday, January 29, 2010

Difference between spfile and pfile

1. spfile resides at server side. it is a binary file. pfile is static client-side file.
2. Pfile must be updated using text editor. Updating spfile manually will corrupt it. To update spfile, Alter System set Command is used.
3. Spfile can be backed up using RMAN.