|
|
|
|
| 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   |
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 #335124 is a reply to message #335122] |
Mon, 21 July 2008 01:47 |
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 #335149 is a reply to message #335126] |
Mon, 21 July 2008 03:59 |
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
 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
