SQL Developer Install Notes (BANTEST, BANPROD, BANPPRD)

To add someone/reset their password for SQL Developer Banner connections, contact Alex Crane, ahw0008.

 

Everything for SQL Developer should be in the sqldeveloper-18.3.0.zip folder. The zip file will contain the folder sqldeveloper, containing the executable and all associated files. Place this folder in C:\.

 

You will probably want to create a desktop shortcut for the sqldeveloper.exe executable.

 

You do not have to run an installer since the folder contains the executable and will run from the sqldeveloper folder.

 

Connect to GlobalProtect as the user has to be connected to the VPN in order to use SQL Developer.

 

Launch the executable to open SQL Developer:

 

 

Once inside, we can do some initial setup.

 

First, we need to add the TNS directory for the Banner connections. To do so, click on Tools on the top bar, then Preferences.

 

In this menu, click Database, then Advanced. Here you can enter the TNS directory:

\\tnsadmin.auburn.edu\tnsadmin

 

 

Once we have the TNS directory listed, we can start adding connections.

 

To add a connection, click the green plus button   in the top left, and you’ll be prompted with the menu below:

 

 

We want to change the connection type to TNS, and then enter the Username and Password for the connection. Click the dropdown for network alias, and set it to the connection we are trying to make, which will be BANTEST, BANPROD, or BANPPRD. Once the connection is set to look like the image below, click Test to make sure you are able to connect, and then save the connection:

 

 

 

SQL should now be fully set up and ready to go!

For resetting the password, there are two options:

 

1. Right-click the connection and click Reset Password
2. In the console window, you can use the following command to set a new password:

ALTER USER [USER] IDENTIFIED BY [PASSWORD]

Just replace the red parts with your username and new password