July 9, 2012 at 8:34 am
The Oracle 11g Client Version 11.2 is missing Drop down to specify Oracle Home Name.
The 11.1.0.7 had the drop down box and you could specify the Oracle Home Name.
It would be ideal if I get my hands on the 11.1.0.7 version but only 11.2 is available at Oracle's download site.
It is important that I can do this because I'm installing the 32 & 64 bit and if you do not specify the Oracle Home Names correctly then the second installation overwrites the first one.
I'm looking for a oraparam.ini tutorial that includes running the setup from the command line and specifying the arguments. I do not want to run the installation in silent mode although that may not be an option. A response file is out of the question because the Universal Installer does not prompt for the Oracle Home Name.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 10, 2012 at 4:52 pm
Oracle home can be specified at the command line, like:
./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 10, 2012 at 5:18 pm
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
I saw that syntax as well but I do not understand how that would work? What is it calling? What directory do you need to be in when you execute that command?
What is the exact sysntax with an example, please? I assume that you do not include the quotes?
On Friday I saw something like Setup.exe SET...
Could you provide additional details, very basic, step by step, please?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2012 at 5:42 am
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
Hope this helps.
What about ORACLE_BASE?, same syntax?
Are you sure that it is not setup.exe SET...?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2012 at 8:32 am
PaulB-TheOneAndOnly (7/10/2012)
Oracle home can be specified at the command line, like:./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"
I believe that the ./runInstaller is for Unix but thanks for the tip.
I used the following and after several attempts to remove all registry entries it worked.
SETUP.exe ORACLE_HOME="D:\ORACLE\Product\11.2.0\client_32" ORACLE_HOME_NAME="OraClient11g_home2"
It did not install an ODBC Driver and I can't get SQL Plus to work and it does not start in Notepad but in cmd.exe.
I saw a registry entry that is supposed to control whether it starts in notepad.
When I log into SQL Plus I get Error 12560 TNS: Protocol Adapter Error.
Thanks again for the help.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 13, 2012 at 5:47 am
I'm sorry for the delay.
You are correct, runInstaller is for Unix/Linux - as you figured it out setup does it for Windows.
In regards to the sqlplus error be sure environmental variables ORACLE_SID and ORACLE_HOME are set to the database and binaries you intend to connect. Also be sure that the Windows service for the ORACLE_SID is up-and-running.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply