1748169 Members
3877 Online
108758 Solutions
New Discussion юеВ

Oracle :ORA-12705

 
Trng
Super Advisor

Oracle :ORA-12705

Dear Gurus,

we have HPUX 11.23 MSCG cluster setup running oracle DB.Currently package is running on second node and DB also running fine on seconadry node.now i am need to install some OS Path on secondary.so i have halted the package on seconadry and started it on first node.but my Database team is saying they are not able to start database ,they are getting some error .

sqlplus ' /as sysdba'

SQL * plus : Release 9.2.0.6.0

ERROR:
ORA-12705:invaild or unknown NLS parameter value specified


I checked NLS_LANG parameter both node ,found both are same.what needs to be checked further ?



rgds


administrator
8 REPLIES 8
Johnson Punniyalingam
Honored Contributor

Re: Oracle :ORA-12705

Hi Trng,

when you haltpkg from Node2 and trying to run on the Node1,

cmviewcl --> status does it shows that your package running in Node1 ..?

Can you cross check wether the package has sucefully fall-back to Node1 ..?

/etc/cmcluster/pkg.log ..?

Thanks,
Johnson

Problems are common to all, but attitude makes the difference
Trng
Super Advisor

Re: Oracle :ORA-12705

yes,package is running on node 1 ..no issues with package failover etc ..

i need to know why it is giving this error

ERROR:
ORA-12705:invaild or unknown NLS parameter value specified
administrator
Patrick Wallek
Honored Contributor
Aneesh Mohan
Honored Contributor

Re: Oracle :ORA-12705

Hi,


The problem could be due to improper env settings (.profile, .bash_profile, .login) for the oracle user on Node 1.Please do env on both the nodes and confirm the variables.

$env


Aneesh


Johnson Punniyalingam
Honored Contributor

Re: Oracle :ORA-12705

Hi,

Can you check on the both Node1 & Node2 ..? are they look smilar ..?

oracle .profile

Thanks,
Johnson
Problems are common to all, but attitude makes the difference
Volker Borowski
Honored Contributor

Re: Oracle :ORA-12705

Hi,

check environment ORA_NLS33 in addition and make sure that the location it points to has the correct Oracle client SW release (9.2.0.6)

Volker
Wim Rombauts
Honored Contributor

Re: Oracle :ORA-12705

I rather think you have a problem with your pfile or spfile.

I guess you don't have RAC, but a single-istance database that swithces between the nodes.
So I also guess you have a different pfile per system, and on system 1, there will be some NLSxxx parameter the database cannot understand. Or something has changed in your pfile since you last started the database on system 2, and now the database cannot start.

To my knowledge, nothing is wrong with environment parameters. This type of error is for an initialization parameter.
Eric Antunes
Honored Contributor

Re: Oracle :ORA-12705

Hi,

Please execute the following as the oracle database owner user (typically oracle) and post the output:

$echo $NLS_LANG

Best Regards,

Eric Antunes
Each and every day is a good day to learn.