you need to open the config object dictionary and add the tnsnames.ora file there.
the change you made below should only affect blquery running from the appserver, from the commandline.
Where Can I find the config object dictionary ?
In the Config Manager GUI under Tools
I got it anda I add ??TARGET.ORACLE_HOME???/NETWORK/ADMIN/tnsnames.ora
just a few question questions :
How can I verify is the work is good ?
I see the ??TARGET.ORACLE_HOME???
what is it the value of this variable ?
How can I see it ?
Each Oracle Installation has its own Oracle Home.
On Windows, Oracle instance information is stored in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE. You should see all the instances, and the ORACLE_HOME will be define in there.
On Unix, look in either /etc/oratab or /var/opt/oracle/oratab and you will find a list of instances. The Oracle home is the 2nd parameter here.
Once you find the right ORACLE_HOME, in BladeLogic, right click on the server, and set the ORACLE_HOME property to be the path that you want.
On Windows, you should use /c/my/oracle/home rather than c:\my\oracle\home
now the tnsnames.ora appear in the configuration files list.
... but :( ....
when I use this command:
blquert -h hostname -e 'config_record_count ("/C/oracle/ora92/network/ADMIN/tnsnames.ora")'
I got always 0 (zero)
... but the files contains just 1 record
I add the ora.gm that I'm using.
Can you help me ?
ora.gm.txt 1.3 K
These are 2 different things:
1 is what you see in the gui. this is controlled by the configuration object dictionary.
2 is what blquery sees. i believe this is controlled by the 'index' file entries on the system that blquery is running from.
I'm working on the bladelogic console server .
I run the BladeLogic console Manger and I modified the object dictionary
adding the definition ??TARGET.ORACLE_HOME???/NETWORK/ADMIN/tnsnames.ora
On this server i modified the index file in script folder and
I add at the end of the index file the rule
WindowsNT *.ora ora.gm
and at this time the tnsnames.ora appear in the Live/Configuration
section of the server svzvraclc04w3
Then on the console server I open a Network shell and I run
blquery -h svzvraclc04w3 -e 'config_record_count ("/C/oracle/ora92/network/ADMIN/tnsnames.ora")'
this command return 0 (zero)
I hope had explain better the situation and the steps that
I followed , because I didn't understand your questions.