oracle client: instantbasicclient
instaliran sql plus i client devel.
oracle home dir je postavljen na: /usr/lib/oracle/11.2/client64
u client64 kreirana je mapa network, unutar mape network kreirana je mapa admin u kojoj su smještene ora datoteke.
tnsnames izgleda ovako:
ORCL11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.y)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl11)
)
)
sqlnet.ora izgleda ovako
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
kad se probam spojiti sam sqlplusom, dovivam ovu grešku:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified