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
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 wrot
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 databas
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 the
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
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 S
SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>
>>
>>
>> NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
>>
>>
>>
>> Cheers
>>
>>
>>
>>
>>
>>
>> --
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>
t;>
>>>
>>> Cheers
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>> arslist@ARSLIST.ORG] *On Behalf O
oe 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 fi
n 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 se
* 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..
>
>
>
>
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
ist@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,
13 matches
Mail list logo