RE: Need Help

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 20 Sep 2004 17:41:31 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401677BE0@antares.bcsgroup.com.sg>

Hi,

One reason that I know is that The connection is drop and you need to = restart your session,

here is how you stimulate the error

startup oracle
sqlplus connect the database, you must able to do SQL> select sysdate = from dual;=20 (Don't Exit from sqlplus)
shutdown database or restart your listener (not reload)
back to the sqlplus session type SQL> select sysdate from dual;=20

No4. you should lost connection.

Sinardy

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Srinivas T Sent: 20 September 2004 17:25
To: oracle-l_at_freelists.org
Subject: Need Help

HI,
I am having 9.0.2 version of oracle running on windows 2000 = professional.
The Problem I am facing when I am trying create net8 config.

the error as follows
"

Connecting...ORA-03113: end-of-file on communication channel The test did not succeed.

Some of the information you provided may be incorrect. Press Back to review the information provided for net service name, or = Change Login to change username.=20
"

I am having oracle 8i software also in my PC.

SQL> select * from global_name;

GLOBAL_NAME

-------------------------------------------------------------------------=

MSLDEVP9.US.ORACLE.COM the Red color ones are created by me but not working.........

# TNSNAMES.ORA Network Configuration File: = C:\Software\Oracle\Database\Oracle9i\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

EXAMPLE3.WORLD =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (COMMUNITY =3D nmp.world)(PROTOCOL =3D NMP)(Server = =3D FinanceServer1)(Pipe =3D ORAPIPE))

    )
    (CONNECT_DATA =3D
      (SID =3D ORCL)
    )
  )

EXAMPLE1.WORLD =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (COMMUNITY =3D tcp.world)(PROTOCOL =3D TCP)(Host =3D = Production1)(Port =3D 1521))

    )
    (CONNECT_DATA =3D
      (SID =3D SID1)
    )
  )

BEQ-LOCAL.WORLD =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (COMMUNITY =3D beq.world)(PROTOCOL =3D BEQ)(PROGRAM = =3D oracle73)(ARGV0 =3D oracle73ORCL)(ARGS =3D = '(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))'))

    )
    (CONNECT_DATA =3D
      (SID =3D ORCL)
    )
  )

SREE.KPIT.COM =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D SrinivasT.kpit.com)(PORT = =3D 1521))

)
(CONNECT_DATA =3D

     (SID =3D msldevp9)
      (SERVICE_NAME =3D srinivast.kpit.com)
       (GLOBAL_NAME=3Dmsldevp9.world)=20

)
)

EXAMPLE2.WORLD =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (COMMUNITY =3D spx.world)(PROTOCOL =3D SPX)(Service = =3D Server_lsnr))

    )
    (CONNECT_DATA =3D
      (SID =3D ORCL)
    )
  )

MSLDEVP9.WORLD =3D
(DESCRIPTION =3D

(ADDRESS_LIST =3D
(ADDRESS =3D (COMMUNITY =3D tcp.world)(PROTOCOL =3D TCP)(Host =3D = 127.0.0.1)(Port =3D 1521))

)
(CONNECT_DATA =3D

      (SID =3D msldevp9)
      (SERVICE=3DSREE);

)
)

Help me......

Regards,
Srinivas

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 20 2004 - 04:37:07 CDT