Page 1 of 1

regarding installing of server version

Posted: Wed Dec 06, 2006 6:16 pm
by vijaykumar
Hi,

iam working on stand alone system. iam dealing with oracle database.
when i use odbc to connect to oracle, TNS SERVICE CANNOT BE RESOLVED.

i went to services checked the TNS SERVICE and turned on.
went to odbc.ini file and seen it is configured correctly.
searched for dshome directory where the environmental variables are configured, but couldn't find the directory. went to search and typed dshome directory.

can anyone help me in configuring the problem what might went wrong .
why am i getting such type of error
TNS SERVICE name cannot be resolved. There is no dba in my company.

cheers;
vijay

Re: regarding installing of server version

Posted: Wed Dec 06, 2006 6:21 pm
by I_Server_Whale
vijaykumar wrote:Hi,

when i use odbc to connect to oracle, TNS SERVICE CANNOT BE RESOLVED.
Are you able to connect to Oracle normally through SQL plus?

Did you create a system DSN for the database to be used in the ODBC?

Whale.

Posted: Wed Dec 06, 2006 6:27 pm
by vijaykumar
hi,
yaa i was able to connect to oracle normally, but there too i just gave user name and pass word, didn't give the service name ie CONNECTION STRING NAME.I creates DSN but there is no option to check the connection there itself, there is no option to test the connection while creating DSN.

plz gurus help me out.

cheers;
vijay

Posted: Wed Dec 06, 2006 6:32 pm
by I_Server_Whale
vijaykumar wrote:itself, there is no option to test the connection while creating DSN.
I'm very sure that when you create a DSN for an Oracle DB in Windows, you can test the connection.

I'd say you double check.

Whale.

Posted: Wed Dec 06, 2006 7:01 pm
by vijaykumar
hi GURUS;
when creating odbc connection i have given the following parameters.
i have choosen SYSTEM DSN and selected MICROSOFT ODBC DRIVERS FOR ORACLE.

There are options to specify the datasource name, server name, user name and additional options to increase the performance but no options to test the connection.

We are using Oracle 9i, still couldnot resolve the problem.
plz help me out.

cheers;
vijay

Posted: Wed Dec 06, 2006 7:36 pm
by ray.wurlod
There isn't a directory (folder) called DSHOME; that's a short cut (and may, if you set it up, be an environment variable). Location of the directory in question is "whereever you installed the server directory", by default C:\Ascential\DataStage\Engine.

However, on Windows there is no .odbc.ini file - this is for UNIX servers only. In Windows everything is done in the Registry.

Try creating a System DSN using the Data Direct ODBC drivers that ship with DataStage, rather than the Microsoft ODBC drivers.

And make sure that the executing user has the Oracle environment variables, such as ORACLE_HOME, correctly set.

Posted: Thu Dec 07, 2006 6:24 pm
by vijaykumar
hi,
tried hard but couldn't find the $DSHOME DIRECTORY so that i can configure the orahome path.
went to c\ascential\engine.
could find text folders like UVCONFIG,UV.LOGINS,VOC,UV.ACCOUNT,.UVCONFIG.
could find directories like UVTEMP,INCLUDE,DS_LICENSE.
getting error - DSR.METADATA[GET.DSNINFO]
BCI ERROR:SQL STATE=NA600[DATASTAGE][SQL CLINET][ODBC][MICROSOFT]ODBC DRIVER FOR ORACLE][ORACLE]ORA-12541.
TNS:NO LISTENER.

plz help me as i said our company has no dba.plz help me as i never faced such type of problem

cheers;
vijay

Posted: Thu Dec 07, 2006 6:53 pm
by thebird
tried hard but couldn't find the $DSHOME DIRECTORY so that i can configure the orahome path.

You will have to set the ORAHOME path in the dsenv file.

Posted: Thu Dec 07, 2006 7:06 pm
by chulett
There is no dsenv file on a Windows server. That's a UNIX only concept, Windows controls all that via the registry.

Posted: Thu Dec 07, 2006 7:35 pm
by ray.wurlod
You can set environment variables on Windows through Control Panel. Choose the System applet, there's a command button for environment variables. You may need to re-boot (go Microsoft!) for them to take effect.

Posted: Fri Dec 08, 2006 2:07 pm
by vijaykumar
hi,
i could resolve the problem, i didn't configure orahome path.
my listener service file was corrupted, i installed with the other one.
earlier i was using the microsoft drivers for oracle , replaced with the oracle orahome 92 drivers, what makes these difference.

i mean whats make oracle drivers more feasible than microsoft drivers for connecting with oracle.plz help me

cheers;
vijaykumar.