Home » Server Options » RAC & Failsafe » How to edit init.ora file and nls_length_semantics parameter in RAC environment (Oracle 10g)
How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335107] Mon, 21 July 2008 00:56 Go to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I am facing a problem.

How to edit init.ora file and nls_length_semantics in RAC environment?

and i checked in init.ora file in which I have the spfile path.

I have two instances in RAC.

Regards,
Gajanan
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335113 is a reply to message #335107] Mon, 21 July 2008 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you use spfile or init.ora?

Regards
Michel
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335117 is a reply to message #335113] Mon, 21 July 2008 01:27 Go to previous messageGo to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Actually I am using Medium and RAC environment. I want to change nls_length_semantics from char to byte in init.ora file and the alter the parameter by connecting sys user. So I Changed in M environment easily but if i want to change in RAC environment,I am not able to change the parameter.

I am using spfile.
I found spfile path in init.ora file.

init.ora file is:

SPFILE='+TESTDATA1/TEST_DB2/spfileTESTDB2.ora'
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335122 is a reply to message #335117] Mon, 21 July 2008 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you use a spfile you just have to execute "alter system" to set the parameter.

Regards
Michel
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335124 is a reply to message #335122] Mon, 21 July 2008 01:47 Go to previous messageGo to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
I did the following steps but i am not able to change.

1) I connected to first instance.
2) I stopped the second instance from first instance.
3) I used "alter system" in first instance.
4) shut down and startup the database.
5) I started the second instance again.
6) I checked the nls_length_semantics parameter for instance and session level but not changed.

Please suggest, If I missed anything.
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335126 is a reply to message #335124] Mon, 21 July 2008 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
3) I used "alter system" in first instance

Post the statement.

Regards
Michel
Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335149 is a reply to message #335126] Mon, 21 July 2008 03:59 Go to previous messageGo to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
1) I connect to first server.
[oracle@it-hatest-db1 ~]$ export ORACLE_SID=TESTDB21

2) Stopped the second instance from first server.
[oracle@it-habam-db1 ~]# srvctl stop instance -d TEST_DB2 -i TESTDB22

3) Connected to second server and checked the instance. So it is connected through idle instance.

[oracle@it-hatest-db2 ~]$ export ORACLE_SID=TESTDB22
[oracle@it-hatest-db2 ~]$ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jul 21 15:11:47 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> exit
Disconnected
[oracle@it-hatest-db2 ~]$

4) Connected first instance and connected with Oracle. Now I am cheking the status of 'NLS_LENGTH_SEMANTICS' parameter.

SQL> select 'DATABASE:' as lvl, value from nls_database_parameters where parameter = 'NLS_LENGTH_SEMANTICS';

LVL VALUE
------------------------------------------------------
DATABASE: BYTE

SQL> select 'SESSION:' as lvl, value from nls_session_parameters where parameter = 'NLS_LENGTH_SEMANTICS';

LVL VALUE
--------------------------------------------------------
SESSION: BYTE

SQL> select 'INSTANCE' as lvl, value from nls_instance_parameters where parameter='NLS_LENGTH_SEMANTICS';

LVL VALUE
----------------------------------------------------
INSTANCE BYTE

5) Now I am changing the parameter 'NLS_LENGTH_SEMANTICS' from byte to char.

SQL> alter system set nls_length_semantics=char;

System altered.

SQL> alter session set nls_length_semantics=char;

Session altered.

6) Shut down and startup the database.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1261828 bytes
Variable Size 130027260 bytes
Database Buffers 230686720 bytes
Redo Buffers 2928640 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.3.0 - Production
With the Real Application Clusters option
[oracle@it-habam-db1 ~]$

7) Now I started the second instace again.
[oracle@it-habam-db1 ~]# srvctl start instance -d TEST_DB2 -i TESTDB22

Cool Now again I connected to second server.

[oracle@it-hatest-db2 ~]$ export ORACLE_SID=TESTDB22
[oracle@it-hatest-db2 ~]$ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jul 21 15:26:48 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Release 10.2.0.3.0 - Production
With the Real Application Clusters option

SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.3.0 - Production
With the Real Application Clusters option
[oracle@it-hatest-db2 ~]$

9) I connected to first instance
$ export ORACLE_SID = TESTDB21

[oracle@it-hatest-db1 ~]$ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Jul 21 15:28:01 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Release 10.2.0.3.0 - Production
With the Real Application Clusters option

SQL> select 'DATABASE:' as lvl, value from nls_database_parameters where parameter = 'NLS_LENGTH_SEMANTICS';

LVL VALUE
----------------------------------------------------------
DATABASE: BYTE

SQL> select 'SESSION:' as lvl, value from nls_session_parameters where parameter = 'NLS_LENGTH_SEMANTICS';

LVL VALUE
----------------------------------------------------------
SESSION: CHAR

SQL> select 'INSTANCE' as lvl, value from nls_instance_parameters where parameter='NLS_LENGTH_SEMANTICS';

LVL VALUE
--------------------------------------------------------
INSTANCE CHAR


I am able to change the parameter.

Any how Thank you Michel. Sorry for the trouble.


Re: How to edit init.ora file and nls_length_semantics parameter in RAC environment [message #335160 is a reply to message #335149] Mon, 21 July 2008 04:57 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The correc statement is:
Quote:
alter system set nls_length_semantics=char scope=both sid='*';

Regards
Michel
Previous Topic: Oracle 10g RAC installtion in windows 2003
Next Topic: interconnect speed
Goto Forum:
  


Current Time: Fri Mar 29 01:02:42 CDT 2024