oracle directory permssions and listener 2004-10-12 - By Hans Forbrich
My apologies. Many errors in my post - I should never post before coffee!
Corrections to my post as follows, highlighted with a *
In general, replace my original Pnnn with 'dedicated' process. (Thanks Kevin
- I have no idea why I did that!) The dedicated process (oracle{sid}) runs
as the local proxy on behalf of the user process.
- the Oracle kernel must be running (SMON, PMON, DBWR, etc.)
- must be started using sqlplus (connect / as sysdba ; startup)
- must be started by the owner of oracle (and NOT root!)
- the Listener must be running
- must be started using lsnrctl start
- must be started by the owner of oracle (and NOT root)
- your program talks to the listener on port 1521 using Oracle Networking
* the listener tells the Oracle kernel to start up a dedicated process
* - dedicated will connect to a free port other than 1521
- there are firewall implications to this!
* - process will be identified as 'oracle{sid}'
(this is replaced by client starting a dedicated process in BEQ
mode if on the local machine. No listener required.)
- the listener passes the port number to your process
- Oracle Networking now connects your process to that port
- the listener gets out of the way and is NOT involved again
(so is this)
* dedicated process works as a proxy on behalf of your pogram
- reads and writes the System Global Area (SGA)
* - reads data files (and writes, if direct path)
- the userid that is running Oracle must have write permission for
- database files and directories
- log files and directories
- control files and directories
I deliberately do not get into MTS, shared servers, etc. - as indicated, there
are many variations to the scenario.
In any case, the original poster should be referring to startup userid
section, and the permissions. Those are the only areas I can see to help
resolve the OP's problem.
/Hans
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
