OraFAQ Forum: Networking and Gateways » ORA-01810: format code appears twice, followed by ORA-12560 !

Home » RDBMS Server » Networking and Gateways » ORA-01810: format code appears twice, followed by ORA-12560 !

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01810: format code appears twice, followed by ORA-12560 ! [message #67628]

Wed, 24 November 2004 23:46

Lars Erkki
Messages: 2
Registered: November 2004

Junior Member

Hi !

Can anybode give me a hint on what it could be that causes this phenomenoun ? Sample login showed below:

C:>sqlplus system/manager@stand1

SQL*Plus: Release 8.1.7.0.0 - Production on Tor Nov 25 10:43:45 2004

(c) Copyright 2000 Oracle Corporation.� All rights reserved.

ERROR:
ORA-01810: format code appears twice

Ange anv�ndarnamn:
ERROR:
ORA-12560: TNS: protokolladapterfel

...

..

Thanks in advance !

Report message to a moderator

Re: ORA-01810: format code appears twice, followed by ORA-12560 ! [message #67629 is a reply to message #67628]

Thu, 25 November 2004 01:40

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

Here is a solution direct from Metalink :

This is genrally because the client and server date formats are different.
Client is sending data in RRRR format while the database is expecting
only RR format.
1.Modify the NLS_DATE parameter in the registry.
2.Start the registry editor
Find the ORACLE key
3.HKEY_LOCAL_MACHINE > Software > ORACLE
4.Single click on it to populate the right-hand window
In the right-hand window, look for the value NLS_DATE (or NLS_DATE_FORMAT) and double click on it.
5. Change the value to read DD-MON-RR

If the value is not present add it by selecting Edit > New > key
Add the key with the above information.

Daljit Singh.

Report message to a moderator

Re: ORA-01810: format code appears twice, followed by ORA-12560 ! [message #67631 is a reply to message #67628]

Fri, 26 November 2004 02:10

Lars Erkki
Messages: 2
Registered: November 2004

Junior Member

Thanks Daljit, it solved it !

Report message to a moderator

Previous Topic:	Oracle Kerberos SSO
Next Topic:	Connecting 9i to Oracle 7 - ORA-12560 TNS Protocol Adapter Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 19:37:46 CDT 2025