On Tuesday 12 October 2004 08:46, Mohammad N. Tina wrote: > Hi, > i ran root.sh with no problem. or error.. > i created my DB usign a script provided by my application vendor. > as oracle user i can enter to this directory. > my application is working fine..but i need to access through listener. > > am I missing something > > Thanks
With all due respect, you are missing some fundamental concepts ... you should plan on spending some time reading Oracle's Concepts documentation available at http://docs.oracle.com or http://tahiti.oracle.com
In a nutshell, you can think of Oracle working like this:
- the Oracle kernel must be running (SMPN, 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 Pnnn process - Pnnn will connect to a free port other than 1521 - there are firewall implications to this!
- 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
- process Pnnn works as a proxy on behalf of your pogram - reads and writes ONLY to the System Global Area SGA) - makes requests of the DB Writer, etc. to fill/flush the SGA
- the DBWR reads and writes the files in the database area. - neither your program, nor proxy Pnnn, writes to the disk.
- the userid that is running Oracle must have write permission for - database files and directories - log files and directories - control files and directories
The above is only ONE way that Oracle can work, but it is the most common. Since there are variations, it is important to read the docco to understand why and what the variations are.
/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
