The Art of Changing | Confessions of a Pragmatic Intellectual's Mind on The Constant in Life, Change!
There can be more than one Oracle instance on a single machine. In order to be able to distinguish these instances, Oracle uses a SID (System Identifier) which is a string. The SID can be set through the ORACLE_SID environment variable.D:oracleproduct10.1.0>set ORACLE_SID=ORA10 On Windows, each instance requires a Windows service. This service must first be…
I was trying to connect to database using the following URL : jdbc:oracle:thin:@//dbs03.~~~~.ca:1521/database_name_dev while JDBC needs an SID to connect to and not a database name or TSN name. Not sure how should you find it out what an SID is for a given database for now, but after changing it to jdbc:oracle:thin:@//dbs03.~~~~.ca:1521/db03, I could…