sqlnet.log Error Message

[ChiTownDiva]

If there are any DBA's out there, could you tell me what this means?

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\Seagate Software\Crystal Reports\crw32.exe)(HOST=GAFJ44000993477)(USER=WZYBBPR))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.6.0.0 - Production
Time: 09-OCT-2002 08:34:21
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 126
nt OS err code: 0


Thanks.

ChiTownDiva

 

[rcurva]

Could you post your listener.ora file here? I suspect you are using other protocols that you don't need. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[ChiTownDiva]

I'm a client and not the server. I don't have access to the server.

I had "bequeath" protocol in my tnsnames file in 8.0, but when I installed 8i, there's no bequeath so I couldn't configure it.

But here's my tnsnames.ora file.

# TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DEV.GA.BST.BLS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.60.72.186)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.60.72.168)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = ORTEDSD1)
)
)

PROD.GA.BST.BLS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.10.128.196)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.10.128.196)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = ORTEDSP1)
)
)

SUNPROD.GA.BST.BLS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.10.128.196)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.10.128.196)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = ORTEDSP1)
)
)

ORTEDSD1.GA.BST.BLS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 90.60.72.186)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORTEDSD1)
)
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)


Thanks.

ChiTownDiva

 

[rcurva]

But do you need bequeath protocol?
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[sem]

Bequeath protocol may be used only from the server, it eliminates the need in listener. For remote comunications you should use TCP instead.

 

[ChiTownDiva]

Thanks guys, so why am I getting this error message?

 

[Turkbear]

Check the 'location' of your data in CrystaReports Designer (under the database..Set Location menu item) ..It may be using an ODBC source that is incorrectly configured....

If you have an Oracle client installed( as you do), I would advise not using ODBC at all, but the 'native' Oracle connection available under More Data Sources..Oracle Server
in the Log On to server section...

Also, to be sure that the correct tnsnames.ora file is bieng used( the 8.1 one) set an environment variable ( a system one) called TNS_ADMIN and set it to c:\Oracle\Ora81\NETWORK\ADMIN