Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
Turns out the Oracle SQL*Plus client doesn't like @ in passwords and if present, the password must be enclosed in "". There was nothing wrong with the tnsnames.ora file or any other settings.. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Thursday, July 10, 2014 3:14 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** or was it 8.1.01.001.0001 or 8.1.01.001.0001.1 LOL !!! too early for friday humor... On Thu, Jul 10, 2014 at 3:03 PM, patrick zandi wrote: got two tricks I learned recently to try... apparently coding and the Q&A might not be the same these days... #1 ar.conf modify the db server name to the followingHOSTNAME,PORT (Yes that is COMMA PORT) because of the underlying JAVA doing the connection. (Don't ask how I did that) #2 SLM issues in the oracle RAC // the actual configurations Remedy built need to be modified cause the use the Rhyme Value:value:value and the oracle rac is looking for value:value\value (Yes it is Value Colon value Slash value ) Weird issues.. I found in 8.1.01 Windows based ARS / ITSM On Thu, Jul 10, 2014 at 1:14 PM, Joe D'Souza wrote: ** @William, I usually (and I did this time too) edit my tnsnames.ora file by hand instead of using the Net Manager or whatever that utility is. So we can rule out the strange invisible character theory I think. @Patrick, I can ping the IP as well as tnsping the server with no problems. I'm not using the hostname but the IP instead, so an entry in the host files is not needed. I'm having our DBA look into this issue as well and they have not yet spotted anything out of the ordinary. Not yet anyways. @Fredrick, The only difference between others who can connect using the oracle user and password (its not a domain or NT account), is that they use corporate hardware so logon to the domain - I use my personal laptop, so I VPN into their network. I've been told that should not make a difference because they do not use any special restrictions that restrict access to only corporate users. As an alternate, I will try to use the Squirrel client that I have never used before in the hope I could at least get that working. I have noticed others using it here and it has a Toad like interface. I'm going to try my luck with that and if that works I'll scratch off my oracle client and rebuild it just in case something has jinxed my SQL*Plus client. Having used SQL*Plus only in the past, I am more comfortable with it but with this problem I'm willing to go with whatever that works. I'll let you'll know if Squirrel solves the connection problems.. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Wednesday, July 09, 2014 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I've seen two different times where the tnsnames.ora file had some type of invisible control character in it and the file would not work. We'd re-type it and try again and it worked - even though the files would be identical to visual inspection and were checked by multiple people. If you're on Unix you might want to run dos2unix on the file. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** Ok . Since you can connect to other databases listed in the TNSNAMES.ORA file that should rule that out Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there is a permissions issue with the user and password you were given. NTS uses Windows native authentication to allow access to a database. If you are specifying a user and password yourself I usually prefer to set this to NONE or comment out that line in the sqlnet.ora file. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 3:25 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** I can connect to other databases whose connection strings are defined in that tnsnames.ora file. So that rules out the client not being able to find the tnsnames.ora file or any permission related issue to that file. I haven't made any changes to the sqlnet.ora file. The only two non commented lines in it are: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Cheers _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARS
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
or was it 8.1.01.001.0001 or 8.1.01.001.0001.1 LOL !!! too early for friday humor... On Thu, Jul 10, 2014 at 3:03 PM, patrick zandi wrote: > got two tricks I learned recently to try... apparently coding and the Q&A > might not be the same these days... > #1 > ar.conf > modify the db server name to the followingHOSTNAME,PORT (Yes that > is COMMA PORT) because of the underlying JAVA doing the connection. > > (Don't ask how I did that) > > #2 SLM issues in the oracle RAC // the actual configurations Remedy built > need to be modified cause the use the Rhyme Value:value:value and the > oracle rac is looking for > value:value\value (Yes it is Value Colon value Slash value ) > > Weird issues.. I found in 8.1.01 Windows based ARS / ITSM > > > > On Thu, Jul 10, 2014 at 1:14 PM, Joe D'Souza wrote: > >> ** >> >> @William, >> >> I usually (and I did this time too) edit my tnsnames.ora file by hand >> instead of using the Net Manager or whatever that utility is. So we can >> rule out the strange invisible character theory I think. >> >> >> >> @Patrick, >> >> I can ping the IP as well as tnsping the server with no problems. I’m not >> using the hostname but the IP instead, so an entry in the host files is not >> needed. I’m having our DBA look into this issue as well and they have not >> yet spotted anything out of the ordinary. Not yet anyways. >> >> >> >> @Fredrick, >> >> The only difference between others who can connect using the oracle user >> and password (its not a domain or NT account), is that they use corporate >> hardware so logon to the domain – I use my personal laptop, so I VPN into >> their network. I’ve been told that should not make a difference because >> they do not use any special restrictions that restrict access to only >> corporate users. >> >> >> >> As an alternate, I will try to use the Squirrel client that I have never >> used before in the hope I could at least get that working. I have noticed >> others using it here and it has a Toad like interface. I’m going to try my >> luck with that and if that works I’ll scratch off my oracle client and >> rebuild it just in case something has jinxed my SQL*Plus client. Having >> used SQL*Plus only in the past, I am more comfortable with it but with this >> problem I’m willing to go with whatever that works. I’ll let you’ll know if >> Squirrel solves the connection problems.. >> >> >> >> Joe >> >> >> -- >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *William Rentfrow >> *Sent:* Wednesday, July 09, 2014 4:58 PM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle >> Database.. >> >> >> >> I've seen two different times where the tnsnames.ora file had some type >> of invisible control character in it and the file would not work. >> >> >> >> We'd re-type it and try again and it worked - even though the files would >> be identical to visual inspection and were checked by multiple people. >> >> >> >> If you're on Unix you might want to run dos2unix on the file. >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >> *Sent:* Wednesday, July 09, 2014 3:51 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle >> Database.. >> >> >> >> ** >> >> Ok … Since you can connect to other databases listed in the TNSNAMES.ORA >> file that should rule that out >> >> >> >> Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there >> is a permissions issue with the user and password you were given. >> >> >> >> NTS uses Windows native authentication to allow access to a database. If >> you are specifying a user and password yourself I usually prefer to set >> this to NONE or comment out that line in the sqlnet.ora file. >> >> >> >> Fred >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza >> *Sent:* Wednesday, July 09, 2014 3:25 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle >> Database.. >> >> >> >&
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
got two tricks I learned recently to try... apparently coding and the Q&A might not be the same these days... #1 ar.conf modify the db server name to the followingHOSTNAME,PORT (Yes that is COMMA PORT) because of the underlying JAVA doing the connection. (Don't ask how I did that) #2 SLM issues in the oracle RAC // the actual configurations Remedy built need to be modified cause the use the Rhyme Value:value:value and the oracle rac is looking for value:value\value (Yes it is Value Colon value Slash value ) Weird issues.. I found in 8.1.01 Windows based ARS / ITSM On Thu, Jul 10, 2014 at 1:14 PM, Joe D'Souza wrote: > ** > > @William, > > I usually (and I did this time too) edit my tnsnames.ora file by hand > instead of using the Net Manager or whatever that utility is. So we can > rule out the strange invisible character theory I think. > > > > @Patrick, > > I can ping the IP as well as tnsping the server with no problems. I’m not > using the hostname but the IP instead, so an entry in the host files is not > needed. I’m having our DBA look into this issue as well and they have not > yet spotted anything out of the ordinary. Not yet anyways. > > > > @Fredrick, > > The only difference between others who can connect using the oracle user > and password (its not a domain or NT account), is that they use corporate > hardware so logon to the domain – I use my personal laptop, so I VPN into > their network. I’ve been told that should not make a difference because > they do not use any special restrictions that restrict access to only > corporate users. > > > > As an alternate, I will try to use the Squirrel client that I have never > used before in the hope I could at least get that working. I have noticed > others using it here and it has a Toad like interface. I’m going to try my > luck with that and if that works I’ll scratch off my oracle client and > rebuild it just in case something has jinxed my SQL*Plus client. Having > used SQL*Plus only in the past, I am more comfortable with it but with this > problem I’m willing to go with whatever that works. I’ll let you’ll know if > Squirrel solves the connection problems.. > > > > Joe > > > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *William Rentfrow > *Sent:* Wednesday, July 09, 2014 4:58 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle > Database.. > > > > I've seen two different times where the tnsnames.ora file had some type of > invisible control character in it and the file would not work. > > > > We'd re-type it and try again and it worked - even though the files would > be identical to visual inspection and were checked by multiple people. > > > > If you're on Unix you might want to run dos2unix on the file. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > *Sent:* Wednesday, July 09, 2014 3:51 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle > Database.. > > > > ** > > Ok … Since you can connect to other databases listed in the TNSNAMES.ORA > file that should rule that out > > > > Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there is > a permissions issue with the user and password you were given. > > > > NTS uses Windows native authentication to allow access to a database. If > you are specifying a user and password yourself I usually prefer to set > this to NONE or comment out that line in the sqlnet.ora file. > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza > *Sent:* Wednesday, July 09, 2014 3:25 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle > Database.. > > > > ** > > I can connect to other databases whose connection strings are defined in > that tnsnames.ora file. So that rules out the client not being able to find > the tnsnames.ora file or any permission related issue to that file. > > > > I haven’t made any changes to the sqlnet.ora file. The only two non > commented lines in it are: > > > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) > > > > Cheers > > > > > > > -- > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG ] *On Be
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
@William, I usually (and I did this time too) edit my tnsnames.ora file by hand instead of using the Net Manager or whatever that utility is. So we can rule out the strange invisible character theory I think. @Patrick, I can ping the IP as well as tnsping the server with no problems. I'm not using the hostname but the IP instead, so an entry in the host files is not needed. I'm having our DBA look into this issue as well and they have not yet spotted anything out of the ordinary. Not yet anyways. @Fredrick, The only difference between others who can connect using the oracle user and password (its not a domain or NT account), is that they use corporate hardware so logon to the domain - I use my personal laptop, so I VPN into their network. I've been told that should not make a difference because they do not use any special restrictions that restrict access to only corporate users. As an alternate, I will try to use the Squirrel client that I have never used before in the hope I could at least get that working. I have noticed others using it here and it has a Toad like interface. I'm going to try my luck with that and if that works I'll scratch off my oracle client and rebuild it just in case something has jinxed my SQL*Plus client. Having used SQL*Plus only in the past, I am more comfortable with it but with this problem I'm willing to go with whatever that works. I'll let you'll know if Squirrel solves the connection problems.. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Wednesday, July 09, 2014 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I've seen two different times where the tnsnames.ora file had some type of invisible control character in it and the file would not work. We'd re-type it and try again and it worked - even though the files would be identical to visual inspection and were checked by multiple people. If you're on Unix you might want to run dos2unix on the file. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** Ok . Since you can connect to other databases listed in the TNSNAMES.ORA file that should rule that out Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there is a permissions issue with the user and password you were given. NTS uses Windows native authentication to allow access to a database. If you are specifying a user and password yourself I usually prefer to set this to NONE or comment out that line in the sqlnet.ora file. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 3:25 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** I can connect to other databases whose connection strings are defined in that tnsnames.ora file. So that rules out the client not being able to find the tnsnames.ora file or any permission related issue to that file. I haven't made any changes to the sqlnet.ora file. The only two non commented lines in it are: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Cheers _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have that environment variable pointing to the folder where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in general) use this environment variable to find the tnsnames.ora configuration file. Another possible reason could be a default domain setting. In your Oracle Client configuration do you have an SQLNET.ORA configuration file that defines? names.default_domain = world In those cases the TNSNAMES entry wanted to be: CONNENTRY.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) And then my login using SQLPLUS would be sqlplus user@ <mailto:user@CONNENTRY.WORLD> CONNENTRY.WORLD Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 10:44 AM To
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
I've seen two different times where the tnsnames.ora file had some type of invisible control character in it and the file would not work. We'd re-type it and try again and it worked - even though the files would be identical to visual inspection and were checked by multiple people. If you're on Unix you might want to run dos2unix on the file. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 3:51 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** Ok ... Since you can connect to other databases listed in the TNSNAMES.ORA file that should rule that out Since you have SQLNET.AUTHENTICATION_SERVICES= (NTS) I wonder if there is a permissions issue with the user and password you were given. NTS uses Windows native authentication to allow access to a database. If you are specifying a user and password yourself I usually prefer to set this to NONE or comment out that line in the sqlnet.ora file. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 3:25 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** I can connect to other databases whose connection strings are defined in that tnsnames.ora file. So that rules out the client not being able to find the tnsnames.ora file or any permission related issue to that file. I haven't made any changes to the sqlnet.ora file. The only two non commented lines in it are: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Cheers From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 12:20 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have that environment variable pointing to the folder where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in general) use this environment variable to find the tnsnames.ora configuration file. Another possible reason could be a default domain setting. In your Oracle Client configuration do you have an SQLNET.ORA configuration file that defines? names.default_domain = world In those cases the TNSNAMES entry wanted to be: CONNENTRY.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) And then my login using SQLPLUS would be sqlplus user@CONNENTRY.WORLD<mailto:user@CONNENTRY.WORLD> Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 10:44 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier specified I have checked my tnsnames.ora file for any possible errors in the connection string and can't seem to find one. This is the contents of the entry (I have replaced the actual IP and the service name and what not with fictitious names for security reasons - the port is 1521 which is the default port.) ## Remedy ITSM db - Devl - Used IP instead of hostname CONNENTRY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) While connecting I use the username & password as given to me and connentry as the host string. What could possibly be the causes of ORA-12154 that I ought to check for? I suspect something wrong with my connection string in my tnsnames.ora file but can't figure what it is. I checked with the DBA's for the exact IP, port, service name and they say it all checks out. I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be compatible with Oracle Database version 11.2.0.3.0, but I do not think that could be the problem as Oracle clients are usually compatible with at least 1 version forward or backward. Any insights as to what I and my DBA's may be missing may help.. Thanks.. Joe No virus found in this message. Checked by AVG - www.avg.
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
IF you are using the ORACE_RAC we have found some additional settings in the TNSNAMES.ora need to be applied AND you have some additional settings you have to modify in the SLM module, due to the fact that remedy wrote the code to do it static like name:sid:table or something like that... hope that helps some. On Wed, Jul 9, 2014 at 4:42 PM, patrick zandi wrote: > Sorry got interupted, then ensure your /etc/hosts file has the ip address > do a tnsping first > using the oracle tnsnames.ora > > > > On Wed, Jul 9, 2014 at 4:41 PM, patrick zandi wrote: > >> you need to set your ORACLE_HOME variable / your ORACLE_SID and your >> ORACLE_UNIQUE variable. >> then the application should work. >> >> >> >> On Wed, Jul 9, 2014 at 4:25 PM, Joe D'Souza wrote: >> >>> ** >>> >>> I can connect to other databases whose connection strings are defined in >>> that tnsnames.ora file. So that rules out the client not being able to find >>> the tnsnames.ora file or any permission related issue to that file. >>> >>> >>> >>> I haven’t made any changes to the sqlnet.ora file. The only two non >>> commented lines in it are: >>> >>> >>> >>> SQLNET.AUTHENTICATION_SERVICES= (NTS) >>> >>> >>> >>> NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) >>> >>> >>> >>> Cheers >>> >>> >>> >>> >>> >>> >>> -- >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >>> >>> *Sent:* Wednesday, July 09, 2014 12:20 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle >>> Database.. >>> >>> >>> >>> I can think of 2 possible reasons off the top of my head. >>> >>> >>> >>> One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do >>> you have an environment variable of TNS_ADMIN? >>> >>> In my systems I have that environment variable pointing to the folder >>> where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in >>> general) use this environment variable to find the tnsnames.ora >>> configuration file. >>> >>> >>> >>> Another possible reason could be a default domain setting. >>> >>> In your Oracle Client configuration do you have an SQLNET.ORA >>> configuration file that defines? >>> >>> names.default_domain = world >>> >>> >>> >>> In those cases the TNSNAMES entry wanted to be: >>> >>> CONNENTRY.WORLD = >>> >>> (DESCRIPTION = >>> >>> (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) >>> >>> (CONNECT_DATA = >>> >>> (SERVER = DEDICATED) >>> >>> (SERVICE_NAME = connentry) >>> >>> ) >>> >>> ) >>> >>> >>> >>> And then my login using SQLPLUS would be >>> >>> sqlplus user@CONNENTRY.WORLD >>> >>> >>> >>> Fred >>> >>> >>> >>> >>> >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza >>> *Sent:* Wednesday, July 09, 2014 10:44 AM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Slightly OT: Connecting SQL*Plus client to an Oracle >>> Database.. >>> >>> >>> >>> ** >>> >>> We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production >>> server. >>> >>> >>> >>> I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am >>> unable to connect with a connection error that reads as: >>> >>> >>> >>> ORA-12154: TNS:could not resolve the connect identifier specified >>> >>> >>> >>> I have checked my tnsnames.ora file for any possible errors in the >>> connection string and can’t seem to find one. This is the contents of the >>> entry (I have replaced the actual IP and the service name and what not >>> with fictitious names for security reasons – the port is 1521 which is the >>> default port.) >>> >>> >>> >>> ## Remedy ITSM db - Devl - Used
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
Sorry got interupted, then ensure your /etc/hosts file has the ip address do a tnsping first using the oracle tnsnames.ora On Wed, Jul 9, 2014 at 4:41 PM, patrick zandi wrote: > you need to set your ORACLE_HOME variable / your ORACLE_SID and your > ORACLE_UNIQUE variable. > then the application should work. > > > > On Wed, Jul 9, 2014 at 4:25 PM, Joe D'Souza wrote: > >> ** >> >> I can connect to other databases whose connection strings are defined in >> that tnsnames.ora file. So that rules out the client not being able to find >> the tnsnames.ora file or any permission related issue to that file. >> >> >> >> I haven’t made any changes to the sqlnet.ora file. The only two non >> commented lines in it are: >> >> >> >> SQLNET.AUTHENTICATION_SERVICES= (NTS) >> >> >> >> NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) >> >> >> >> Cheers >> >> >> >> >> >> >> -- >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W >> >> *Sent:* Wednesday, July 09, 2014 12:20 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle >> Database.. >> >> >> >> I can think of 2 possible reasons off the top of my head. >> >> >> >> One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you >> have an environment variable of TNS_ADMIN? >> >> In my systems I have that environment variable pointing to the folder >> where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in >> general) use this environment variable to find the tnsnames.ora >> configuration file. >> >> >> >> Another possible reason could be a default domain setting. >> >> In your Oracle Client configuration do you have an SQLNET.ORA >> configuration file that defines? >> >> names.default_domain = world >> >> >> >> In those cases the TNSNAMES entry wanted to be: >> >> CONNENTRY.WORLD = >> >> (DESCRIPTION = >> >> (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) >> >> (CONNECT_DATA = >> >> (SERVER = DEDICATED) >> >> (SERVICE_NAME = connentry) >> >> ) >> >> ) >> >> >> >> And then my login using SQLPLUS would be >> >> sqlplus user@CONNENTRY.WORLD >> >> >> >> Fred >> >> >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza >> *Sent:* Wednesday, July 09, 2014 10:44 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Slightly OT: Connecting SQL*Plus client to an Oracle >> Database.. >> >> >> >> ** >> >> We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production >> server. >> >> >> >> I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am >> unable to connect with a connection error that reads as: >> >> >> >> ORA-12154: TNS:could not resolve the connect identifier specified >> >> >> >> I have checked my tnsnames.ora file for any possible errors in the >> connection string and can’t seem to find one. This is the contents of the >> entry (I have replaced the actual IP and the service name and what not >> with fictitious names for security reasons – the port is 1521 which is the >> default port.) >> >> >> >> ## Remedy ITSM db - Devl - Used IP instead of hostname >> >> CONNENTRY = >> >> (DESCRIPTION = >> >> (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) >> >> (CONNECT_DATA = >> >> (SERVER = DEDICATED) >> >> (SERVICE_NAME = connentry) >> >> ) >> >> ) >> >> >> >> While connecting I use the username & password as given to me and >> connentry as the host string. >> >> >> >> What could possibly be the causes of ORA-12154 that I ought to check for? >> I suspect something wrong with my connection string in my tnsnames.ora file >> but can’t figure what it is. I checked with the DBA’s for the exact IP, >> port, service name and they say it all checks out. >> >> >> >> I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be >> compatible with Oracle Database version 11.2.0.3.0, but I do not think that >> could be the problem as Oracle clients are usually compatible with at least >> 1 version forward or backward. >> >> >> >> >> >> Any insights as to what I and my DBA’s may be missing may help.. >> >> >> >> Thanks.. >> >> >> >> Joe >> >> >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: >> "Where the Answers Are" and have been for 20 years_ > > > > > -- > Patrick Zandi > -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
you need to set your ORACLE_HOME variable / your ORACLE_SID and your ORACLE_UNIQUE variable. then the application should work. On Wed, Jul 9, 2014 at 4:25 PM, Joe D'Souza wrote: > ** > > I can connect to other databases whose connection strings are defined in > that tnsnames.ora file. So that rules out the client not being able to find > the tnsnames.ora file or any permission related issue to that file. > > > > I haven’t made any changes to the sqlnet.ora file. The only two non > commented lines in it are: > > > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) > > > > Cheers > > > > > > > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > > *Sent:* Wednesday, July 09, 2014 12:20 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle > Database.. > > > > I can think of 2 possible reasons off the top of my head. > > > > One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you > have an environment variable of TNS_ADMIN? > > In my systems I have that environment variable pointing to the folder > where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in > general) use this environment variable to find the tnsnames.ora > configuration file. > > > > Another possible reason could be a default domain setting. > > In your Oracle Client configuration do you have an SQLNET.ORA > configuration file that defines? > > names.default_domain = world > > > > In those cases the TNSNAMES entry wanted to be: > > CONNENTRY.WORLD = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = connentry) > > ) > > ) > > > > And then my login using SQLPLUS would be > > sqlplus user@CONNENTRY.WORLD > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza > *Sent:* Wednesday, July 09, 2014 10:44 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Slightly OT: Connecting SQL*Plus client to an Oracle Database.. > > > > ** > > We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. > > > > I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am > unable to connect with a connection error that reads as: > > > > ORA-12154: TNS:could not resolve the connect identifier specified > > > > I have checked my tnsnames.ora file for any possible errors in the > connection string and can’t seem to find one. This is the contents of the > entry (I have replaced the actual IP and the service name and what not > with fictitious names for security reasons – the port is 1521 which is the > default port.) > > > > ## Remedy ITSM db - Devl - Used IP instead of hostname > > CONNENTRY = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = connentry) > > ) > > ) > > > > While connecting I use the username & password as given to me and > connentry as the host string. > > > > What could possibly be the causes of ORA-12154 that I ought to check for? > I suspect something wrong with my connection string in my tnsnames.ora file > but can’t figure what it is. I checked with the DBA’s for the exact IP, > port, service name and they say it all checks out. > > > > I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be > compatible with Oracle Database version 11.2.0.3.0, but I do not think that > could be the problem as Oracle clients are usually compatible with at least > 1 version forward or backward. > > > > > > Any insights as to what I and my DBA’s may be missing may help.. > > > > Thanks.. > > > > Joe > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: > "Where the Answers Are" and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
I can connect to other databases whose connection strings are defined in that tnsnames.ora file. So that rules out the client not being able to find the tnsnames.ora file or any permission related issue to that file. I haven't made any changes to the sqlnet.ora file. The only two non commented lines in it are: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) Cheers _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, July 09, 2014 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. I can think of 2 possible reasons off the top of my head. One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you have an environment variable of TNS_ADMIN? In my systems I have that environment variable pointing to the folder where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in general) use this environment variable to find the tnsnames.ora configuration file. Another possible reason could be a default domain setting. In your Oracle Client configuration do you have an SQLNET.ORA configuration file that defines? names.default_domain = world In those cases the TNSNAMES entry wanted to be: CONNENTRY.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) And then my login using SQLPLUS would be sqlplus user@CONNENTRY.WORLD Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, July 09, 2014 10:44 AM To: arslist@ARSLIST.ORG Subject: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier specified I have checked my tnsnames.ora file for any possible errors in the connection string and can't seem to find one. This is the contents of the entry (I have replaced the actual IP and the service name and what not with fictitious names for security reasons - the port is 1521 which is the default port.) ## Remedy ITSM db - Devl - Used IP instead of hostname CONNENTRY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) While connecting I use the username & password as given to me and connentry as the host string. What could possibly be the causes of ORA-12154 that I ought to check for? I suspect something wrong with my connection string in my tnsnames.ora file but can't figure what it is. I checked with the DBA's for the exact IP, port, service name and they say it all checks out. I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be compatible with Oracle Database version 11.2.0.3.0, but I do not think that could be the problem as Oracle clients are usually compatible with at least 1 version forward or backward. Any insights as to what I and my DBA's may be missing may help.. Thanks.. Joe _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
The only other person I know who actively connects to the database using a Oracle client uses the Squirrel client to connect & having not ever used that client before didn't want to 'try something new'. I did take the connection string they use there and translated it to the format that SQL*Plus requires so I'm pretty sure there should not be any problem with that. Thanks for your response. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Hicox Sent: Wednesday, July 09, 2014 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** Can anyone else connect to the DB without being on localhost with it? If no other remote client can connect, maybe the listener isn't running? Also if others can connect, try copying their tnsnames.ora file Andy On Wednesday, July 9, 2014, Joe D'Souza wrote: ** We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable to connect with a connection error that reads as: ORA-12154: TNS:could not resolve the connect identifier specified I have checked my tnsnames.ora file for any possible errors in the connection string and can't seem to find one. This is the contents of the entry (I have replaced the actual IP and the service name and what not with fictitious names for security reasons - the port is 1521 which is the default port.) ## Remedy ITSM db - Devl - Used IP instead of hostname CONNENTRY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = connentry) ) ) While connecting I use the username & password as given to me and connentry as the host string. What could possibly be the causes of ORA-12154 that I ought to check for? I suspect something wrong with my connection string in my tnsnames.ora file but can't figure what it is. I checked with the DBA's for the exact IP, port, service name and they say it all checks out. I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be compatible with Oracle Database version 11.2.0.3.0, but I do not think that could be the problem as Oracle clients are usually compatible with at least 1 version forward or backward. Any insights as to what I and my DBA's may be missing may help.. Thanks.. Joe _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
Can anyone else connect to the DB without being on localhost with it? If no other remote client can connect, maybe the listener isn't running? Also if others can connect, try copying their tnsnames.ora file Andy On Wednesday, July 9, 2014, Joe D'Souza wrote: > ** > > We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. > > > > I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am > unable to connect with a connection error that reads as: > > > > ORA-12154: TNS:could not resolve the connect identifier specified > > > > I have checked my tnsnames.ora file for any possible errors in the > connection string and can’t seem to find one. This is the contents of the > entry (I have replaced the actual IP and the service name and what not > with fictitious names for security reasons – the port is 1521 which is the > default port.) > > > > ## Remedy ITSM db - Devl - Used IP instead of hostname > > CONNENTRY = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = connentry) > > ) > > ) > > > > While connecting I use the username & password as given to me and > connentry as the host string. > > > > What could possibly be the causes of ORA-12154 that I ought to check for? > I suspect something wrong with my connection string in my tnsnames.ora file > but can’t figure what it is. I checked with the DBA’s for the exact IP, > port, service name and they say it all checks out. > > > > I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be > compatible with Oracle Database version 11.2.0.3.0, but I do not think that > could be the problem as Oracle clients are usually compatible with at least > 1 version forward or backward. > > > > > > Any insights as to what I and my DBA’s may be missing may help.. > > > > Thanks.. > > > > Joe > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database..
Hi Joe, Kindly do a tnsping of your service_name. Possible cause is that you cant reach your destination host. Please also try to do a telnet test to the host ip with the port 1521 to make sure that the port is open on the fw. Regards, Wesley > On 9 Jul, 2014, at 11:43 pm, Joe D'Souza wrote: > > ** > We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. > > I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable > to connect with a connection error that reads as: > > ORA-12154: TNS:could not resolve the connect identifier specified > > I have checked my tnsnames.ora file for any possible errors in the connection > string and can’t seem to find one. This is the contents of the entry (I have > replaced the actual IP and the service name and what not with fictitious > names for security reasons – the port is 1521 which is the default port.) > > ## Remedy ITSM db - Devl - Used IP instead of hostname > CONNENTRY = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = connentry) > ) > ) > > While connecting I use the username & password as given to me and connentry > as the host string. > > What could possibly be the causes of ORA-12154 that I ought to check for? I > suspect something wrong with my connection string in my tnsnames.ora file but > can’t figure what it is. I checked with the DBA’s for the exact IP, port, > service name and they say it all checks out. > > I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be > compatible with Oracle Database version 11.2.0.3.0, but I do not think that > could be the problem as Oracle clients are usually compatible with at least 1 > version forward or backward. > > > Any insights as to what I and my DBA’s may be missing may help.. > > Thanks.. > > Joe > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"