Re: Oracle 9i Installation

From: Ian McRae <mixedcream_at_hotmail.com>
Date: Fri, 27 Feb 2004 12:05:24 -0000
Message-ID: <4nG%b.178$vY.18_at_newsfe1-win>


Hi,

[Quoted] [Quoted] This is the complete tnsnames.ora text:

# TNSNAMES.ORA Network Configuration File: c:\oraclehome\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

MASTER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = master)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = master)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = master)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

The TNSListener service has started. As well as the two other basic services. I'm still receiving errors when trying to connect from Form Builder. The first error is ORA-12571 TNS: packet writer failure and then eventually lsnrctl.exe will crash and I will get a different error ORA-12224 TNS:no listener. I've tried restarting the listener using 'lsnrctl start' from a command prompt but it will just crash again after about a minute.

I'm in desperate need of help, as this is for a piece of university work and the deadline is approaching !

Do you think an upgrade to XP Professional would do any good?

Thanks

Ian McRae

"Hernan Cortez" <HernanCortez1_at_msn.com> wrote in message news:c1n1av$1krq10$1_at_ID-221087.news.uni-berlin.de...
> Re-Hi Ian

>

> 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.
>
> The Listener looks on each connection to the database the tnsnames.ora
file.
> 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) ) )
>
> If you want/can show us the connection information on your tnsnames.ora
and
> 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 - 13:05:24 CET

Original text of this message