OCI Database connection from SQL Developer - OCI

-

OCI Database connection from SQL Developer.



In last article we have seen how to create database service and how to make connection from VM.

If you don't see please refer to below article :

https://himanshusinhadba.blogspot.com/2019/02/database-as-service-dbaas-create.html

Login to OCI Console.
Now DB System is ready.


 
 
Click on DB system name :
 
 
 
Now We have public IP, Private IP of DB Instance and DB name . That’s we Need for Client Connection.
Connection from SQL Developer is 2 Phase process :
 
  1. Make SSH connection to Server VM.
  2. Make SQL Net connection using SSH connection.
 Requirement :
  1. Public IP
  2. Private IP
  3. DB SID Name
Let’s GO :

1. Make SSH connection to Server :
 
Open SQL Developer from client machine.
 
 
 
 
Click on SSH , Right Click on SSH.
 
 
 
 
 
 
Verify DB Connection now :
Right Click on New SSH connection and then click Test.
 
 
 
 
 
 
Click OK.
Then Click Connect on Host and Click Connect on Port Forward Entry .
 
 
 
 
 
Now SSH connection to server made.
 
2.  Make SQL Net connection using SSH connection.
Go to File and then NEW
 
 
 
Connection Name : Give any Connection Name .
 
Username : System or any user you want to connect.
Password: In case of OCI Cloud Database , System password will be same as admin password.
Choose Oracle.
Choose Connection Type as SSH.
Port Forward : Select Your Connection which you created .
SID : Mention DB Name.
 
 
 
 
Click on Test and look for Status . If Success then you are good to go.
We all set to connect to DB now. Click Connect now.
 
 
 
 
 
We are done .
 
 
Happy Learning !!!
 
 
 



Comments

  1. Gursimran Singh Sra18 March 2022 at 10:24

    Himanshu, Thanks for detailed blog.
    In my case I am using Bastion and tried following above steps by replacing Public IP with Bastion IP, but things aren't working. Any suggestions?

    ReplyDelete

Post a Comment

Popular posts from this blog

Workflow Agent Listener Service WF_DEFERRED + Business Event not processing

-
Workflow Agent Listener Service WF_DEFERRED Will Not Start, Mailer May Be Down To implement the solution, please execute the following steps: 1.  Use this query to identify any remaining items in wf_deferred queue: SQL> select corrid, decode(state, 0, '0 = Ready', 1, '1 = Delayed', 2, '2 = Retained', 3, '3 = Exception', to_char(state)) State, count(*) COUNT from wf_deferred group by corrid, state; 2. Items with the APPS corrid will not dequeue from agent listener via service container.  This runs the deferred listener from the command lin e . Make sure that the listener and workflow service components - including the mailer - are down before you run this . This is not intended to be a substitute for the normal operation of this service container from the OAM console. Use this only during this cleanup operation. One will have to run this script manually: begin wf_log_pkg.wf_debug_flag := TRUE; wf_event...
Read more

Output Post Processor - EBS 12.2.4 Troubleshoot

-
Output Post Processor TroubleShooting Issue 1 Output Post Processor is Down with Actual Process is 0 And Target Process is 1 1. Shutdown Concurrent Managers 2. To ensure concurrent manager down; check there is no FNDLIBR process running. ps -ef | grep FNDLIBR 3. Run adadmin to relink FNDSVC executable. a. Invoke adadmin from command prompt b. Choose option 2 (2. Maintain Applications Files menu) c. Choose option 1 (1. Relink Applications programs ) d. Then type FND When prompted; ( Enter list of products to link (all for all products) [all] : FND ) e. Ensure adrelink is exiting with status 0 4. Start Concurrent Managers 5. Check the Output Post Processor Issue 2 Concurrent Processing  R12 Output Post Processor Service Not Coming Up Reason : If Service Manager for the node is not running.  Possible cause might be service manager definition is missing under Concurrent ->Manager ->Define form. If the Service Manager is not pr...
Read more

How to Diagnose Workflow Notification Mailer Issue

-
Outbound Notification Emails : 1. Check if the notification is present in the recipient/user's Worklist/Notifications page.If it does not exist     then it means that notification itself is not created and need to check the corresponding workflow     status.You may also query the notification from the wf_notifications table SQL> select recipient_role,notification_id,status,mail_status from wf_notifications where recipient_role like '&user_name';    The e-mail notification is sent only if all of following are true.                --Notification status is OPEN or CANCELED                --Notification mail_status is MAIL or INVALID 2. Check Recipient role has a valid e-mail address and notification preference MAIL% SELECT email_address, nvl(WF_PREF.get_pref(name, 'MAILT...
Read more