I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos.
LSNRCTL for Linux: Version 188.8.131.52.0 - Production on 23-JUN-2014 14:49:41 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hayer)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 184.108.40.206.0 - Production Start Date 23-JUN-2014 14:03:58 Uptime 0 days 0 hr. 45 min. 42 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/hayer/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hayer)(PORT=1522))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
My tnsnames.ora file is as follows:
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) (SID = orcl) ) ) ~ ~ ~ ~
On Centos server I can log in using sqlplus too. I changed tnsnames.ora on windows to same as server.I have added oracle host information in windows host file and I can ping oracle host and telnet host on port 1522.
I have disables service iptables so no type of firewall exists on centos.
But I still get following error on Windows client:
SQL*Plus: Release 220.127.116.11.0 Production on Mon Jun 23 14:51:31 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: system as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: system as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error