Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SuSE Linux 7.2 /etc/services and Oracle 9i - Help!

Re: SuSE Linux 7.2 /etc/services and Oracle 9i - Help!

From: Tim Schaefer <tim_at_datad.com>
Date: Mon, 1 Oct 2001 21:55:18 -0400
Message-ID: <za9u7.15811$0h4.557712@sjcpnn01.usenetserver.com>


Frank,

Thanks for your suggestion!

I cannot promise I'll try this out, to be completely honest it is important for me to try to keep the install as 'pristine' as possible, with the motivation for me to get Oracle certified as soon as I can. Thusly, I would like to keep the system on its TCP footing for as long as possible, in order to get through all the things I must learn in 'install' fashion. Kinda like boot-camp for me right now, not capable of getting into the derivatives until I am worthy. :-)

But I will put this in my DBA notebook for the future so that after I get more familiar with the baseline installation, and the magical mystery tour of the world of Oracle, I can try out some of the alternative configurations.

Thanks,

Tim

Tim Schaefer
Grasshopper Oracle DBA
http://www.datad.com

"Frank van Bortel" <fbortel_at_home.nl> wrote in message news:3BB8A92E.A50EF01E_at_home.nl...
> Tim Schaefer wrote:
> <snip>
> I'd like to propose some changes: implement ipc; it's faster that tcp,
> and as you are working locally...
>
> Additions inline
> >
> > Per your request, here are the gang of three:
> >
> > --begin listener.ora:
> >
> > oracle_at_linux:~/product/9.0.1/network/admin > cat listener.ora
> > # LISTENER.ORA Network Configuration File:
> > /opt/oracle/product/9.0.1/network/admin/listener.ora
> > # Generated by Oracle configuration tools.
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> (ADDRESS = (PROTOCOL = IPC)(KEY = MUTT01))
> (ADDRESS = (PROTOCOL = IPC)(KEY = OEMREP))
> > )
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521))
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = /opt/oracle/product/9.0.1)
> > (PROGRAM = extproc)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = mutt01)
> > (ORACLE_HOME = /opt/oracle/product/9.0.1)
> > (SID_NAME = mutt01)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = OEMREP.local)
> > (ORACLE_HOME = /opt/oracle/product/9.0.1)
> > (SID_NAME = OEMREP)
> > )
> > )
> >
> > oracle_at_linux:~/product/9.0.1/network/admin >
> >
> > --end listener.ora
> >
> > --begin tnsnames.ora
> >
> > oracle_at_linux:~/product/9.0.1/network/admin > cat tnsnames.ora
> > # TNSNAMES.ORA Network Configuration File:
> > /opt/oracle/product/9.0.1/network/admin/tnsnames.ora
> > # Generated by Oracle configuration tools.
> >
> > EXTPROC_CONNECTION_DATA.LOCAL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> > )
> > (CONNECT_DATA =
> > (SID = PLSExtProc)
> > (PRESENTATION = RO)
> > )
> > )
> >
> > MUTT01.LOCAL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY=MUTT01 ))
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = mutt01)
> > )
> > )
> >
> > OEMREP.LOCAL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY=OEMREP))
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = OEMREP.local)
> > )
> > )
> >
> > INST1_HTTP.LOCAL =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = linux.local)(PORT = 1521 ))
> > )
> > (CONNECT_DATA =
> > (SERVER = SHARED)
> > (SERVICE_NAME = MODOSE)
> > (PRESENTATION = http://HRService)
> > )
> > )
> >
> <snip>
> Not sure whether you could do withour a listener alltogether (sorry - no
> linux/oracle
> @home - yet) but the above would try IPC and TCPIP - so you should be
> covered.
>
> --
> Gtrz,
>
> Frank van Bortel
Received on Mon Oct 01 2001 - 20:55:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US