The Oracle client should be installed on the machine that will access the Oracle server. If the aim is to access the server only for applications then Oracle client will suffice, however for administration and management duties additional admin packages also need to be installed.
Oracle Database 12c Release 1 can be downloaded from this page.
Toad connection
SQL Developer connection
The contents of tnsnames.ora
1 2 3 4 5 6 7 8 9 10 11 12 13 |
ASM =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = asm.ora.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) |
“ASM” is only an alias and any other name could be given in its place. To avoid confusion, the server and the host should share the same name
Note: To resolve the client machines name asm.ora.local
1 2 3 |
ping asm.ora.localPinging asm.ora.local [192.168.13.132] with 32 bytes of data: Reply from 192.168.13.132: bytes=32 time<1ms TTL=64 |
We need to get a response similar as the above lines. If you encounter any issues with name resolution
1. Enter the following line in C:WindowsSystem32driversetchosts
192.168.13.132 asm.ora.local asm
2. Alternatively tsnames.ora should be changed to include HOST = 192.168.13.132
Verifying the changes on the client machine:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
C:\> tnsping asmTNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 – Production on 08-HAZ-2011 16:18:37 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: c:appmdervisogluproduct.2.0client_1networkadminsqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.13.132) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))) OK (0 msec) |
If the listener is inactive or there are network access issues with port 1521:
1 |
TNS-12541: TNS:no listener « The error due to the mentioned situations |
Connecting to SQLPlus through the command prompt.
1 2 3 4 5 6 7 8 9 10 11 12 13 |
C:\> sqlplus omer/password@asm^^^ to connect, alternatively connect as the sysdba C:\> sqlplus sys/sys@asm as sysdba <a href="http://sysdba.org/sqlplus/">SQL*Plus</a>: Release 11.2.0.1.0 Production on Ãar Haz 8 16:36:01 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – Production With the Partitioning, OLAP, Data Mining and Real Application Testing options |
1 2 3 |
C:\> sqlplus omer/password@asm1SQL*Plus: Release 11.2.0.1.0 Production on Per Haz 9 14:42:33 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. |
1 |
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified |
Using RMAN for...
12 March 2019