Primer DEDICATED - SHARED konekcije
ORCLD =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME = orcld.saga.co.yu)
)
)
ORCLD_SHARED =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER =
SHARED)
(SERVICE_NAME = orcldXDB.saga.co.yu)
)
)
C:\Users\darkoj>sqlplus /nolog
SQL*Plus: Release 12.1.0.1.0 Production on Tue Dec 8
16:02:54 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect system/elcaro@orcld
Connected.
SQL> select sid, serial# from v$session where audsid=
sys_context('userenv','sessionid');
SID
SERIAL#
----------
----------
355
47
SQL> SELECT SID,SERIAL#,STATUS,SERVER
from v$session where SERIAL#=47;
SID
SERIAL# STATUS SERVER
----------
---------- -------- ---------
355 47 ACTIVE DEDICATED
SQL> connect system/elcaro@ORCLD_SHARED
Connected.
SQL> select sid, serial# from v$session where audsid= sys_context('userenv','sessionid');
SID
SERIAL#
----------
----------
355 149
SQL> SELECT SID,SERIAL#,STATUS,SERVER from v$session where SERIAL#=149;
SID
SERIAL# STATUS SERVER
----------
---------- -------- ---------
355 149 ACTIVE SHARED
V$SESSION kolona SERVER
SERVER VARCHAR2(9) Server type (DEDICATED| SHARED| PSEUDO| NONE)
C:\Users\darkoj>lsnrctl
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production
on 08-DEC-2015 15:45
:56
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL>
status
Connecting
to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS
of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows:
Version 12.1.0.1.0 - Produ
ction
Start
Date 06-DEC-2015 10:05:16
Uptime 2 days 5 hr. 40 min. 43 sec
Trace
Level off
Security ON: Local OS Authentication
SNMP OFF
Listener
Parameter File
D:\app\darkoj\product\12.1.0\dbhome_1\network\admin\li
stener.ora
Listener
Log File
D:\app\darkoj\diag\tnslsnr\jelisavcic-hp\listener\aler
t\log.xml
Listening
Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jelisavcic-hp.saga.co.yu)(PORT=5500
))(Security=(my_wallet_directory=D:\APP\DARKOJ\admin\orcld\xdb_wallet))(Presenta
tion=HTTP)(Session=RAW))
Services
Summary...
Service
"CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status
UNKNOWN, has 1 handler(s) for this service...
Service
"orcld.saga.co.yu"
has 1 instance(s).
Instance "orcld", status READY, has
1 handler(s) for this service...
Service
"orcldXDB.saga.co.yu"
has 1 instance(s).
Instance "orcld", status READY, has
1 handler(s) for this service...
Service
"pdb2.saga.co.yu" has 1 instance(s).
Instance "orcld", status READY, has
1 handler(s) for this service...
Service
"pdb3.saga.co.yu" has 1 instance(s).
Instance "orcld", status READY, has
1 handler(s) for this service...
Service
"pdborcl.saga.co.yu" has 1 instance(s).
Instance "orcld", status READY, has
1 handler(s) for this service...
The command completed successfully