oracle environment variable setting file
-
I want to write a program to run SQL*PLUS on UNIX operating system. Before I run it, I should setting the system environment variables such as "ORACLE_HOME", "ORACLE_SID" first. But, I met with a question, I don't know from which profile I can get these information? Who can give me some suggestion? Many thanks.
-
I want to write a program to run SQL*PLUS on UNIX operating system. Before I run it, I should setting the system environment variables such as "ORACLE_HOME", "ORACLE_SID" first. But, I met with a question, I don't know from which profile I can get these information? Who can give me some suggestion? Many thanks.
I don't understand your usage of the term 'profile' in your question. But the two variables you are trying to set are needed to identify the location of Oracle software, ie. where has Oracle been installed?. Talk to your DBA and find out this location. The second parameter identifies the database that you wish to connect to. There may be many instances of Oracle databases running, so again you will need to confer with your DBA to find out the name of the instance that you wish to connect to.
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
-
I don't understand your usage of the term 'profile' in your question. But the two variables you are trying to set are needed to identify the location of Oracle software, ie. where has Oracle been installed?. Talk to your DBA and find out this location. The second parameter identifies the database that you wish to connect to. There may be many instances of Oracle databases running, so again you will need to confer with your DBA to find out the name of the instance that you wish to connect to.
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
Well, may be you misunderstand my meanings. After the DBA installed the oracle software, he set these two variables. I think this information(ORACLE_HOME,ORACLE_SID) might be saved in a profile by the oracle process. And when I want to run the SQL*PLUS, I first read these information from this file, because the login user has changed, and the environment variable might be changed too. But I didn't know whether this file exist or not and its path. Do you have any idea about it? Many thanks