Archive

Archive for August, 2014

Listener can’t write log file

August 18, 2014 Leave a comment

Symptoms

Listener can’t write log file. The log file has no log

[oracle@wplodb03 log]$ ls -al
total 28841972
drwxr-x—   2 oracle oinstall        4096 Jul 18 14:06 .
drwxr-x—  12 oracle oinstall        4096 May  7  2007 ..
-rw-r–r–   1 oracle oinstall           0 Aug 18 14:39 listener_wplodb03.log

Fixed

Set log_status of Listeners on/off as below

LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to OFF
The command completed successfully
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to OFF
The command completed successfully
LSNRCTL> set log_status on
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> show log_status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER parameter “log_status” set to ON
The command completed successfully
LSNRCTL> exit
[oracle@wplodb03 log]$ ls -lrt
-rw-r–r–  1 oracle oinstall     4972026 Aug 17 23:10 sqlnet.log
-rw-r–r–  1 oracle oinstall        1759 Aug 18 14:44 listener_wplodb03.log

After on/off, the log file grows

Categories: TNS

/rootcrs.pl -prepatch returned error messages

August 13, 2014 Leave a comment

Aftering installing Oracle 12c1, I patched the p18705901_121010_SOLARIS64.zip on a RAC manually since the autopatch still failed. (Doc ID 1594184.1). According to the Doc, the first step to run “rootcrs.pl -prepatch” by root user, it showed errors below. Fortunately, the following URL can help to fix the problem.

http://www.stojanveselinovski.com/blog/2014/05/19/gi-psu-12-1-0-1-3/

1. It traced that the script was executing “su oracle”
2. The rootcrs.pl script run under current directory and didn’t have permsision to wirte the directory. i.e if you su to root, your current directory must be /root

2014/08/13 10:30:03 CLSRSC-175: Failed to write the checkpoint ‘ROOTCRS_PREPATCH’ with status ‘START’ (error code 256)

2014/08/13 10:30:03 CLSRSC-177: Failed to add (property/value):(‘NONROLLING’/’0’) for checkpoint ‘ROOTCRS_PREPATCH’ (error code 256)

2014/08/13 10:30:03 CLSRSC-177: Failed to add (property/value):(‘DESTCRSHOME’/’null’) for checkpoint ‘ROOTCRS_PREPATCH’ (error code 256)

2014/08/13 10:30:03 CLSRSC-177: Failed to add (property/value):(‘NORESTART’/’0’) for checkpoint ‘ROOTCRS_PREPATCH’ (error code 256)

2014/08/13 10:30:04 CLSRSC-177: Failed to add (property/value):(‘SOFTWAREPATCH’/’0’) for checkpoint ‘ROOTCRS_PREPATCH’ (error code 256)

Oracle Clusterware active version on the cluster is [12.1.0.1.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].

Solution
Before runing the rootcrs.pl, change to /tmp directory. After “su – oracle”, it still have permission to write the /tmp directory.

Categories: Uncategorized