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

ORA-00845: MEMORY_TARGET not supported on this system

June 9, 2014 Leave a comment

Today, I tuned the memory_target to 8G on a 11g instance, it showed the errors above when it got restarted. It was caused by the tmpfs size.

[oracle@yhktamvmdb01 etc]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                 7.8G  164K  7.8G   1% /dev/shm <– the size less than 8G.
/dev/sda1             485M   37M  423M   9% /boot

Then, I increased the size by the command below

[root@yhktamvmdb01 ~]# mount -t tmpfs shmfs -o size=12g /dev/shm

[root@yhktamvmdb01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                  12G     0   12G   0% /dev/shm <– the size increased to 12G

Start the database successfully

SQL> startup
ORACLE instance started.

Total System Global Area 8551575552 bytes
Fixed Size                  2270360 bytes
Variable Size            5049944936 bytes
Database Buffers         3489660928 bytes
Redo Buffers                9699328 bytes
Database mounted.
Database opened.

Make the change on the tmpfs permanently by editing the /etc/fstab as the following

tmpfs                   /dev/shm                tmpfs   size=12g        0 0

 

 

 

 

Categories: ORA-XXX

Enable VNC Server on Solaris 10

May 21, 2014 Leave a comment

1. Add entry below intop /etc/services

vnc-server      5900/tcp                        # Xvnc

2. Create /etc/X11/gdm/custom.conf with entries below

xdmcp]
Enable=true
[security]
DisallowTCP=false
AllowRoot=true
AllowRemoteRoot=true

3. Enable the svc

# svcadm enable svc:/application/x11/xvnc-inetd:default
# svcs  xvnc-inetd
STATE          STIME    FMRI
online         14:41:27 svc:/application/x11/xvnc-inetd:default

 

Categories: Solaris Admin

ORA-28040: No matching authentication protocol

April 17, 2014 Leave a comment

I just install 12C1 database. When the old client 8 connected to the database, it showed the error below.

ORA-28040: No matching authentication protocol

Fixed:

Add the parameter below into $ORACLE_HOME/network/admin/sqlnet.ora. This set SQL

SQLNET.ALLOWED_LOGON_VERSION=8

 

Categories: Uncategorized

mysql_secure_installation showed ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

April 4, 2014 Leave a comment

Today, I secured the mysql db with the mysql_secure_installation. It showed the following errors.

root@slave1 mysql]# ./bin/mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we’ll need the current
password for the root user.  If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
Enter current password for root (enter for none):
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
Enter current password for root (enter for none):

Caused:

Since I have set the mysqld socket to /opt/mysql/run/mysqld.sock in /etc/my.cnf as the following, not the default path /tmp/mysql.sock.

[mysqld]
# basic setting
datadir = /opt/mysql/data
tmpdir = /opt/mysql/tmp
socket = /opt/mysql/run/mysqld.sock

Fixed:

I added one more line “/opt/mysql/run/mysqld.sock” into /usr/local/mysql/bin/mysql_secure_installation at make_config section as the following. Then the problem got fixed.

sub make_config {
my $password = shift;

my $esc_pass = basic_single_escape($rootpass);
write_file($config,
“# mysql_secure_installation config file”,
“[mysql]“,
“user=root”,
“password=’$esc_pass'”,
“connect-expired-password”,
“socket=/opt/mysql/run/mysqld.sock”);
}

 

 

Categories: mySQL troubleshooting

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)

March 13, 2014 Leave a comment

On the standby dataguard  10.2.3 db, the  xxxxx_mrp0_xxx.trc showed the messages when executing “alter system archive log crrent”

MRP: Prodding archiver at standby for thread 1 seq 45077
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)
MRP: Prodding archiver at standby for thread 2 seq 31006
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x4)

According to oracle support, it is a bug.( LGWR unconditionally writes to trace file ). The workaround solution is to set log_archive_max_proesses to high count. ( I set it to 10). The warning disappeared after the change.

Categories: Oracle Bug
Follow

Get every new post delivered to your Inbox.