{"id":4104,"date":"2025-06-07T15:08:37","date_gmt":"2025-06-07T15:08:37","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=4104"},"modified":"2025-06-07T15:17:34","modified_gmt":"2025-06-07T15:17:34","slug":"connect-to-database","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/connect-to-database\/","title":{"rendered":"Connect to Database"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Use these methods to quickly connect to Oracle DB in various environments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. SQL*Plus (EZConnect)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlplus username\/password@host:port\/service_name<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlplus hr\/hr123@orclhost:1521\/ORCLPDB1<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. SQL*Plus (Local as SYSDBA)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlplus \/ as sysdba<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Works when you&#8217;re logged in as Oracle user on DB server.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. SQL*Plus via TNS<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sqlplus username\/password@TNS_ALIAS<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udccd Define alias in <code>tnsnames.ora<\/code> (usually in <code>$ORACLE_HOME\/network\/admin<\/code>)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. RMAN (Backup\/Restore)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>rman target username\/password@host:port\/service_name<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Or locally:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>rman target \/<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. SQL Developer (GUI)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>Host:        LAPTOP-00001111  \nPort:        1521  \nService:     FREE  \nUsername:    sys  \nPassword:    ********<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-1024x598.png\" alt=\"\" class=\"wp-image-4111\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-1024x598.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-300x175.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-768x449.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1-150x88.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/06\/image-1.png 1403w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">6. JDBC (Apps, Java)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>jdbc:oracle:thin:@\/\/host:1521\/service_name<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">7. SQLcl (Modern CLI)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code><code>sql hr\/hr123@host:1521\/service_name<\/code><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">8. OEM \/ PL\/SQL Developer (GUI)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">OEM: Web login<br>PL\/SQL Developer: TNS or direct settings<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc Notes:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Default port is 1521.<\/li>\n\n\n\n<li>Prefer <strong>SERVICE_NAME<\/strong> over SID unless explicitly required.<\/li>\n\n\n\n<li>Listener must be running: <code>lsnrctl status<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Use these methods to quickly connect to Oracle DB in various environments. 1. SQL*Plus (EZConnect) Example: 2. SQL*Plus (Local as SYSDBA) Works when you&#8217;re logged in as Oracle user on DB server. 3. SQL*Plus via TNS \ud83d\udccd Define alias in tnsnames.ora (usually in $ORACLE_HOME\/network\/admin) 4. RMAN (Backup\/Restore) Or locally: 5. SQL Developer (GUI) 6. JDBC [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-4104","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}