How to sequence the oracle 11g client with another application?
I get the "Error Msg for DB14Oracle: ORA-12154:TNS:Could not resolve the connect identifier specified." The TnsAdmin environment variable is specified. Trying to create one bubble containing the oracle 11g client and the application. We don't use DSC.
Answers (5)
Have you seen Solution 4 in this link?
http://www.codeproject.com/Questions/57891/Error-ORA-12154-TNS-Could-not-resolve-the-connect
have you tried opening a cmd shell in the bubble and running the command
tnsping [whatever]
to check which ora file is being used for host resolution?
Also I assume you meant the TNS_ADMIN env. variable, with an underscore?
Comments:
-
yes, it is TNS_ADMIN. Tried tnsping <whatever> in a cmd shell inside the bubble, it works. the output was identical for the physical and virtual package. - alberta 12 years ago
The oracle db-name and credentials need to be entered when installing the application that uses oracle client, i.e. when capturing the bubble in the App-V Sequencer 4.6SP1 . Any ideas??
Comments:
-
You can enter the settings db details and credentials too, sequencer will be able to capture. - Visalakshi 11 years ago
The tnsnames.ora file is in a network share \\Share\folder1\folder2\
Comments:
-
I think TNS_ADMIN environmnet variable is pointed network share \Share\folder1\folder2\ in the app-v package. - Visalakshi 11 years ago
Oracle is a one big application which is tough to sequence and on top of that you are trying to create a package along with it in one bubble which means that this Oracle sequence will not be usable with any other application even after you have done a lot of research to solve it.
DSC is a very good option and is made for this reason only. It is not at all difficult to implement. You will just have to make the right settings.
Sequence both applications separately. Install Oracle natively before sequencing the main applicaiton. And then DSC both the sequenced applications.
Comments:
-
be aware though that environment variables set in an App-V package will not get imported when the package is used as a DSC prerequisite, you will have to re-identify the variables in the main package, since only the SFT file gets loaded into the bubble of the main application, not the settings from the OSD file - pjgeutjens 12 years ago