Spoolight on Oracle Configuration

Spoolight

Seting 1
Oracle_home=d:\oracle\product\11.2.0\client_1
Set sqlpath=d:\oracle\product\11.2.0\client_1
Set local=d:\oracle\product\11.2.0\client_1
Set ld_library_path=d:\oracle\product\11.2.0\client_1

D:\oracle\product\11.2.0\client_1\bin;d:\oracle\product\11.2.0\client_1

D:\Quest Software

Setting 2
COP could not being uninstall
Datasourcesqlnet could not being uninstalleed
Spotlightportals could not being uninstalleed
DATASOURCEPPCM could not being uninstall
Datasourcerac could not being uninstall
Soc
Datasourcesqlnet
Spotlighportals

Setting 3

CD d:\ support \ Office software \oracle10201_client_win32\client

If you had 64-bit server and 32-bit client installed on the same computer it's possible that Spotlight looks for Oci.dll At wrong Oracle Home.

Examine order of Oracle home directories from Universal Installer and place 32-bit home first:

Run Oracle Universal Installer
Click "Installed Products" button
Switch to "Environment" tab
Reorder Oracle Homes with arrows in right side and click "Apply"

Setting 4:
C:\Program files\quest software\spotlight\console\spotlight.exe/developer:1

Setting 5
C:\dbmonitor

D:\Quest Software

Setting 6

C:\Users\penghuishun. Crbcoa\appdata\local\virtualstore\program Files (x86) \quest software
C:\Users\penghuishun. Crbcoa\appdata\roaming

Setting 7
Sqlplus Hddtusr/[email Protected]//192.168.27.145:15021/phddtuat

Sqlplus Systme/[email Protected]//10.241.96.37:1556/vats

Setting 8

Regedit

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\AutoShareServer

NET use \\R304AH9E\c$

1. Restore the administrative share for C $. See Microsoft document http://support.microsoft.com/kb/314984

2. Check The It is OK:
-Net use \\-the current user (i.e. User Administrator group) should has all privileges on the default share

3. Retry the installation

5.ignore the error

6.log:
D:\oracle\product\11.2.0\client_1\cfgtoollogs\oui

Ref
http://blog.csdn.net/msdnchina/article/details/43878995

# #seting 7

C:\Program Files (x86) \oracle\inventory\logs

###########
Well, interesting. I figured out what is going wrong. From the Connection Manager, the installed clients | Connect Using is defaulting to the Oracle 6i report/forms home. Once I selected the 11g home, Presto. Usually the products select by default the home which are first listed in the system PATH and uses connections from specified by the Tns_admin system variable. Thanks Vincent for helping!

# # #seting 9

Set Tns_admin=d:\oracle\product\11.2.0\client_1\network\admin
Set Nls_lang=american_america. Zhs16gbk
Set Ocidll=d:\oracle\product\11.2.0\client_1\oci.dll

Regedit
Hkey_local_machine\software\wow6432node\oracle\key_oraclient11g_home1

##### #seting 10
D:\oracle\product\11.2.0\client_1>tnsping

TNS Ping Utility for 32-bit windows:version 11.2.0.1.0-production on 11-jan-2
018 20:35:22

Copyright (c) 1997, Oracle. All rights reserved.

####### #setting 11

https://www.club-oracle.com/threads/cannot-load-oci-dll.3178/

Cannot load OCI DLL
Discussion in ' Other development Tools ' started by Mdsmit, Oct 6, 2010.

Mdsmit
Mdsmit
Active Member
Messages:5
Likes received:0
Trophy points:55
I am setting up tools on a new Windows 7 PC with my company issued me and has everything working except TOAD.

I installed Oracle 10.2.0.3 on my PC and setup my oracle_home and tns_admin environment variables. I also set up by TNS file and host file. Afterwards I installed TOAD 10.1.1.8 as well as SQL Developer.

I am able to connect to any database setup in my TNS file through SQL Plus as well as through SQL Developer. If I open TOAD, my Oracle instalation is not appearing in the "Connect Using:" box when I try to make a connection. The only thing this appears there is a old installion of Oracle 8 then was partially copied over when the tech staff Copi Ed files from the My old PC to my new one. That installition was invalid and doesn ' t work.

I looked through the TOAD User Guide, and it have the following information about how it finds clients:

How Toad Finds the Oracle Client DLL
1. Toad first looks in the Toad command line for Ocidll.
2. If this isn't found, Toad looks for the path for the Oracle home as follows:
3. If the command line argument "Oraclehome" is passed in, then Toad'll use
That home.
4. If There is no Toad home defined then Toad would display the home that is set as the
Default home using Oracle ' s home Selector application as the default in the dropdown.
Toad'll use the home, that's active in the dropdown.
5. To populate the dropdown, Toad searches the registry as follows:
?? First, Toad reads the list of Oracle home names from the keys under HKEY_
Local_machine\software\oracle\all_homes
?? If No Oracle Homes is found there and then the Oracle home was set to HKEY_
Local_machine\software\oracle
?? Otherwise, Toad finds the Oracle_home value for each ORACLE HOME, if it
Exists. Then Toad checks the system environment variable called PATH to see
Whether it contains the "Bin" folder under Oracle_home. Toad selects the
Oracle home whose path appears first in path.
?? If Toad still hasn ' t found an Oracle home, it uses HKEY_LOCAL_
Machine\software\oracle.
6. Toad looks for the client DLL in the ' Bin ' folder under the path found for the
Oracle Home
?? If that fails, Toad looks for the Oracle_home key under Hkey_local_
Machine\oracle\software, and look for the client DLL in the "Bin" folder
Under that.
?? If that also fails, Toad looks for the client DLL in every \ Bin directory in PATH.

I checked my registry, and my Oracle installion does appear in a 10g folder within HKEY_
Local_machine\software\oracle.

What else can I do to try and get TOAD to find my 10g Oracle installion?

Thanks for any help you can give.
Mdsmit, Oct 6, #1
Mdsmit
Mdsmit
Active Member
Messages:5
Likes received:0
Trophy points:55
Re:oracle instalation not appearing on Connect Using Dropdown in TOAD

I was able to partially solve the problem by finding where TOAD is getting that path. I set the correct path, but now it gives the error:

"Cannot load OCI dll:c:\oracle\product\10.2.0\client_2\bin\oci.dll"

Even though Oci.dll is in the that directory. Any ideas as-why it can ' t load it?
Mdsmit, Oct 6, #2
Sadik
Sadik
Community Moderator Forum Guru
messages:1,989
Likes received:252
Trophy points:1,455
Re:oracle instalation not appearing on Connect Using Dropdown in TOAD

Ok, which version of Toad is you using?
Sadik, Oct 7, #3
Sadik
Sadik
Community Moderator Forum Guru
messages:1,989
Likes received:252
Trophy points:1,455
Re:oracle instalation not appearing on Connect Using Dropdown in TOAD

Oh OK it's + +. What is the currently values "paths" of the PATH environment variable?
Sadik, Oct 7, #4
Mdsmit
Mdsmit
Active Member
Messages:5
Likes received:0
Trophy points:55
I was able to find out the reason why it couldn ' t load the OCI DLL. Apparently no matter what version of TOAD you has, it's incompatible with the installations of Oracle.

TOAD looks for Oracle installations under hkey_local_machine/software/wow6432node/oracle which are where because that is WH ere a bit installations is registered. I had put the path of my the bit Oracle installation there, but it still doesn ' t work because TOAD requires a + bit instal Lation.

So, I installed a by-bit version of Oracle, which TOAD is able to find, and only to receive a similar error:

"Can ' t initialize OCI. Error-1 "

I was instructed by my tech team at my project to add the following line to my Sqlnet.ora file to solve this error, but it Didn ' t:

NAMES. Directory_path= (TNSNames)

What does, get rid of that, is when I-ran TOAD as Administrator on my PC. But now it gives a TNS error for any DB I try to connect to:

"Ora-12154:tns:could not resolve the connect identifier specified" and then the DB i is using

However, I am able to connect to these databases with SQL Plus and SQL developer without any issue. And yes, I have the My TNS file in my network/admin directory for my new The installation as well as my + bit installation . And when I look at the TNSNames Editor in TOAD it had loaded everything from my TNS file.

Why can it isn't resolve the database when it had properly loaded it and I can connect with every other tool?
Mdsmit, Oct 7, #5
Sadik
Sadik
Community Moderator Forum Guru
messages:1,989
Likes received:252
Trophy points:1,455
Well it simply means this Toad is unable to find the correct Oracle home through the PATH variable. That's why I asked your to check the values of PATH environment variables in the first place.
Sadik, Oct 7, #6
Mdsmit
Mdsmit
Active Member
Messages:5
Likes received:0
Trophy points:55
Path is set to:

"C:\oracle\product\10.2.0\client_3\bin; c:\oracle\product\10.2.0\client_2\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem;% Systemroot%\system32\windowspowershell\v1.0\; C:\Program Files\tortoisesvn\bin "

The string "C:\oracle\product\10.2.0\client_3\bin" is the bin directory for my installation.

The string "C:\oracle\product\10.2.0\client_2\bin" is the bin directory for my installation bit.
Mdsmit, Oct 7, #7
Mdsmit
Mdsmit
Active Member
Messages:5
Likes received:0
Trophy points:55
I found the issue for what I was getting the TNS error:

Ora-12154:tns:could not resolve the connect identifier specified

Apparently TOAD can ' t parse program locations that has parenthesis:

http://www.synergys.ca/index.php?option=com_lyftenbloggie&category=installation&Itemid=68&lang=en

Uninstalling TOAD from my ' program Files ' (x86) directory and installing it directly in my c:directory solved the issue.

######### #follow:

Setting 11

Checking help/about Spotlight/view Release Notes

It feedback:
Missing "Ociw32.dll" File:if Spotlight on Oracle cannot locate the file Ociw32.dll, please check that your PATH statement Includes a path to the <oracle>/bin directory.

CP D:\oracle\product\11.2.0\client_1\ociw32.dll to D:\oracle\product\11.2.0\client_1\bin

CP D:\oracle\product\11.2.0\client_1\oci.dll to D:\oracle\product\11.2.0\client_1\bin

Setting 12
Lost Orannzsbb11.dll

CP D:\oracle\product\11.2.0\client_1\orannzsbb11.dllto D:\oracle\product\11.2.0\client_1\bin

Setting 13

Spotlight on Oracle ORA-01017

. After installing Spotlight, enter

-file

-oracle User Wizard

(Next there is a list of those services that have just been configured to select, then the username and password,

User name and password required for SYS user after

Spotlight/spotlight

and use the new user Spotlight to monitor

Ref

Https://www.cnblogs.com/TestWorld/p/5300843.html

http://blog.csdn.net/defonds/article/details/52936664

Spoolight on Oracle Configuration