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:0×4)

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:0×4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0×4)
MRP: Prodding archiver at standby for thread 2 seq 31006
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0×4)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0×4)

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

ORA-00031: session marked for kill

January 28, 2014 Leave a comment

1. Kill a session, returned the message below.

SQL>  alter system kill session ’1022,851′;
alter system kill session ’1022,851′
*
ERROR at line 1:
ORA-00031: session marked for kill

2. Find out the OS process id

SQL> select a.spid,b.sid,b.serial#,b.username from v$process a,v$session b where a.addr=b.paddr and b.status=’KILLED’;

SPID         SID           SERIAL# USERNAME
———— ———- ———- ——————————
15198        ##########        851 EHEALTH

3. Go to OS to find the server process

[oracle@yplodb02 ~]$ ps -ef|grep 15198
oracle   15198     1  1 Jan20 ?        03:41:07 oracleehealthp1 (LOCAL=NO)

oracle    9140 13829  0 15:38 pts/4    00:00:00 grep 15198

4. Kill it by OS command

[oracle@yplodb02 ~]$ kill -9 15198

[oracle@yplodb02 ~]$ ps -ef|grep 15198
oracle   12522 13829  0 15:38 pts/4    00:00:00 grep 15198

 

 

 

 

Categories: Administration, ORA-XXX

Purge dba_scheduler_job_log

January 28, 2014 Leave a comment

 

SQL> exec DBMS_SCHEDULER.PURGE_LOG();

Categories: Administration

Cannot label disk when partitions are in use as described.

October 9, 2013 Leave a comment

Today, I did the repartition on a Solaris Server internal hard disk by the command format. When I labelled the disks, it returned the following error messages. I was sure that the disk was mounted on the system.

Enter partition id tag[root]:
Enter partition permission flags[wm]:
Enter new starting cyl[413]: 0c
`0c’ is not an integer.
Enter new starting cyl[413]:
Enter partition size[8395200b, 825c, 1237e, 4099.22mb, 4.00gb]: 0c
partition> l
Cannot label disk when partitions are in use as described.

Solution: Set NOINUSE_CHECK=1 to enable Not in use on. The following was procedures.

# NOINUSE_CHECK=1
# export NOINUSE_CHECK

Enter partition id tag[root]:
Enter partition permission flags[wm]:
Enter new starting cyl[413]:
Enter partition size[8395200b, 825c, 1237e, 4099.22mb, 4.00gb]: -c
Please specify units in either b(blocks), c(cylinders), e(end cylinder),
m(megabytes) or g(gigabytes)
Enter partition size[8395200b, 825c, 1237e, 4099.22mb, 4.00gb]: 0c
partition> l
Ready to label disk, continue? y

 

 

Categories: Solaris Admin

PRVF-0002 : Could not retrieve local nodename

September 17, 2013 Leave a comment

When I installed oracle 12c1, after starting runInstaller, it showed the following messages.

—# Begin Stacktrace #—————————
ID: oracle.install.commons.util.exception.DefaultErrorAdvisor:37
oracle.cluster.verification.VerificationException: PRVF-0002 : Could not retrieve local nodename
at oracle.cluster.verification.ClusterVerification.<init>(ClusterVerification.java:306)
at oracle.cluster.verification.ClusterVerification.getInstance(ClusterVerification.java:409)
at oracle.install.driver.oui.OUIInstallDriver.load(OUIInstallDriver.java:376)
at oracle.install.ivw.db.driver.DBSetupDriver.load(DBSetupDriver.java:223)
at oracle.install.commons.base.driver.common.Installer.run(Installer.java:306)
at oracle.install.ivw.common.util.OracleInstaller.run(OracleInstaller.java:106)
at oracle.install.ivw.db.driver.DBInstaller.run(DBInstaller.java:142)
at oracle.install.commons.util.Application.startup(Application.java:921)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:165)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:182)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:355)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:130)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:161)

 

Cause:

Missing hostname entry in /etc/hosts

Fix:

1. Check the hostname by the command hostanme

$ hostname

ora12c1

2. Add the hostname into /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ora12c1

 

 

 

Categories: Installation
Follow

Get every new post delivered to your Inbox.