Date:         Thu, 26 Jan 2012 01:27:15 -0500
Reply-To:     Søren Lassen <s.lassen@POST.TELE.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Søren Lassen <s.lassen@POST.TELE.DK>
Subject:      Re: SAS :: ERROR: ORACLE connection error: ORA-12154: TNS:could
              not resolve the connect identifier specified
Comments: To: Abu Zafar muyeen <muyeen70@HOTMAIL.COM>
Content-Type: text/plain; charset=ISO-8859-1

Abu,
The problem is that Oracle cannot find the path. Apart from the ideas
already mentioned, the problem may simply be that the Oracle database that
you want to connect to is not up and running at the moment.

Regards,
Søren


On Wed, 25 Jan 2012 15:17:40 +0000, abu zafar muyeen <muyeen70@HOTMAIL.COM>
wrote:

>Hi,
>i am running this following code : and the error message : ERROR: ORACLE
connection error: ORA-12154: TNS:could not resolve the connect identifier
specified.
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>proc sql;
> connect to oracle(path='XXXX' user='ops$muyeena' pw='XXXX');
>create table studytab as select * from connection to oracle
> (select y.study_name from
>   (select cso.clin_study_id from rxa_des.clinical_study_objectives cso
>       where long_description = 'Immunotherapy') x,
>   (select distinct cs.study as study_name, cs.clinical_study_id
>       from rxa_des.clinical_studies cs , rxc.dcis dci , rxc.dci_modules
dcim
>       where cs.clinical_study_id = dci.clinical_study_id
>       and cs.clinical_study_id   = dcim.clinical_study_id
>       and dci.clinical_study_id  = dcim.clinical_study_id
>       and dci.dci_id             = dcim.dci_id
> /*This part of the condition will be for active studies--and
dci.dci_status_code = 'A'*/
>    ) y
>where x.clin_study_id = y.clinical_study_id);
>disconnect from oracle;
>quit;
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>Any help will be appreciate.
>Thanks
>Abu Muyeen
>