Archive

Archive for May, 2010

Slow sqlpus connection

May 11, 2010 Leave a comment

Symptoms

1. Get connected fast to the database with sysdba as the following
[oracle@SGRAC1 ~]$ sqlplus ‘/as sysdba’

2. Get connected slowly to the database with other user with tnsname
[oracle@SGRAC1 ~]$ sqlplus vod/vod@sgcmsdev1
SQL*Plus: Release 11.1.0.7.0 – Production on Tue May 11 01:54:40 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved. <– Stuck at here and wait about 10 seconds.

Connected to: Oracle Database 11g Release 11.1.0.7.0 – 64bit Production With the Real Application Clusters option

SQL>

Fixed

Remove /etc/resolv.conf, the problem get solved

Categories: TroubleShooting

ORA-00214: control file ‘/u01/oracle/oradb/control01.ctl’ version 1316

May 5, 2010 2 comments

Symptoms

When starting the database, it returned the messages.

SQL> startup
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes
ORA-00214: control file ‘/u01/oracle/oradb/control01.ctl’ version 1316
inconsistent with file ‘/opt/oracle/flash_recovery_area/oradb/control02.ctl’
version 1138

Fix Procedures

1. Startup nomount

SQL> startup nomount
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes

2. Change control_files setting

SQL> alter system set control_files=’/u01/oracle/oradb/control01.ctl’ scope=spfile;

System altered.

3. Restart the database

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            2298482520 bytes
Database Buffers         1962934272 bytes
Redo Buffers               12144640 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter spfile

NAME                                 TYPE        VALUE
———————————— ———– ——————————
spfile                               string      /opt/oracle/product/11g/dbs/sp
fileoradb.ora
SQL> show parameter control

NAME                                 TYPE        VALUE
———————————— ———– ——————————
control_file_record_keep_time        integer     7
control_files                        string      /u01/oracle/oradb/control01.ct