Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Installation of Oracle 11gR2 64 Bit

Posted on 2011-02-15
13
Medium Priority
?
1,113 Views
Last Modified: 2012-08-13
Hello,
This question is related to question that i have asked yesterday.
I realized only now the the Oracle 11g client is not installed. I am able to connect to Oracle via sqlplus and not via sqlplusw, i also got a message that the client is not installed after Toad installation.
Please look at:
http://www.experts-exchange.com/Database/Oracle/Q_26819455.html
Thank you
0
Comment
Question by:tamirmilo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34896273
sqlplusw does not exist in 11g.  If you have it, there is an older client installed and that client likely isn't configured properly.

Not sure why Toad doesn't see the software.  It might be because of the multiple Oracle homes.  Verify you have more than one version installed then we'll try to troubleshoot Toad.
0
 

Author Comment

by:tamirmilo
ID: 34896582
Hi,
I did download the client for 11gR2 64 Bit.
I have two folders under C:\app\Administrator\product\11.2.0.
1) client_1
2) dbhome_1
I have set ORACLE_UNQNAME=orcl.  I wonder if i need to set up other environment variables like ORACLE_HOME etc.
Thx
0
 

Author Comment

by:tamirmilo
ID: 34896599
I can not even access with "direct access" from toda - Get the same message. No client installed
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34896612
ORACLE_UNQNAME is only for Enterprise Manager.

You do need to have a proper environment set up for the various tools to work.  For example, if everything is pointing to the 11g install and you try to run sqlplusw from the other install, you will get errors.

Do you need both installs?

For the Toad error:  Is the Toad you have 32Bit or 64Bit?  My guess is it's 32Bit and it cannot see/access the 64Bit Oracle CLient install.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34896683
Looks like I was correct about the Toad problem.  

From that link you posted:  "Toad is a 32 bit application, you need to install 11.2.0 32 bit Oracle client."
0
 

Author Comment

by:tamirmilo
ID: 34896940
Yes, you were right.
Do you know how to resolve the problem from yesterday (emctl and oc4j error) or should i open another question?
Thank you for your efforts
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34896990
>>Do you know how to resolve the problem from yesterday

You closed that question so it been resolved.  Did you close it without a resolution?

I also encourage you to run a single client version unless you must have several.  It keeps things a lot less complex if you only have a single client installed.
0
 

Author Comment

by:tamirmilo
ID: 34897003
one last thing. How can i remove the client? From past experience the de-install wizard never do a perfect job
0
 

Author Comment

by:tamirmilo
ID: 34897013
And - I closed the question without really understanding that it is important. The guy said that it is just warning etc...
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34897047
I agree about Oracle not doind a good job with uninstalls.

How familiar/comfortable are you with the registry and editing it?

There are a lot of white papers/links that walk you though a Manual Remove of Oracle products but it requires editing the registry.  This can be very dangerous if you are not sure about what you are doing.

This is even more complex if you have multiple Oracle homes and are only wanting to manually remove a single.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 34897053
>>without really understanding that it is important.

Who said it was important?

>> The guy said that it is just warning etc...

That guy was actually me.
0
 

Author Closing Comment

by:tamirmilo
ID: 34897105
ha ha.. i am senile.
Thank you very much and good day!
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question