Re: Oracle 9i Installation

Re-Hi Ian

[Quoted] Also, normaly after you install Oracle, you should find a lot of services named Oracle...
One of them normally named OracleOraHome92TNSListener. This service starts the Listener.

[Quoted] The Listener looks on each connection to the database the tnsnames.ora file. [Quoted] This files normally is saved in %ORACLE_HOME%\network\admin\ This file contains your connection information. e.g.
db19i =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = name-of-your-computer or ip-address) (PORT = 1521) ) )

    (CONNECT_DATA = (SID = DB19i) (SERVER = DEDICATED) ) )

[Quoted] If you want/can show us the connection information on your tnsnames.ora and [Quoted] the error-message-nr on trying to connect to database.

Regards, Hernan

"Ian McRae" <mixedcream_at_hotmail.com> schrieb im Newsbeitrag news:Phw%b.105$zu.58_at_newsfe1-win...
> Hi,
>
> I've done that. But what now? I didn't mention I'm new to installing
Oracle.
> I tried deleting the listener and adding another and that worked. But then
> LSNRCTL.exe crashed just after trying to connect to SQL Plus and I got an
> error TNS:Lost contact.
>
> Thanks for the help,
>
> Ian McRae
>
>
> "Hernan Cortez" <HernanCortez1_at_msn.com> wrote in message
> news:c1luf5$1k9fok$1_at_ID-221087.news.uni-berlin.de...
> > Hi
> >
> > Insert in the XP Registery
> >
> > HKEY_LOCAL_MACHINE
> > -> SOFTWARE
> > -> ORALCE
> > -> HOME0 (usualy HOME from Oracle Database [Ora92])
> > -> String: TNS_ADMIN
> > -> e.g. Value: E:\oracle\ora92\network\admin\tnsnames.ora
> > -> HOME1 (usualy HOME from Oracle Development Tools [DES92 or
DEV92])
> > -> String: TNS_ADMIN
> > -> e.g. Value: E:\oracle\ora92\network\admin\tnsnames.ora
> >
> > Kind regards
> >
> > "Ian McRae" <mixedcream_at_hotmail.com> schrieb im Newsbeitrag
> > news:UHs%b.1210$6l4.328_at_newsfe1-win...
> > > Hi,
> > >
> > > I'm having trouble installing Oracle 9i. I've 'successfully' installed
> > > Developer 6 (although an error message appears near the end which I'm
> told
> > > is a Windows XP problem and is okay). I'm trying to install the
> Enterprise
> > > edition and the database itself seems to install okay. When the
Database
> > > Configuration Assistant runs at the end I get errors. Namely:
ORA_12541
> > > TNS:No Listener and ORA-12560 TNS:Protocol Adapter Error. However when
I
> > try
> > > to start the listener I get a standard Windows XP error report window
> > > telling me it has crashed.
> > >
> > > I get the same error when trying to connect in Form Builder but with a
> > > different code: ORA_12224 TNS:No Listener.
> > >
> > > I'm running Windows XP on a Pentium 4 machine and the db name and SID
> are
> > > both 'master'. Please ask for more details if they are needed.
> > >
> > > Thanks in advance,
> > >
> > > Ian McRae
> > >
> > > PS. I can't use Net 8 Assistant/Easy Config as I get Java errors, so
if
> I
> > > have to edit and files, please could you post the code. Thanks
> > >
> > >
> >
> >
>
>
Received on Fri Feb 27 2004 - 10:06:53 CET