Home » Infrastructure » Linux » 11g Installation problem in rhel 5.4 64 bit. (oracle 11g r2,rhel 5.4 64bit)
11g Installation problem in rhel 5.4 64 bit. [message #614131] Sat, 17 May 2014 03:20 Go to next message
treltenrenu
Messages: 10
Registered: June 2013
Location: Trivandrum
Junior Member
HI,

Irecently installed 11g r2 in an liunx machine. The installation was sucessful and i got GUI EM. That's working fine. The problem is when i tried to login in cmd line like "sqlplus / sys as sysdba" that cannot be exexuted. It show error like ''sqlplus' is not recognized as an internal or external command". I did update about the details of the oracle home,sid number also.When I tried to echo ORACLE_SID that shows the correct sid which was mydb. but when i try echo ORACLE_HOME the result reamains blank.

Please help me how to fix this error.


Re: 11g Installation problem in rhel 5.4 64 bit. [message #614132 is a reply to message #614131] Sat, 17 May 2014 03:28 Go to previous messageGo to next message
John Watson
Messages: 8455
Registered: January 2010
Location: Global Village
Senior Member
You have not configured your shell environment correctly. You do this by running the oraenv script. Look at this:
$
$ id
uid=500(oracle) gid=500(oinstall) groups=10(wheel),500(oinstall),501(dba),502(oper),503(asmadmin),512(ora_apexres1_MYROLE_ad)
$
$ which oraenv
/usr/local/bin/oraenv
$
$ . oraenv
ORACLE_SID = [oracle] ? apexres1
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2 is /u01/app
$
$ env|grep ORA
ORACLE_SID=apexres1
ORACLE_BASE=/u01/app
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2
$
$ which sqlplus
/u01/app/oracle/product/11.2.0/db_2/bin/sqlplus
$

Run the same commands, substituting the name of your instance where I used "apexres1".
Copy/paste the results here, enclosed within [code] tags. Please read How to use [code] tags and make your code easier to read

Re: 11g Installation problem in rhel 5.4 64 bit. [message #614133 is a reply to message #614132] Sat, 17 May 2014 04:15 Go to previous messageGo to next message
treltenrenu
Messages: 10
Registered: June 2013
Location: Trivandrum
Junior Member
how do i execute oraenv script and where can i enter the details which you provided. is that in .bash_profile file?
Re: 11g Installation problem in rhel 5.4 64 bit. [message #614137 is a reply to message #614133] Sat, 17 May 2014 04:54 Go to previous messageGo to next message
John Watson
Messages: 8455
Registered: January 2010
Location: Global Village
Senior Member
I gave precise instructions, with a demonstration. If you would like my assistance, please follow them.
Otherwise, perhaps you would prefer it if someone else responds.
Re: 11g Installation problem in rhel 5.4 64 bit. [message #614138 is a reply to message #614137] Sat, 17 May 2014 05:23 Go to previous message
treltenrenu
Messages: 10
Registered: June 2013
Location: Trivandrum
Junior Member
@John Watson
Thanks for replying me.I thought that was a script and i didn't realize that are all commands.Now i understand. Those commands are really working and now i can able to connect mydb through in cmd line.

Thanks for your precious help.
Previous Topic: Client Installation Issue.
Next Topic: rpm installation problem for installing Oracle 12c on Oracle linux 5.3
Goto Forum:
  


Current Time: Wed Jan 20 08:26:24 CST 2021