SID (System Identifier)

What id SID?

It is a unique name identifying a specific Oracle database instance on a server. When you connect to an Oracle database, the SID helps specify which database instance to connect to, especially when multiple instances are running on the same server.

To find the SID of your Oracle database

Log in as a user with DBA privileges (such as SYS or SYSTEM).

SELECT instance_name AS SID FROM v$instance;

Grant Access to v$instance

Log in as a user with DBA privileges (such as SYS or SYSTEM).

GRANT SELECT ON v_$instance TO "zhamri";

Example for a JDBC connection string

jdbc:oracle:thin:@localhost:1521:FREE