- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-12705: invalid or unknown NLS parameter va...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:14 AM
тАО05-15-2002 05:14 AM
ORA-12705: invalid or unknown NLS parameter value specified
when I try to
"SQL>connect sys/passwd as sysdba"
The oracle .profile includes the following lines:
#-------------------------------------
NLS_LANG=AMERICAN-AMERICA.WE8ISO8859P1; export NLS_LANG
NLS_LANGUAGE=$NLS_LANG; export NLS_LANGUAGE
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
#-------------------------------------
Oracle 9i on HP-UX 11
What do I do here?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:28 AM
тАО05-15-2002 05:28 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
explicitly set your NLS_LANG value.
Else comment the all the NLS variables you have mentioned in your .profile file and then explicitly set only the NLS_LANG variable.
The problem may occur whent this variable is not set incorrectly.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:39 AM
тАО05-15-2002 05:39 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:41 AM
тАО05-15-2002 05:41 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
NLS_LANG=AMERICAN-AMERICA.us7ascii
export NLS_LANG
Now?!
THanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:42 AM
тАО05-15-2002 05:42 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
NLS_LANG=AMERICAN-AMERICA.us7ascii
export NLS_LANG
ALso do a echo $NLS_LANG to check it up
Now?!
THanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:51 AM
тАО05-15-2002 05:51 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
AMERICAN-AMERICA.us7ascii
after I set it.
I did notice that I made a spelling mistake 'AMERICAL' prior to the installation that I fixed after the installation.
echo confirmed this.
Would this have changed anything?
Also I cannot find PHCO_23092 superceded by PHCO_23963. Would that have had an effect?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 05:59 AM
тАО05-15-2002 05:59 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
It just sets the locale and territory settings.
The ora-12705 error it just duw to the wrong setting for this variable or a
mismatch of character-set.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 06:03 AM
тАО05-15-2002 06:03 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
IT is underscore and not hyphen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2002 06:21 AM
тАО05-15-2002 06:21 AM
Re: ORA-12705: invalid or unknown NLS parameter value specified
Problem solved, mission accomplished.
1000000000000000 points to you.
TG thanks for your helpfullness.