Kbase P107183: How to troubleshoot error (1252) and (1451) when using Local Oracle DataServer with SQL*NET/NET8 con
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/3/2005 |
|
Status: Unverified
GOAL:
How to troubleshoot error (1252) and (1451) when using Local Oracle DataServer with SQL*NET/NET8 configuration
GOAL:
How to troubleshoot Oracle error -1012 "** not logged on" when using Local Oracle DataServer with SQL*NET/NET8 configuration
GOAL:
How to verify if the SQL*net
et8 services configurated properly
GOAL:
How to use tnsping
FACT(s) (Environment):
Oracle DataServer
Oracle
FIX:
NET8 (called SQL*NET prior to Oracle8) is Oracle's client/server middleware product that offers transparent connection from client tools to the database, or from one database to another.
In Local Oracle DataServer configuration, if the Oracle Database is remotely located you can use SQl*net
et8 to connect to the remote Oracle database.
An Oracle client installation is required to be able to use this type of connection.
One you configure the service , use tsnping utility to make sure that this service is properly configured so you can use in your connection to the Oracle Database.
To invoke the TNSPING utility, enter the following:
tnsping net_service_name [count]
where
net_service_name: must exist in tnsnames.ora file or the name service in use, such as NIS or DCE's CDS.
count (optional): determines how many times the program attempts to reach the server.
the output of this command should something like:
>tnsping orac
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 03-AUG-2005 14:48:05
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = host1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orac)))
OK (20 msec)