IntelliJ Java IDE
The moose likes Oracle/OAS and the fly likes while connecting with Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "while connecting with "system" occures ORA-01821 error" Watch "while connecting with "system" occures ORA-01821 error" New topic
Author

while connecting with "system" occures ORA-01821 error

Thomas Wild
Greenhorn

Joined: Aug 21, 2002
Posts: 3
All,
I set up the command "sqlplus system@xxxx" to open a sqlplus session from a Oracle client to its server. The error message I get is "ORA-01821: date format not recognized" and on a second line the error "SP2-0152: ORACLE may not be funtioning properly".
What has an date error to do with that kind of session? I already verified the tnsnames.ora and sqlnet.ora files, everything ok. I also can tnsping the server, everything fine.
Thank you for every comment.
Regards,
Thomas
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
What are the OS environment variables NLS_LANG and NLS_DATE_FORMAT set to?
Beksy
Thomas Wild
Greenhorn

Joined: Aug 21, 2002
Posts: 3
Beksy,
the NLS_LANG variable is set to AMERICA_AMERICA.WE8ISO8859P1. The NLS_DATE_FORMAT variable doesn't exist on this system. But on another client machine that works fine, this parameter doesn't exists too. Is there an other place where I need to set the date format in an Oracle client?
Thank you for you answer.
Regards,
Thomas
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Thomas,
Just a guess!
Shouldn't that be AMERICAN_AMERICA.WE8ISO8859P1 ?
(notice the 'n')
Is it the same in both server and client?
Beksy
Thomas Wild
Greenhorn

Joined: Aug 21, 2002
Posts: 3
Beksy,
sorry for that typing error(in that message I sent to you, not in the registry!). You are right it has an N. It's the same on both machines, yes. Thank you for your help. Any further ideas?
What you think, uninstall the client, clean up the registry and reinstall the client could solve that? I am in a hurry with that because it's on a client machine. So I need to solve that ASAP, do you understand?
Regards,
Thomas
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Thomas,
Have you tried to use the GUI version of sqlplus?(if you are using windowsNT)
Try to set the NLS_LANG parameter just before starting the sqlplus from dos.
What operating systems are you using for client and server?
Beksy
 
 
subject: while connecting with "system" occures ORA-01821 error
 
Threads others viewed
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12640:
how to recover - corrupted "undotbs01.dbf " ?
Connecting to Oracle Server From a Linux Client
Oracle acts out. Can't drop a user.
Problem in connecting Oracle thru Java
developer file tools