Home » RDBMS Server » Networking and Gateways » Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error)
Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error) [message #195987] Tue, 03 October 2006 08:48 Go to next message
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
Member
In 8i i am getting this error Listener startup

Would u Plz resolve This its Very urgent


TNSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 03-OCT-2006 15:44:53

(c) Copyright 1999 Oracle Corporation. All rights reserved.

System parameter file is e:\oracle\demoora\8.0.6\NET80\admin\DEMO_oracle\listener.ora
Log messages written to e:\oracle\demoora\8.0.6\NET80\log\listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc))

Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=d~wX1w|)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

32-bit Windows Error: 1001: Unknown error

TNSLSNR80 for 32-bit Windows: Version 8.0.6.3.0 - Production on 03-OCT-2006 15:51:59

(c) Copyright 1999 Oracle Corporation. All rights reserved.

System parameter file is e:\oracle\demoora\8.0.6\NET80\admin\DEMO_oracle\listener.ora

Log messages written to e:\oracle\demoora\8.0.6\NET80\log\listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc))

Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=d~wX1w|)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

32-bit Windows Error: 1001: Unknown error


Host name is : Oracle

the TnsNames file Look like this


#
# Net8 definition for the database
#

PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521))
(CONNECT_DATA=(SID=PROD))
)


#
# Net8 definitions for FNDFS and FNDSM on the HTTP server node - oracle
#

FNDFS_oracle = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)

FNDFS_oracle.arrow.local = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)

#
# For when the profile FS_SVC_PREFIX is set these entries will be used
#
FNDFS_PROD_oracle = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)

FNDFS_PROD_oracle.arrow.local = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDFS))
)

FNDSM_oracle_PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDSM_PROD))
)

FNDSM_oracle.arrow.local_PROD = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1626))
(CONNECT_DATA=(SID=FNDSM_PROD))
)


regards
seenu
Re: Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error) [message #206785 is a reply to message #195987] Fri, 01 December 2006 08:01 Go to previous messageGo to next message
Vivekanand
Messages: 2
Registered: November 2006
Location: Mumbai
Junior Member
Hi,

Kindly chek for user ID and password for the same and also check whether you can login using the cnnect utlity from client systen

also check the permissin for the Lister.ora file

Best of luck

Regards,

Vivekanand Pandey
Re: Problem in connecting to sql(32-bit Windows Error: 1001: Unknown error) [message #206984 is a reply to message #206785] Sun, 03 December 2006 00:16 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

check ur host in listener.ora file specified in "ip address" instead of "name".
if specified in name then change to ip address.

and
check ur database services is start.

hope this helps
Taj
Previous Topic: oracle error
Next Topic: oracle spawns new listener (Oracle 10GR2)
Goto Forum:
  


Current Time: Sun Dec 04 00:14:12 CST 2016

Total time taken to generate the page: 0.06990 seconds