Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1116
  • Last Modified:

Installation of Oracle 11gR2 64 Bit

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
tamirmilo
Asked:
tamirmilo
  • 7
  • 6
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
tamirmiloAuthor Commented:
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
 
tamirmiloAuthor Commented:
I can not even access with "direct access" from toda - Get the same message. No client installed
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
slightwv (䄆 Netminder) Commented:
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
 
tamirmiloAuthor Commented:
0
 
slightwv (䄆 Netminder) Commented:
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
 
tamirmiloAuthor Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
tamirmiloAuthor Commented:
one last thing. How can i remove the client? From past experience the de-install wizard never do a perfect job
0
 
tamirmiloAuthor Commented:
And - I closed the question without really understanding that it is important. The guy said that it is just warning etc...
0
 
slightwv (䄆 Netminder) Commented:
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
 
slightwv (䄆 Netminder) Commented:
>>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
 
tamirmiloAuthor Commented:
ha ha.. i am senile.
Thank you very much and good day!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now