DNA_DBA (2/2/2010)
hmmm.....I just want to see if the client is connecting to the database as this will use the listener and prove the connection details are correct - can you start a command prompt, change to the 10g bin directory and run sqlplus from there?
Ok, this is the result doing samething on the 10g drive
E:\Oracle\product\10.2.0>tnsping MyDB
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-FEB-2
010 15:55:47
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
E:\oracle\product\10.2.0\db_1etwork\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = MyServer)(PORT = 1535))) (CONNECT_DATA = (SERVICE_NAME = EGR
TST4)))
OK (50 msec)
E:\Oracle\product\10.2.0>sqlplus s/s@MyDB
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Feb 3 15:56:41 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: usrname
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: eg_sp
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
E:\Oracle\product\10.2.0>
What are your thoughts?