I am having two system in one system I am having 9i database and in another system I am having 11g. Know I need to access 9i from 11g. Because all data is in 9i.
In 11g I updated tnsnames.ora file as:
prog =
(DESCRIPTION=
(ADDRESS = (PROTOCOL=TCP) (HOST=129.1.1.29) (PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prog)
)
)
from cmd I tried tnsping prog
TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 08-MAY-2
014 09:51:31
Copyright (c) 1997, 2008, Oracle. All rights reserved.
Used parameter files:
C:\abdul\Oracle\Middleware\Oracle_FRHome2\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
After getting this error I open C:\abdul\Oracle\Middleware\Oracle_FRHome2\network\admin\sqlnet.ora file
This is sqlnet.ora file
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Help will be appreciable.
Thank you