Need Help

From: Srinivas T <SrinivasT_at_KPITCummins.com>
Date: Mon, 20 Sep 2004 14:55:07 +0530
Message-ID: <4A1BE23A7B777442B60F4B4916AE0F1302932D6F@sohm.kpit.com>

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. "

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 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = nmp.world)(PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )

EXAMPLE1.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = Production1)(Port = 1521))
    )
    (CONNECT_DATA =
(SID = SID1)

    )
  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = beq.world)(PROTOCOL = BEQ)(PROGRAM = oracle73)(ARGV0 = oracle73ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )

SREE.KPIT.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SrinivasT.kpit.com)(PORT = 1521))
    )
    (CONNECT_DATA =

     (SID = msldevp9)


      (SERVICE_NAME = srinivast.kpit.com)

       (GLOBAL_NAME=msldevp9.world) 

    )
  )

EXAMPLE2.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = spx.world)(PROTOCOL = SPX)(Service = Server_lsnr))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )

MSLDEVP9.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
    )
    (CONNECT_DATA =
(SID = msldevp9)
(SERVICE=SREE);

    )
  )

Help me......

Regards,
Srinivas

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

Received on Mon Sep 20 2004 - 04:27:02 CDT