Oracle Developer: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
Khm (talk | contribs)
No edit summary
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
== Program installation ==
First of all you need to install the package http://downloads.inlogic.dk/sqldeveloper.zip
==SIS==
==SIS==
You need to fill out Username, Password and change the connection string information.[[File:Oracle developer SIS.jpg|none|thumb|877x877px]]
You need to fill out Username, Password and change the connection string information.[[File:Oracle developer SIS.jpg|none|thumb|877x877px]]
Line 15: Line 18:
[[File:Oracle developer EASY.jpg|none|thumb|877x877px]]
[[File:Oracle developer EASY.jpg|none|thumb|877x877px]]


== STADS ==
==STADS==
You need to fill out Username, Password and change the connection string information.
You need to fill out Username, Password and change the connection string information.
[[File:Oracle_developer_SIS.jpg|link=http://wiki.inlogic.dk/index.php/File:Oracle_developer_SIS.jpg|none|thumb|877x877px]]
[[File:Oracle_developer_STADS.jpg|link=http://wiki.inlogic.dk/index.php/File:Oracle_developer_STADS.jpg|none|thumb|877x877px]]


=== Connection string ===
===Connection string===
jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)
jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)


Line 26: Line 29:
(ADDRESS = (PROTOCOL = TCP)(HOST = '''<Host>''')(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = '''<Host>''')(PORT = 1521))


(CONNECT_DATA =(SERVER=dedicated)(SERVICE_NAME = '''<SID>''')))
(CONNECT_DATA = (SERVER=dedicated)(SERVICE_NAME = '''<SID>''')))
<br />

Latest revision as of 12:22, 8 April 2019

Program installation

First of all you need to install the package http://downloads.inlogic.dk/sqldeveloper.zip

SIS

You need to fill out Username, Password and change the connection string information.

Connection string

jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)

(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1610))

(ADDRESS = (PROTOCOL = TCP)(HOST = <Host>)(PORT = 1521))

(CONNECT_DATA = (SERVICE_NAME = <SID>)))

EASY

You just need to fill out Username and Password

STADS

You need to fill out Username, Password and change the connection string information.

Connection string

jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)

(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1645))

(ADDRESS = (PROTOCOL = TCP)(HOST = <Host>)(PORT = 1521))

(CONNECT_DATA = (SERVER=dedicated)(SERVICE_NAME = <SID>)))