Connection to Oracle DB failed

[I H LIM]

Did try that earlier but still hit the same error message!
   
  Regards,
  Han

powerh-l-request at lists.sowder.com wrote:
  Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com

You can reach the person managing the list at
powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."


Today's Topics:

1. Connection to Oracle DB failed (I H LIM)
2. RE:Connection to Oracle DB failed (Ole Hansen)


----------------------------------------------------------------------

Message: 1
Date: Tue, 20 Jun 2006 03:07:12 -0700 (PDT)
From: I H LIM 
Subject: Connection to Oracle DB failed
To: powerh-l at lists.sowder.com
Message-ID: <20060620100712.57779.qmail at web32404.mail.mud.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

Hi everyone,

Server Platform : Oracle 10g in Windows Server 2003
Client Platform : Powerhouse Windows 8.41D1 running on Windows XP, Oracle Client 10g

We have try using oracle client "SQL PLUS" with the command 
"sqlplus user1/passwd1 at orcl", the connection is ok. 

We declare the pdl as below:

create dictionary c:\test\oracle\phd.pdc not preloaded
database orcl type oracle open "ORACLE at user1@orcl/passwd1" owner dba
load

and we access quiz as below and error appear :

> acc file1 in orcl
*W* SQL START DBE error (ORCL)
DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface
during operation 'attach database'.
ORA-12154: TNS:could not resolve the connect identifier specified

*E* The file file1 in orcl wasnt found in data dictionary

>

Anyone come across this issue? Please help

Thank You

Regards
Han




---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/6a13d4a4/attachment.html

------------------------------

Message: 2
Date: Tue, 20 Jun 2006 13:58:17 +0200
From: "Ole Hansen" 
Subject: RE: Connection to Oracle DB failed
To: "I H LIM" , 

Message-ID:
<283E7941B032C94CB56F2FDEE33845FC0A9D62 at scserver100.scanconsult03.local>

Content-Type: text/plain; charset="iso-8859-1"

Hi Han,

Looks very much like our pdl code.

Have you tried to remove the " around the logon string i.e. :

database orcl type oracle open ORACLE at user1@orcl/passwd1 owner dba

Mange hilsner / With kind regards

Ole Hansen

===========================================================
E-mail: oh at scanconsult.dk Cell Phone: +45 4040 1150
===========================================================
ScanConsult IT-Partners ApS Voice : +45 7734 7474
Jegstrupvej 96A Fax : +45 8738 1416
DK-8361 Hasselager Support : support at scanconsult.dk
Denmark Sales : sales at scanconsult.dk
http://www.scanconsult.dk 
= ParaSuite : A Suite of Air Cargo Handling solutions =
= Partners : Hewlett-Packard, Cognos, Microsoft and more =




________________________________

From: powerh-l-bounces+oh=scanconsult.dk at lists.sowder.com [mailto:powerh-l-bounces+oh=scanconsult.dk at lists.sowder.com] On Behalf Of I H LIM
Sent: 20. juni 2006 12:30
To: powerh-l at lists.sowder.com
Subject: Connection to Oracle DB failed


Hi everyone,

Server Platform : Oracle 10g in Windows Server 2003
Client Platform : Powerhouse Windows 8.41D1 running on Windows XP, Oracle Client 10g

We have try using oracle client "SQL PLUS" with the command 
"sqlplus user1/passwd1 at orcl", the connection is ok. 

We declare the pdl as below:

create dictionary c:\test\oracle\phd.pdc not preloaded
database orcl type oracle open "ORACLE at user1@orcl/passwd1" owner dba
load

and we access quiz as below and error appear :

> acc file1 in orcl
*W* SQL START DBE error (ORCL)
DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface
during operation 'attach database'.
ORA-12154: TNS:could not resolve the connect identifier specified

*E* The file file1 in orcl wasnt found in data dictionary

>

Anyone come across this issue? Please help

Thank You

Regards
Han



________________________________

Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/3eb54a43/attachment-0001.html

------------------------------

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

End of powerh-l Digest, Vol 13, Issue 14
****************************************


 		
---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/aa56d0e6/attachment.htm