Wir kümmern uns!
Service,please!ServicesinderOracleDatenbank
JochenKutscherukOracleCertifiedMastermerlin.zwoInfoDesignGmbH&Co.KG76228Karlsruhe
Spitzenleistungheißt,sichaufseineStärkenzukonzentrieren.
merlin.zwoWirmachenOracle- nurOracle.AusgutemGrund.
www.merlin-zwo.de
Wir kümmern uns!
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 WannsolltenServicesverwendetwerden?
6 Zusammenfassung
Einleitung
mzwo =(DESCRIPTION_LIST =
(FAILOVER = ON)(LOAD_BALANCE = OFF)(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = m2doag1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = m2doag2)(PORT = 1521))
)(CONNECT_DATA =
(SERVICE_NAME = mzwo)(SERVER = DEDICATED)
) )
)
DefinitionderConnection:
Einleitung
XYZ-Anwendung
Username XYZ
Passwort **********
Server 10.43.15.7
Port 1521
VerbindungzuOracle-Datenbank:
SID XE
Anmelden
....
[ORACLE]
USER=XYZ
PASS=VERYSECRET
SERVER=10.43.15.7
PORT=1521
SID=XE
....
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 WannsolltenServicesverwendetwerden?
6 Zusammenfassung
DieStrukturderDatenbank
ControlFiles
OnlineLogfiles
ParameterFile
PasswordFile
ArchiveLogfiles
OracleDatenbank
Tablespaces
Datafiles
Segmente
Extents
OracleDataBlocks
DieStrukturderDatenbank
OracleDatenbank
DB_NAMEmzwo
InstanceSGA
SharedPool
StreamsPool LargePool
JavaPool Buffer Cache LogBuffer
SMON PMON DBWn
CKPT LGWR ARCn
INSTANCE_NAMEmzwo
=ORACLE_SIDmzwo
DBID3756491154
Memory
Prozesse
VerbindungzurDatenbank
OracleDatenbank
DB_NAMEmzwo
Instance
ListenerDBID
3756491154INSTANCE_NAME
mzwo
ORACLE_SIDmzwo
Port1521
SIDmzwo
SERVICE_NAMEmzwo
VerbindungzurDatenbank
OracleDatenbank
DB_NAMEmzwo
Instance
Listener DBID3756491154
INSTANCE_NAMEmzwo
ORACLE_SIDmzwo
Port1521
SIDmzwo
SERVICE_NAMEmzwo
SIDmzwo
SERVICE_NAMEmzwo
alter system set service_names = ‘mzwo, oltp, apex, dwh, report‘;
SERVICE_NAMEoltp
SERVICE_NAMEapex
SERVICE_NAMEdwh
SERVICE_NAMEreport
SERVICE_NAMEoltp
SERVICE_NAMEapex
SERVICE_NAMEdwh
SERVICE_NAMEreport
VerbindungzurDatenbank
OracleDatenbank
DB_NAMEmzwo
Instance
Listener DBID3756491154
INSTANCE_NAMEmzwo
ORACLE_SIDmzwo
SIDmzwo
SERVICE_NAMEmzwo
SERVICE_NAMEoltp
SERVICE_NAMEapex
SERVICE_NAMEdwh
SERVICE_NAMEreport
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=m2doag)(PORT=1521)))
Services Summary...
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Service “mzwoXDB" has 1 instance(s).
Instance “mzwo", status READY, has 1 handler(s) for this service...
Port1521
DefinitionService
AliasnamefüreineodermehrereDatenbankinstanzen
Default-ServiceentsprichtdemDatenbanknamen
DatenbankinstanzkanneinenodermehrereServicesbeimListener registrieren
ClientmussbeiderVerbindungkeineInstanzangeben
GDS:Clientweißnicht,woderServiceläuft
VerwendungService
GleichartigeAnwendungen
MitServicesApplikationengruppieren
Prozessgruppen(OLTP,DWH,Batches,Web-Zugriffe)
GleichartigeProgrammtypen(Client-Server,APEX,PHP)
ApplikationeninTeilbereicheaufteilen
GleicheSLAs
Applikationengetrennthandhaben
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 Warnn solltenServicesverwendetwerden?
6 Zusammenfassung
VerbindungzurDatenbank
OracleDatenbank
DB_NAMEmzwo
DBID3756491154
Instance2
INSTANCE_NAME mzwo2ORACLE_SID mzwo2
Instance3
INSTANCE_NAME mzwo3ORACLE_SID mzwo3
Instance6
INSTANCE_NAME mzwo6ORACLE_SID mzwo6
:RealApplicationCluster
Instance
INSTANCE_NAME mzwoORACLE_SID mzwo
Instance1
INSTANCE_NAME mzwo1ORACLE_SID mzwo1SERVICE_NAME mzwoSERVICE_NAME oltp
SERVICE_NAME apexSERVICE_NAME report SERVICE_NAME dwh
Services Summary...
....
Service “mzwo" has 6 instance(s).
Instance “mzwo1", status READY, has...
Instance “mzwo2", status READY, has...
Instance “mzwo3", status READY, has...
Instance “mzwo4", status READY, has...
Instance “mzwo5", status READY, has...
Instance “mzwo6", status READY, has...
Service “oltp" has 3 instance(s).
Instance “mzwo1", status READY, has...
Instance “mzwo2", status READY, has...
Instance “mzwo3", status READY, has...
Service “apex" has 4 instance(s).
Instance “mzwo3", status READY, has...
...
Instance “mzwo6", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo6", status READY, has...
VerbindungzurDatenbank:RealApplicationCluster
Instance2 Instance3 Instance6
INSTANCE_NAME mzwoORACLE_SID mzwo
Instance1SERVICE_NAME mzwoSERVICE_NAME oltp
SERVICE_NAME apexSERVICE_NAME reportSERVICE_NAME dwh
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo1", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo1", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo1", status READY, has...
....
LokalerListener aufInstance1 „Globaler“SCAN-Listener
Services Summary...
....
Service “mzwo" has 6 instance(s).
Instance “mzwo1", status READY, has...
Instance “mzwo2", status READY, has...
Instance “mzwo3", status READY, has...
Instance “mzwo4", status READY, has...
Instance “mzwo5", status READY, has...
Instance “mzwo6", status READY, has...
Service “oltp" has 3 instance(s).
Instance “mzwo1", status READY, has...
Instance “mzwo2", status READY, has...
Instance “mzwo3", status READY, has...
Service “apex" has 4 instance(s).
Instance “mzwo3", status READY, has...
...
Instance “mzwo6", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo6", status READY, has...
Service “report" has 2 instance(s).
Instance “mzwo1", status READY, has...
Instance “mzwo2", status READY, has...
....
VerbindungzurDatenbank:RealApplicationCluster
Instance2 Instance3 Instance6
INSTANCE_NAME mzwoORACLE_SID mzwo
Instance1SERVICE_NAME mzwoSERVICE_NAME oltp
SERVICE_NAME apexSERVICE_NAME reportSERVICE_NAME dwh
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo1", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo1", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo1", status READY, has...
....
LokalerListener aufInstance1 „Globaler“SCAN-Listener
VerbindungzurDatenbank:RealApplicationCluster
Instance2 Instance3 Instance6
INSTANCE_NAME mzwoORACLE_SID mzwo
Instance1SERVICE_NAME mzwoSERVICE_NAME oltp
SERVICE_NAME apexSERVICE_NAME reportSERVICE_NAME dwh
SCAN-Listener m2scan
LokalerListener LokalerListener LokalerListener LokalerListener
scott/tiger@m2scan:1521/dwh
scott/tiger@m2scan:1521:dwh
scott/tiger@mzwo-host6:1521:dwh
scott/tiger@mzwo-host6:1521/dwh
✓
⚠
❌
❌
VerbindungzurDatenbank:RealApplicationCluster
Instance2 Instance3 Instance6
INSTANCE_NAME mzwoORACLE_SID mzwo
Instance1SERVICE_NAME mzwoSERVICE_NAME oltp
SERVICE_NAME apexSERVICE_NAME reportSERVICE_NAME dwh
SCAN-Listener m2scan
LokalerListener LokalerListener LokalerListener LokalerListener
oltpdb =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = m2scan)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME = oltp)(SERVER = DEDICATED) ))
srvctl add service–db mzwo-service oltp-preferred “mzwo1,mzwo2,mzwo3“-tafpolicy BASIC-failovertype SESSION-failovermethod BASIC.....
scott/tiger@oltpdbscott/tiger@m2scan/oltp
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 WannsolltenServicesverwendetwerden?
6 Zusammenfassung
VerwendungvonServices:DataGuard
Active DataGuard SnapshotStandby
INSTANCE_NAME mzwoORACLE_SID mzwo
PrimaryDatabaseSERVICE_NAME mzwo SERVICE_NAME mzwo SERVICE_NAME mzwo
host-prim host-dg host-snap
mzwo =(DESCRIPTION_LIST =(FAILOVER = ON)(LOAD_BALANCE = OFF)(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host-prim)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-dg)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-snap)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = mzwo)(SERVER = DEDICATED)
) )
)
VerwendungvonServices:DataGuard
Active DataGuard SnapshotStandby
INSTANCE_NAME mzwoORACLE_SID mzwo
PrimaryDatabaseSERVICE_NAME mzwo SERVICE_NAME mzwo SERVICE_NAME mzwo
host-prim host-dg host-snap
mzwo =(DESCRIPTION_LIST =(FAILOVER = ON)(LOAD_BALANCE = OFF)(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host-prim)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-dg)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-snap)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = mzwo)(SERVER = DEDICATED)
) )
)
VerwendungvonServices:DataGuard
Active DataGuard SnapshotStandby
INSTANCE_NAME mzwoORACLE_SID mzwo
PrimaryDatabaseSERVICE_NAME mzwo
SERVICE_NAME oltp
SERVICE_NAME apex
SERVICE_NAME report
SERVICE_NAME mzwo SERVICE_NAME mzwo
SERVICE_NAME schulung
host-prim host-dg host-snap
srvctl add service–db mzwo-service oltp-role PRIMARY
.....
srvctl add service–db mzwo-service report-role PHYSICAL_STANDBY
.....
srvctl add service–db mzwo-service apex-role PRIMARY
.....
srvctl add service–db mzwo-service schulung-role SNAPSHOT_STANDBY
.....
VerwendungvonServices:DataGuard
Active DataGuard SnapshotStandby
INSTANCE_NAME mzwoORACLE_SID mzwo
PrimaryDatabaseSERVICE_NAME mzwo
SERVICE_NAME oltp
SERVICE_NAME apex
SERVICE_NAME report
SERVICE_NAME mzwo SERVICE_NAME mzwo
SERVICE_NAME schulung
host-prim host-dg host-snap
oltpdb =(DESCRIPTION_LIST =(FAILOVER = ON)(LOAD_BALANCE = OFF)(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host-prim)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-dg)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-snap)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = oltp)(SERVER = DEDICATED)
) )
)
VerwendungvonServices:DataGuard
PrimaryDatabase SnapshotStandby
INSTANCE_NAME mzwoORACLE_SID mzwo
PrimaryDatabase
SERVICE_NAME oltp
SERVICE_NAME apex
SERVICE_NAME report
SERVICE_NAME mzwo SERVICE_NAME mzwo
SERVICE_NAME schulung
host-prim host-dg host-snap
oltpdb =(DESCRIPTION_LIST =(FAILOVER = ON)(LOAD_BALANCE = OFF)(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host-prim)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-dg)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host-snap)(PORT = 1521))
)(CONNECT_DATA =(SERVICE_NAME = oltp)(SERVER = DEDICATED)
) )
)
VerwendungvonServices:Multitenant
Instance
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP APEX
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP APEX DWH
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP APEX DWH REPORT
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP APEX DWH REPORT SCHULUNG
VerwendungvonServices:Multitenant
Services Summary...
....
Service “mzwo" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “oltp" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “apex" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “dwh" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “report" has 1 instance(s).
Instance “mzwo", status READY, has...
Service “schulung" has 1 instance(s).
Instance “mzwo", status READY, has...
....
Container INSTANCE_NAME =ORACLE_SID =mzwo
OLTP APEX DWH REPORT SCHULUNG
scott/tiger@m2doag:1521:mzwo
✓
⚠
❌
scott/tiger@m2doag:1521/mzwo
scott/tiger@m2doag:1521:oltp
scott/tiger@m2doag:1521/oltp
scott/tiger@m2doag:1521:apex
scott/tiger@m2doag:1521/apex
✓
❌
✓
VerwendungvonServicesnotwendig
RealApplicationCluster DataGuard ManualStandby
AutomatischesLoadBalancingAutomatischerClientFailoverSCAN-Listener mitSIDgehtnicht
AutomatischerClientSwitchoverAutomatischerClientFailover
AutomatischerClientReconnect
Multitenant GlobalDataServices Sharding
FunktioniertnurüberServiceConnectzuPDBnurüberService FunktioniertnurüberService
Sackgasse
XYZ-Anwendung
Username XYZ
Passwort **********
Server 10.43.15.7
Port 1521
VerbindungzuOracle-Datenbank:
SID XE
Anmelden
....
[ORACLE]
USER=XYZ
PASS=VERYSECRET
SERVER=10.43.15.7
PORT=1521
SID=XE
....
Highway
XYZ-Anwendung
Username XYZ
Passwort **********
Server 10.43.15.7
Port 1521
VerbindungzuOracle-Datenbank:
Service oltp
Anmelden
....
[ORACLE]
USER=XYZ
PASS=VERYSECRET
SERVER=10.43.15.7
PORT=1521
SERVICE=oltp
....
....
[ORACLE]
USER=XYZ
PASS=VERYSECRET
CONNECT=m2scan:1521/oltp
....
....
[ORACLE]
USER=XYZ
PASS=VERYSECRET
CONNECT=m2scan:1521/oltp
....
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 WannsolltenServicesverwendetwerden?
6 Zusammenfassung
AnlegeneinesService:SingleInstance
alter system set service_names = ‘mzwo, oltp, apex, dwh, report‘;
ServicesstehenunmittelbarzurVerfügung
exec dbms_service.create_service(service_name => ‘oltp', network_name => ‘oltp')
exec dbms_service.create_service(service_name => ‘apex', network_name => ‘apex')
exec dbms_service.create_service(service_name => ‘dwh', network_name => ‘dwh')
exec dbms_service.create_service(service_name => ‘report', network_name => ‘report')
Servicemussexplizitgestartetwerden
exec dbms_service.start_service(‘oltp')
Alternativ:
BeendeneinesService:SingleInstance
alter system set service_names = ‘mzwo‘;
AlleServicesaußermzwo werdenunmittelbarbeendet.AktiveSessionsbleibenbestehen!
exec dbms_service.stop_service(‘oltp')
exec dbms_service.stop_service(‘apex')
exec dbms_service.stop_service(‘dwh')
exec dbms_service.stop_service(‘report')
AktiveSessionskönnenbeendetwerden:
exec dbms_service.disconnect_session(‘apex‘,IMMEDIATE)
Alternativ:
AnlegeneinesService:RealApplicationCluster
srvctl add service –db mzwo -service oltp -preferred “inst1,...“ -tafpolicy BASIC
-failovertype SESSION -failovermethod BASIC .....
srvctl start service –db mzwo –service “oltp, ....“ [–instance ....] ....
Servicemussexplizitgestartetwerden
BeendeneinesService:RealApplicationCluster
srvctl stop service –db mzwo –service “oltp, ....“ [–instance ....] ....
Servicewirdbeendet,aktiveSessionsbleibenbestehen
srvctl stop service –db mzwo –service “oltp, ....“ [–instance ....] .... -force
ServiceundaktiveSessionswerdenunmittelbarbeendet
AnlegeneinesService:DataGuard
srvctl add service –db mzwo -service oltp -role PRIMARY .....srvctl add service –db mzwo -service apex -role PRIMARY .....srvctl add service –db mzwo -service report -role PHYSICAL_STANDBY .....srvctl add service –db mzwo -service schulung -role SNAPSHOT_STANDBY .....
BeiVerwendungvonOracleRestart:
create or replace trigger ich_bin_primary after startup|db_role_change on databasedeclarerolle varchar2(30);
beginselect database_role into rolle from v$database;
if rolle = 'PRIMARY' thendbms_service.start_service('OLTP');dbms_service.start_service('APEX');
end if;end;
OhneVerwendungvonOracleRestart:
WannsolltenServicesverwendetwerden?
SeitOracle8irecommended! Oracle8iwurde1998released.
DerDefault-ServicebleibtdemAdministratorvorbehalten.
KontrolleüberdieDatenbankbehalten:
NeuesReleasederAnwendungeinspielen
AmoklaufendeProzesseaussperren
WievielLastüberwelchenService
Wieviele ProzesseüberwelchenService
RessourcenbegrenzungüberResource Manager(CPU,I/O)
Ressourcenzeitgesteuertzuweisen
Schemas/Datenbankentransparentverschieben
∞mehrMöglichkeiten.....
Agenda
1 Einleitung
2 WasisteinOracleDatenbankService?
3 WiewerdenServicesverwendet?
4 WannmüssenServicesverwendetwerden?
5 WannsolltenServicesverwendetwerden?
6 Zusammenfassung
Zusammenfassung
KeinDatenbankzugriffüberSID!
DerDefault-ServiceistdemAdministratorvorbehalten!
mzwo =(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(HOST = m2doag)(PORT = 1521)) )(CONNECT_DATA =(SID = mzwo)(SERVER = DEDICATED) ) )
mzwo =(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(HOST = m2doag)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME = oltp)(SERVER = DEDICATED) ) )
sqlplus scott/tiger@mzwo
sqlplus scott/tiger@m2doag:1521/oltp
sqlplus scott/tiger@m2doag/oltp
jdbc:oracle:thin:/@m2doag/oltp
jdbc:oracle:thin:/@m2doag:1521/oltp
Wir kümmern uns!
merlin.zwoInfoDesignGmbH&Co.KGJochenKutscherukElsa-Brändström-Straße1476228KarlsruheTel.0721– 1320960
[email protected]://www.merlin-zwo.de
Fragen?
WeitereVorträgevonmerlin.zwo:Di,14:00Uhr,F.Tokio SvenJagic:OracleJETinApexMi,12:00Uhr,Riga: DanielNelle:SolokarrierealsOracleNoSQL ClusterMi,14:00Uhr,Istanbul: SebastianWittig:OWASPundAPEXMi,16:00Uhr,Prag: JochenKutscheruk:OracleVM:DerAuswegaus
demVirtualisierung-DilemmaMi,17:00Uhr,Shanghai: JochenKutscheruk:Service,please!