Accessing Oracle database using SQL Developer

You can access Oracle database using SQL Developer as follows. The session opens on the user machine in SQL Developer therefore, ensure that SQL Developer is already installed on the user device. You can then provide the path where SQL Developer is installed in the Launcher Settings.

Procedure:

1. Login to the system and select PC from the product navigator.
2. Create SQL Developer Access Type → Configuration →Access Types.
3. Click on Add Access Type→ Name : Sql Developer →Select Base Access Type : Thick Client → Specify Additional Ports if any → Upload xml file in Plugin Process.
4. Click On User Profile → Settings → Launcher Settings.
5. Select Access Type as :  SQL Developer.
6. Login to the system and select PAM from the product navigator.
7. In the Execution Path field provide the path where SQL Developer is installed.
8. Go to My Access page →locate the oracle asset you want  to connect to →click on its action button.
9. Select Connect →SQL Developer.

Related articles

You can access Oracle database using SQL Developer as follows. The session opens on the user machine in SQL Developer therefore, ensure that SQL Developer is already installed on the user device. You can then provide the path where SQL Developer is installed in the Launcher Settings.

Procedure:

1. Create SQL Developer Access Type → Configuration →Access Types.
2. Click on Add Access Type→ Name : Sql Developer →Select Base Access Type : Thick Client → Specify Additional Ports if any → Upload xml file in Plugin Process.
3. Click On User Profile → Settings → Launcher Settings.
4. Select Access Type as :  SQL Developer.
5. In the Execution Path field provide the path where SQL Developer is installed.
6. Go to My Access page →locate the oracle asset you want  to connect to →click on its action button.
7. Select Connect →SQL Developer.

Related articles