ORA-02096: specified initialization parameter is not modifiable with this option

I getting below error while changing db_file_name_convert.

SQL> alter system set db_file_name_convert='/ora_dat/drssaerp','/ora_dat/ssaerp','/ora_idx/drssaerp','/ora_idx/ssaerp';

ORA-02096 "Specified initialization parameter is not modifiable with this option





Solution:


SQL> alter system set db_file_name_convert='/ora_dat/drssaerp','/ora_dat/ssaerp','/ora_idx/drssaerp','/ora_idx/ssaerp';

scope=spfile;

Altered System.

Restart the database once after that u can see the modified parameter.

SQL> show parameter log_file_name_convert

log_file_name_convert  string      /ora_dat/drssaerp/, /ora_dat/ssaerp

SQL> show parameter db_file_name_convert

db_file_name_convert   string      /ora_dat/drssaerp/, /ora_dat/ssaerp/,

                                                       /ora_idx/drssaerp/, /ora_idx/ssaerp/

To see the list of parameters which are session level or system level modifiable, you can query the V$PARAMETER view like below:

SQL> Select name,isses_modifiable,issys_modifiable from v$parameter;

ORA-02096 "Specified initialization parameter is not modifiable with this option

Cause: Though the initialization parameter is modifiable, it cannot be modified using the specified command.

Action: Check the DBA Guide for information about under what scope the parameter may be modified

Log Files in Oracle RAC

The Cluster Ready Services Daemon (crsd) Log Files

Log files for the CRSD process (crsd) can be found in the following directories:

ORA_CRS_HOME/log/hostname/crsd

the crsd.log file is archived every 10MB as crsd.101, crsd.102 ...
ORACLE_CRS_HOME/log//alert.log

Oracle Cluster Registry (OCR) Log Files

The Oracle Cluster Registry (OCR) records log information in the following location:

ORA_CRS_HOME/log/hostname/client

Cluster Synchronization Services (CSS) Log Files

You can find CSS information that the OCSSD generates in log files in the following locations:

ORA_CRS_HOME/log/hostname/cssd
OCSSD responsible for inter node health monitoring and instance endpoint recovery.

It runs as oracle user.  

The cssd.log file is archived every 20MB as cssd.101, cssd.102....

Event Manager (EVM) Log Files

Event Manager (EVM) information generated by evmd is recorded in log files in the following locations:

ORA_CRS_HOME/log/hostname/evmd

RACG Log Files

The Oracle RAC high availability trace files are located in the following two locations:

ORA_CRS_HOME/log/hostname/racg
$ORACLE_HOME/log/hostname/racg

Core files are in the sub-directories of the log directories. Each RACG executable has a sub-directory assigned exclusively for that executable. The name of the RACG executable sub-directory is the same as the name of the executable.

VIP Log Files

You can find VIP related log files under following location :
ORA_CRS_HOME/log/nodename/racg

OCR logs 
OCR logs (ocrdump, ocrconfig, ocrcheck) log files are stored in $ORA_CRS_HOME/log//client/ directory. 

SRVCTL logs

srvctl logs are stored in two locations, $ORA_CRS_HOME/log//client/ and in $ORACLE_HOME/log//client/ directories.

Slm Server not starting BaanERP in Cluster Server

Slm Server not starting in Second node of cluster server.

After I search found some error in license file. I plan to moved license file from first node to second after that it was working fine.

/usr/baan/shared/license

I requested new license from Baan Support.


#SlmServer -s

Log file path  /usr/baan/shared/log/log.SlmServer

2016-06-19[00:45:22]:E:root: Pid 18541 Uid 0 Euid 0 Gid 0 Egid 0
2016-06-19[00:45:22]:E:root: Errno 125 (Address already in use)
2016-06-19[00:45:22]:E:root: Log_mesg: TCP bind() to port 6005 failed, error 125
2016-06-19[00:45:22]:E:root:
2016-06-19[00:45:22]:E:root: ******* E N D of Error message *******
2016-06-19[00:45:24]:E:root:
2016-06-19[00:45:24]:E:root: ******* S T A R T of Error message *******
2016-06-19[00:45:24]:E:root: Log message called from /view/MaintSLM7_0.nlbaucc.ccadm.snapshot/vobs/tt/lib/nw_1/sock_server.c:
#221 keyword: ipc
2016-06-19[00:45:24]:E:root: Pid 18541 Uid 0 Euid 0 Gid 0 Egid 0
2016-06-19[00:45:24]:E:root: Errno 125 (Address already in use)
2016-06-19[00:45:24]:E:root: Log_mesg: TCP bind() to port 6005 failed, error 125
2016-06-19[00:45:24]:E:root: