ERROR ORA-12154 TNS: could not resolve the connect identifierspecified

#51

On Wed, 15 Oct 2008 13:21:34 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Quote:

Calm down Sybrand! There is only one tnsname.ora on a server (It is
easy to find - sorry I didn't tell you that up front!) do you have
idea or NO answer or DON"T know the answer. if it is not so difficult,
just show your knowledge about it. Thanks much,

The file should have been called tnsnames.ora.
I can't resolve your problem, as you are unwillling read my answers
and to provide answers to the questions I asked.
This is typically for developers, they are usually not hired because
they are industrious, but because they are lazy and cheap and easily
laid off.

--
Sybrand Bakker
Senior Oracle DBA

#52

On Wed, 15 Oct 2008 13:21:34 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Quote:

Calm down Sybrand! There is only one tnsname.ora on a server (It is
easy to find - sorry I didn't tell you that up front!) do you have
idea or NO answer or DON"T know the answer. if it is not so difficult,
just show your knowledge about it. Thanks much,

The file should have been called tnsnames.ora.
I can't resolve your problem, as you are unwillling read my answers
and to provide answers to the questions I asked.
This is typically for developers, they are usually not hired because
they are industrious, but because they are lazy and cheap and easily
laid off.

--
Sybrand Bakker
Senior Oracle DBA

#53

On Wed, 15 Oct 2008 13:21:34 -0700 (PDT), beta <qlng2000 (AT) gmail (DOT) com>
wrote:

Quote:

Calm down Sybrand! There is only one tnsname.ora on a server (It is
easy to find - sorry I didn't tell you that up front!) do you have
idea or NO answer or DON"T know the answer. if it is not so difficult,
just show your knowledge about it. Thanks much,

The file should have been called tnsnames.ora.
I can't resolve your problem, as you are unwillling read my answers
and to provide answers to the questions I asked.
This is typically for developers, they are usually not hired because
they are industrious, but because they are lazy and cheap and easily
laid off.

--
Sybrand Bakker
Senior Oracle DBA

#54

beta wrote:

Quote:

I am a developer consultant ! it is a serious issue for me.
The error message (ORA-12154: TNS:could not resolve the connect
identifier specified) like the environment is not correct setup for a
web. What I've done was create a new startup web sript

*****************************
#/bin/sh
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
export ORACLE_SID=demo
export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1/lib
export TNS_ADMIN=/opt/app/oracle/product/11.1.0/db_1/network/admin
Odd... you tnsping uses

/u01/app/oracle/product/11.1.0/db_1/network/admin/
--

Regards,
Frank van Bortel

#55

beta wrote:

Quote:

I am a developer consultant ! it is a serious issue for me.
The error message (ORA-12154: TNS:could not resolve the connect
identifier specified) like the environment is not correct setup for a
web. What I've done was create a new startup web sript

*****************************
#/bin/sh
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
export ORACLE_SID=demo
export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1/lib
export TNS_ADMIN=/opt/app/oracle/product/11.1.0/db_1/network/admin
Odd... you tnsping uses

/u01/app/oracle/product/11.1.0/db_1/network/admin/
--

Regards,
Frank van Bortel

#56

beta wrote:

Quote:

I am a developer consultant ! it is a serious issue for me.
The error message (ORA-12154: TNS:could not resolve the connect
identifier specified) like the environment is not correct setup for a
web. What I've done was create a new startup web sript

*****************************
#/bin/sh
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
export ORACLE_SID=demo
export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1/lib
export TNS_ADMIN=/opt/app/oracle/product/11.1.0/db_1/network/admin
Odd... you tnsping uses

/u01/app/oracle/product/11.1.0/db_1/network/admin/
--

Regards,
Frank van Bortel

#57

beta wrote:

Quote:

I am a developer consultant ! it is a serious issue for me.
The error message (ORA-12154: TNS:could not resolve the connect
identifier specified) like the environment is not correct setup for a
web. What I've done was create a new startup web sript

*****************************
#/bin/sh
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
export ORACLE_SID=demo
export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1/lib
export TNS_ADMIN=/opt/app/oracle/product/11.1.0/db_1/network/admin
Odd... you tnsping uses

/u01/app/oracle/product/11.1.0/db_1/network/admin/
--

Regards,
Frank van Bortel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ERROR ORA-12154 TNS: could not resolve the connect identifierspecified

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified - 10-16-2008 , 12:21 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified - 10-16-2008 , 12:21 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifier specified - 10-16-2008 , 12:21 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifierspecified - 10-16-2008 , 01:31 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifierspecified - 10-16-2008 , 01:31 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifierspecified - 10-16-2008 , 01:31 PM

Re: ERROR ORA-12154 TNS: could not resolve the connect identifierspecified - 10-16-2008 , 01:31 PM