 | | | Need Help | Need Help 2004-09-20 - By Sinardy Xing
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
1. startup oracle
2. sqlplus connect the database, you must able to do SQL > select sysdate =
from dual;=20
(Don 't Exit from sqlplus)
3. shutdown database or restart your listener (not reload)
4. back to the sqlplus session type SQL > select sysdate from dual;=20
No4. you should lost connection.
Sinardy
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Srinivas T
Sent: 20 September 2004 17:25
To: oracle-l@(protected)
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 (See ORA-03113.ora-code.com): 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
|
|
|