ORA-12154: TNS:could not resolve service name Post: 302369620

10 More Discussions You Might Find Interesting

1. Linux

Try thousand times could not resolve famous ORA-12514 error

It is related to Linux, Oracle 9.2.0. I am new to Oracle. I am trying to connect to Oracle database say A, but as I am running this command dbstart the error is �ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor� I have successfully started lsnrctl. Here...

2. Linux

After famous ORA-12514 error, another erro TNS-12535

Recently I was struggling to resolve ORA-12514 error, after I solved that there is a another error "TNS-12535: TNS: operation timed out". For your information in my machine I have disabled firewall & also added SQLNET.EXPIRE_TIME = 10. But the problem is still persists. Again all your help is...

3. Shell Programming and Scripting

Need to capture the service name from tnsnames.ora and create connect string

ghkjkjoj

4. UNIX for Advanced & Expert Users

TNS no listener error when connecting to a new DB

Hi all We connect to 10 Oracle Databases from our UNIX box through the regular TNS file we have on any oracle client installation. Recently we acquired a new connection. I added the entries as usual to the TNS file. The connection fails with the below error message ORA-12541: TNS:no...

5. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:...

6. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command? In following "grep" command I want to exclude "ORA-01653" error grep -i ORA alert.log >>/tmp/ora_errors.txt ...

7. Red Hat

TNS Timeout Error when connecting to SQLPLUS through scripts only

Hi, I am facing a strange issue when connecting to SQLPLUS via a shell scripts. I am using Linux 2.6.18-274.18.1 and gbash shell. When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when...

8. Shell Programming and Scripting

Grep all lines with the string "TNS-" but skip those with "TNS-12514"

Platform: Oracle Linux 6.3 From a log file, I want to grep all lines with the pattern "TNS-" but I want to skip those with the pattern "TNS-12514" . How can I do this ?

9. Shell Programming and Scripting

Replacing old TNS entries with New one in multiple files

I have requirement to replace old TNS entries with New one in multiple files. one file may contain more then one occurrence of tns. Example: Below is the one of occurrence in a current file(s). i am interested to replace only red part. <connection-pool name="Google_APP_CP"...

10. Red Hat

Ora-27603:ora-27626:

Hi, User claim that job is running slow from their end. I DBA found in database the below errors in alert log file. ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576 ORA-27626: Exadata error: 2201 (IO...

LEARN ABOUT OSX

tcp-environ

tcp-environ(5)							File Formats Manual						    tcp-environ(5)

NAME

       tcp-environ - TCP-related environment variables

DESCRIPTION

       The  following environment variables describe a TCP connection.	They are set up by tcp-env, tcpclient, and tcpserver.  Note that TCPLOCAL-
       HOST, TCPREMOTEHOST, and TCPREMOTEINFO can contain arbitrary characters.

       PROTO
	    The string TCP.

       TCPLOCALHOST
	    The domain name of the local host, with uppercase letters converted to lowercase.  If there is no currently available domain name  for
	    the local IP address, TCPLOCALHOST is not set.

       TCPLOCALIP
	    The IP address of the local host, in dotted-decimal form.

       TCPLOCALPORT
	    The local TCP port number, in decimal.

       TCPREMOTEHOST
	    The domain name of the remote host, with uppercase letters converted to lowercase.	If there is no currently available domain name for
	    the remote IP address, TCPREMOTEHOST is not set.

       TCPREMOTEINFO
	    A connection-specific string, perhaps a username, supplied by the remote host via 931/1413/IDENT/TAP.  If the remote host did not sup-
	    ply connection information, TCPREMOTEINFO is not set.

       TCPREMOTEIP
	    The IP address of the remote host.

       TCPREMOTEPORT
	    The remote TCP port number.

SEE ALSO

       tcpclient(1), tcpserver(1), tcp-env(1), tcp(4)

																    tcp-environ(5)