50%

🚀

4

Oracle , .

, Oracle. , , , , , , .

Merion Academy



, , .

. 1

, Oracle , tnslsnr, . netstat, , , Oracle . , .

netstat

tnsping

, - tnsping, Oracle tnsnames.ora . , , tnsping ORCL, ORCL, ping . tnsping :

tnsping ORCL

ʻ . , . - . , , .

Oracle , 1521, tnsping , , tnsnames.ora . tnsnames.ora :

ORCL

, (ORCL), tnsping, , Oracle (1521), .


sqlplus

, Oracle - sqlplus. sqlplus ( Oracle) , Oracle, sqlplus, , , . sqlplus Oracle:

sqlplus username/password@SID

SID SID SERVICE_NAME, Oracle. , :

% sqlplus admin/f0xtrawt@ORCL

, SERVICE_NAME/SID . sql, , . :

SQL> select count(*) from user_tables;
COUNT(*)
----------
45	

Oracle, . connect2local connect2rem connect2mars ( mars).

Oracle, , , :

:

connect2local, OK SQL>, quit . , , Oracle, .


>