tnsping je alat slican ping-u - npr. provjerava da li je server ziv i dostupan.
Evo ti primjer tnsping-a:
Citat:
C:\>tnsping ora92
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-JUL-20
06 15:39:44
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Parameterdateien benutzt:
C:\ORACLE\network\admin\sqlnet.ora
Adapter TNSNAMES zur Auflösung des Alias benutzt
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ora92)))
OK (60 ms)
C:\>
Pokusaj prvo podesiti enviroment varijablu ORACLE_SID:
Code:
C:\> set ORACLE_SID=tvojSID;
pa se onda probaj spojiti...
Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA