The Oracle System ID (SID) is used to uniquely identify a particular database on a system
How to set ORACLE_SID:
Windows:
set ORACLE_SID=orcl
Unix/ Linux:
export ORACLE_SID=orcl
SID is case sensitive in Unix / Linux environments.
How to check the current ORACLE_SID:
Windows:
Go to the commnand prompt and type as
C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set).
C:\> set (To know all the parameters set)
Unix/ Linux:
echo $ORACLE_SID
Hi, guys!
ReplyDeleteIn the following post, there is a PL/SQL script that generates the current database environment file.
Also, it contains a good example of an environment file you'd better use for your database.
http://dbpilot.net/2018/01/30/generating-an-enviroment-file-from-pl-sql/
...