Here is how I am able to connect to the database using SQLDeveloper, without using TNSNAMES option.
Note: All the notes have been written for *nix (Linux/UNIX) OS versions
Leave the connection Type as "Basic"
Determine the Hostname, port and global database name as mentioned below:
- open a terminal
- type lsnrctl (the prompt will change to LSNRCTL>)
- type show pid
- This will display host (which you will enter in hostname) and the port values.
- Next determine service name by running the following SQL:
- SELECT VALUE AS "Service Name" FROM v$parameter WHERE name = 'service_names'
- Enter value into Service Name
- Click on Test and ensure that you are able to connect.
- Finally click on save to save it in the connection list.
