1748066 Members
5398 Online
108758 Solutions
New Discussion

Re: Create user

 
Raoof
Regular Advisor

Re: Create user

 

Please find below the details of envi file's..

 

/u01/oracle
$ vi .oraenv
".oraenv" 14 lines, 442 characters
ORACLE_BASE=/u01/oracle/11.1.0 export ORACLE_BASE
ORACLE_HOME=/u01/oracle/11.1.0/product/db_1 export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_BASE export PATH
ORACLE_SID=mcmsdb1 export ORACLE_SID
NLS_LAN=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
CLASS_PATH=$ORACLE_HOME/jlib
export CLASS_PATH
CRS_HOME=/u01/app/11.1.0/crs
export CRS_HOME
PATH=$CRS_HOME/bin:$PATH
export PATH

 


###############

$ vi .asmenv
".asmenv" 16 lines, 376 characters
ORACLE_HOME=/u01/oracle/11.1.0/product/asm
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
ORACLE_SID=+ASM1
export ORACLE_SID
NLS_LAN=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
CLASS_PATH=$ORACLE_HOME/jlib
export CLASS_PATH
CRS_HOME=/u01/app/11.1.0/crs
export CRS_HOME
PATH=$CRS_HOME/bin:$PATH
export PATH

 

When i tried with the below cammond it works, but coudl you please tell me why i cannot go with only single dot instead of . ./.oraenv?

 

 . ./.oraenv

 

 

Regards

Dennis Handly
Acclaimed Contributor

Re: Create user

>could you please tell me why I cannot go with only single dot instead of . ./.oraenv?

 I told you already: What is $PATH set to?  ($PATH is required for sourcing too.)

 

You must have a "." somewhere in one of your $PATH components:  a-path:.:another-path

Or better yet, you must have the absolute path of those two env files in $PATH.

Raoof
Regular Advisor

Re: Create user

 

>> I told you already: What is $PATH set to?  ($PATH is required for sourcing too.)

 

Hope the PATH from the below envi file's is what you talking about? please correct me if am wrong.


$ vi .oraenv
".oraenv" 14 lines, 442 characters
ORACLE_BASE=/u01/oracle/11.1.0 export ORACLE_BASE
ORACLE_HOME=/u01/oracle/11.1.0/product/db_1 export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_BASE export PATH
ORACLE_SID=mcmsdb1 export ORACLE_SID
NLS_LAN=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
CLASS_PATH=$ORACLE_HOME/jlib
export CLASS_PATH
CRS_HOME=/u01/app/11.1.0/crs
export CRS_HOME
PATH=$CRS_HOME/bin:$PATH
export PATH

 


###############

$ vi .asmenv
".asmenv" 16 lines, 376 characters
ORACLE_HOME=/u01/oracle/11.1.0/product/asm
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
ORACLE_SID=+ASM1
export ORACLE_SID
NLS_LAN=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
CLASS_PATH=$ORACLE_HOME/jlib
export CLASS_PATH
CRS_HOME=/u01/app/11.1.0/crs
export CRS_HOME
PATH=$CRS_HOME/bin:$PATH
export PATH

 

>>You must have a "." somewhere in one of your $PATH components:  a-path:.:another-path

Or better yet, you must have the absolute path of those two env files in $PATH.

 

Sorry i didn't get you from you above statements sorry.

 

Regards

 

 

 

 

Dennis Handly
Acclaimed Contributor

Re: Create user

>Hope the PATH from the below env files is what you talking about?

 

No.  You can't use the $PATH variable from inside the file you are trying to source.  :-)

You need to set it in your ~/.profile.

 

>>You must have a "." somewhere in one of your $PATH components:  a-path:.:another-path
>>you must have the absolute path of those two env files in $PATH.

>Sorry I didn't get you from your above statements.

 

How many times are you sourcing these two files?  If only once, then just use an absolute or relative path.

Otherwise you'll need to put the directory containing those two files in your $PATH settings.