Hi Hans, thanks for your post, oracle services runing by oracle user and not by root, i used to have oracle8i on sco unix and my listener is working fine..i don't think that there is a big difference between 8i and 9i...at least for basic setup.
Regards
Hans Forbrich <hforbric_suse@(protected)> wrote: 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
-- ---- ---- ---- ---- ---- ----- Do you Yahoo!? vote.yahoo.com - Register online to vote today!
