i have installd oracle 10 on Solaris 10 now i want to access this database from remote machine.
-bash-3.00$ tnsping 192.168.92.49
TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:06:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/export/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=iac-nms01.))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.92.49)(PORT=1521)))
TNS-12541: TNS:no listener
-bash-3.00$
---------------------------------
i have configured listener.ora
-bash-3.00$ more listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VMSol10)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
when a apply this adapters command i didnt find any adapter
-bash-3.00$ adapters
Installed Oracle Net transport protocols are:
Installed Oracle Net naming methods are:
Installed Oracle Advanced Security options are:
-bash-3.00$
Please help me out.