Hi Experts,
We've done the following to access Oracle database using DRS stage.
1. Installed Oracle client
2. Made sure
ORACLE_HOME and PATH variables are set properly in System properties > Environment variables.
3. Open DRS stage properties and hard coded connection name, user details to access database.
4. Able to open sql session using sql client
5. But using DRS stage we are getting the error.
ORA-12154: TNS:could not resolve the connect identifier specified
Tried with OCI stage as well but no luck.
Can someone please suggest anything is missed here.
Thanks
Tirumal
Not able to access Oracle DB using DRS stage in Windows OS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Fri May 16, 2008 3:00 am
- Location: bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 20
- Joined: Fri May 16, 2008 3:00 am
- Location: bangalore
-
- Participant
- Posts: 20
- Joined: Fri May 16, 2008 3:00 am
- Location: bangalore
Any other thoughts? Appreciate your response.
I did search on the error 'TNS:could not resolve the connect identifier specified' in the forum and made sure the below are file.
1. tnsnames.ora has the valid service name
2. Configured ORACLE_HOME and PATH variables to oracle client installation
3. User is able to create a sql session in sql client
Not sure what has missed here.
I did search on the error 'TNS:could not resolve the connect identifier specified' in the forum and made sure the below are file.
1. tnsnames.ora has the valid service name
2. Configured ORACLE_HOME and PATH variables to oracle client installation
3. User is able to create a sql session in sql client
Not sure what has missed here.