ORA-15032 Problem while dropping disks from disk group in (HPUX 11.31 ASM 11gR2 standalone db)

ORA-15032 Problem while dropping disks from disk group in ASM.

PROBLEM:

SQL> ALTER DISKGROUP DATA DROP DISK DATA_0003;

 

Diskgroup altered.

 

SQL>

SQL>

SQL>

SQL> SELECT name, header_status, path FROM V$ASM_DISK

2  ;

 

NAME                           HEADER_STATU PATH

------------------------------ ------------ ------------------------------

FORMER       /dev/rdisk/disk14

DATA_0001                      MEMBER       /dev/rdisk/disk15

DATA_0002                      MEMBER       /dev/rdisk/disk16

DATA_0003                      MEMBER       /dev/rdisk/disk17

DATA_0004                      MEMBER       /dev/rdisk/disk38

DATA_0005                      MEMBER       /dev/rdisk/disk39

DATA_0006                      MEMBER       /dev/rdisk/disk40

DATA_0007                      MEMBER       /dev/rdisk/disk41

DATA_0008                      MEMBER       /dev/rdisk/disk42

DATA_0009                      MEMBER       /dev/rdisk/disk43

DATA_0010                      MEMBER       /dev/rdisk/disk44

DATA_0011                      MEMBER       /dev/rdisk/disk45

DATA_0012                      MEMBER       /dev/rdisk/disk46

DATA_0013                      MEMBER       /dev/rdisk/disk47

 

14 rows selected.

 

SQL> SELECT name, type, total_mb, free_mb, required_mirror_free_mb, usable_file_mb FROM V$ASM_DISKGROUP;

 

NAME                           TYPE     TOTAL_MB    FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB

------------------------------ ------ ---------- ---------- ----------------------- --------------

DATA                           EXTERN    5888000    5748724                       0        5748724

 

SQL>

SQL>

SQL> ALTER DISKGROUP DATA rebalance wait;

ALTER DISKGROUP DATA rebalance wait

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup "DATA" does not exist or is not mounted

 

 

SQL> ALTER DISKGROUP DATA rebalance;

ALTER DISKGROUP DATA rebalance

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15001: diskgroup "DATA" does not exist or is not mounted

 

SQL>

 

 

CAUSE :



To be honest I cannot find the real cause, only the side effect. I tried running asmca, if it caused this, but cannnot reproduce the case. All I know is I had rebooted the OS, and then login to asmcmd, made some alterations, run asmca, and after a while I got this error.

trlogdb01:/dev/rdisk#ll

total 0

crw-r-----   1 bin        sys         13 0x00000a Oct 13 16:48 disk14

crw-r-----   1 bin        sys         13 0x00000b Oct 13 16:53 disk15

crw-r-----   1 bin        sys         13 0x00000c Oct 13 16:53 disk16

crw-r-----   1 bin        sys         13 0x00000d Oct 13 16:53 disk17

crw-r-----   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r-----   1 bin        sys         13 0x00000f Oct 13 16:56 disk38

crw-r-----   1 bin        sys         13 0x000010 Oct 13 16:56 disk39

crw-r-----   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r-----   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r-----   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r-----   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r-----   1 bin        sys         13 0x000011 Oct 13 16:56 disk40

crw-r-----   1 bin        sys         13 0x000012 Oct 13 16:56 disk41

crw-r-----   1 bin        sys         13 0x000013 Oct 13 16:53 disk42

crw-r-----   1 bin        sys         13 0x000014 Oct 13 16:53 disk43

crw-r-----   1 bin        sys         13 0x000015 Oct 13 16:53 disk44

crw-r-----   1 bin        sys         13 0x000016 Oct 13 16:53 disk45

crw-r-----   1 bin        sys         13 0x000017 Oct 13 16:53 disk46

crw-r-----   1 bin        sys         13 0x000018 Oct 13 16:56 disk47

crw-r-----   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r-----   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r-----   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r-----   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3

 

 

SOLUTION:

trlogdb01:/dev/rdisk#chown oracle:dba disk14 disk15 disk16 disk17

…

trlogdb01:/dev/rdisk#ll

total 0

crw-r-----   1 oracle     dba         13 0x00000a Oct 13 16:48 disk14

crw-r-----   1 oracle     dba         13 0x00000b Oct 13 16:53 disk15

crw-r-----   1 oracle     dba         13 0x00000c Oct 13 16:53 disk16

crw-r-----   1 oracle     dba         13 0x00000d Oct 13 16:53 disk17

crw-r-----   1 bin        sys         13 0x000000 May 13 12:44 disk3

crw-r-----   1 oracle     dba         13 0x00000f Oct 13 16:56 disk38

crw-r-----   1 oracle     dba         13 0x000010 Oct 13 16:56 disk39

crw-r-----   1 bin        sys         13 0x000006 May 13 12:44 disk3_p1

crw-r-----   1 bin        sys         13 0x000007 May 13 12:44 disk3_p2

crw-r-----   1 bin        sys         13 0x000008 May 13 12:44 disk3_p3

crw-r-----   1 bin        sys         13 0x000001 May 13 12:44 disk4

crw-r-----   1 oracle     dba         13 0x000011 Oct 13 16:56 disk40

crw-r-----   1 oracle     dba         13 0x000012 Oct 13 16:56 disk41

crw-r-----   1 oracle     dba         13 0x000013 Oct 13 16:53 disk42

crw-r-----   1 oracle     dba         13 0x000014 Oct 13 16:53 disk43

crw-r-----   1 oracle     dba         13 0x000015 Oct 13 16:53 disk44

crw-r-----   1 oracle     dba         13 0x000016 Oct 13 16:53 disk45

crw-r-----   1 oracle     dba         13 0x000017 Oct 13 16:53 disk46

crw-r-----   1 oracle     dba         13 0x000018 Oct 13 16:56 disk47

crw-r-----   1 bin        sys         13 0x000002 May 13 12:44 disk5

crw-r-----   1 bin        sys         13 0x000003 May 13 12:44 disk5_p1

crw-r-----   1 bin        sys         13 0x000004 May 13 12:44 disk5_p2

crw-r-----   1 bin        sys         13 0x000005 May 13 12:44 disk5_p3

 

 

 

11G R2 RAC ORA-12514 error

Problem

Gettting OA-12514 from client after fresh installation of 11gR2 RAC on OEL5.

Cause

Service name mismatch between listener and tnsnames.ora.

Solution

After investigation lsnrctl services output for listeners. Understood that while the the listener contains fully qualified domain name as service name, tnsnames.ora does not. Changing the client's tnsnames entry as follows solved the problem.

from:

MYTESTDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=mytestdb-scan.mycompany.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mytestdb)))

to:

MYTESTDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=mytestdb-scan.mycompany.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=mytestdb.mycompany.com)))

hung in Auto SQL Tuning task, critical alert in GC

Problem

Critical alert comes as:

mydb01 : -K- mydb1:Operational error () detected in /u01/app/oracle/diag/rdbms/mydb/mydb/alert/log.xml at time/line number: Tue Apr 20 00:10:51 2010/36623. : 00:15 20/04/10

Cause

I had opened an SR and the result is: It is a bug.
Bug 8636312: HUNG IN AUTO SQL TUNING TASK which is based on the Oracle base bug Billy gave above.
No workaround is provided, and the bug is not patched or solved in newer version.
Acknowledging this alert from the GC, solved my need of stopping the anoyingly coming of this alert.
You can acknowledge the alert by clicking the alert link, which brings details of it, containing "acknowlege" button.

This alert is related with the Metric: "Generic Operational Error"

Workaorund

Meantime you can drop auto sql tuning job as follows:

Check the AUTO SQL TUNING TASK exist:

SELECT   TASK_NAME, STATUS FROM   DBA_ADVISOR_TASKS

WHERE   task_name LIKE '%SYS_AUTO_SQL_TUNING_TASK%';

TASK_NAME	STATUS
SYS_AUTO_SQL_TUNING_TASK	FATAL ERROR

Drop it with command:

exec DBMS_SQLTUNE.DROP_TUNING_TASK('SYS_AUTO_SQL_TUNING_TASK');

Solution

Waiting for the patch.

ORA-24247: network access denied by access control list (ACL)

Problem:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 127
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "GEOPP.SEND_MAIL", line 240
ORA-06512: at "GEOPP.SEND_MAIL", line 118
ORA-06512: at "GEOPP.GEOPP_ALARM_MAIL", line 115
ORA-06512: at line 1

Cause:

Solution:

http://www.oracle-base.com/articles/11g/FineGrainedAccessToNetworkServices_11gR1.php

begin

dbms_network_acl_admin.create_acl ( acl => 'utlpkg.xml', description => 'Normal Access', principal => 'GEOPP', is_grant => TRUE, privilege => 'connect', start_date => null, end_date => null );

dbms_network_acl_admin.assign_acl ( acl => 'utlpkg.xml', host => '10.200.123.135', lower_port => 1, upper_port => 1000);

commit;

end;
/

Jasper Server and iReport Presentation

You could find JasperServer and iReport presentation from this link. JASPERv1

Cannot see Oracle ODBC driver in datasource administrator in Windows 64 bit

Problem:

I cannot see Oracle ODBC driver in datasource administrator in Windows 2003 64 bit.

Cause:

64 bit 32 bit incompatibility issue for odbc driver, data source administrator and application.

Solution:

I have Windows 2003 64 bit, Oracle 10.2 32 bit Client and 64 bit application.
After googleing around,

I found that there is two versions of odbc datasource administrator:

The default one, is 64 bit which we use Start menu for opening it.

In order to open the 32 bit version I used: %windir%\SysWOW64\odbcad32.exe.

With the help of 32 bit version datasource administrator, I could see my 32 bit odbc driver listed.

I extracted this rule of thumb: If your application is 32 bit, then your data source must use Oracle 32 bit client as well.

Last words, beware of 3 pieces:
1- your application (which uses DSN definition),
2- Oracle client
3-data source administrator

All pieces must have same version, in my case it is 64 bit and therefore I installed 64 bit client.

Further reading:
http://support.microsoft.com/kb/942976

What is oradiag_oracle directory in /home/oracle in 11.2?

This directory is created in the home directory of the oracle user, after making a local connection.

I had tested it as follows:

[oracle@geoppdb01]:/home/oracle> ls -ltr
total 16
-rw-r--r-- 1 oracle oinstall 15621 Jan  5 11:51 db.rsp
[oracle@geoppdb01]:/home/oracle> date
Thu Feb  4 19:52:12 EET 2010

--- made a local sqlplus connection after then

[oracle@geoppdb01]:/u01/app/oracle/product/11.2.0/dbhome_1> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 4 19:52:22 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> !date
Thu Feb  4 19:52:26 EET 2010

-- check the folder, here it comes to life:)

[oracle@geoppdb01]:/home/oracle> ls -ltr
total 20
-rw-r--r-- 1 oracle oinstall 15621 Jan  5 11:51 db.rsp
drwxr-xr-x 3 oracle oinstall  4096 Feb  4 19:52 oradiag_oracle
[oracle@geoppdb01]:/home/oracle>

DBCA Seed_Database_8k.dfb creation error

Problem:

ORA-19624, ORA-19870 , ORA-19505, ORA-27037 errors while creating database with DBCA.

Cause:


This issue is reported in Bug 5141453.

The database templates General Purpose, Transaction Procession, and
DataWarehouse are expected to be used only with 8k block size as the seed
database is shipped at 8k block size

Solution:

From Bug 5141453, development indicates that DB_BLOCK_SIZE cannot be changed
for the General Purpose, Transaction Procession and DataWarehouse templates
as the seed database is using 8k block size.

You should create a custom database to get a different block size.
References
Bug 5141453 - DBCA - CREATE DATABASE SCRIPTS - LOOKING FOR
SEED_DATABASE_8K.DFB Keywords CUSTOM~DATABASE; DB_BLOCK_SIZE; DBCA;

Thanks to guy Sallwasser Laura in the link:

http://www.lazydba.com/oracle/0__166384.html

Oracle Job Scheduler runs my jobs, one hour earlier, (Daylight Saving Time related)

Problem:

Scheduler runs my jobs one hour earlier, which causes empty summary tables in ETL process.

Log Date                  2010/01/21 02:00:09.072642 +02:00

Required Start Date  2010/01/21 03:00:04.662096 +03:00

Actual Start Date      2010/01/21 03:00:00.000000 +03:00

BEGIN

SYS.DBMS_SCHEDULER.CREATE_JOB

(

job_name        => 'MYCHEMA.SR54'

,start_date      => SYSTIMESTAMP,

,repeat_interval => 'FREQ=DAILY;BYHOUR=3;BYMINUTE=0;BYSECOND=0'

,end_date        => NULL

,job_class       => 'DEFAULT_JOB_CLASS'

,job_type        => 'PLSQL_BLOCK'

,job_action      => 'GENERIC_SUMMARY.procprocessreport ( 54 );'

,comments        => 'trunc(sysdate+1)+3/24'

);

SYS.DBMS_SCHEDULER.enable (name => 'log_parallel_process_job');

END;

/

Cause:

Using SYSTIMESTAMP as start date is converted as for example:

start_date      => TO_TIMESTAMP_TZ('2009/08/05 15:14:24.499000 +03:00','yyyy/mm/dd hh24:mi:ss.ff tzr')

You can see it from the ddl script of this in TOAD.

Thus, it means that you are hard coding the daylight saving time.

For example in Turkey, DST is GMT +03:00, it means if you create this script in summer time it will be hardcoded as +03:00 and if it is in other than day light saving time(normal time), it will be +02:00 in Turkey.

Solution:

Using named timezone code solves the problem, it will automatically adjust the execution time for you. Do not forget that, it also prevents

BEGIN

SYS.DBMS_SCHEDULER.CREATE_JOB

(

job_name        => 'MYCHEMA.SR54'

 ,start_date => TO_TIMESTAMP_TZ('2010/01/21 10:00:00.000000 Turkey','yyyy/mm/dd hh24:mi:ss.ff tzr')

,repeat_interval => 'FREQ=DAILY;BYHOUR=3;BYMINUTE=0;BYSECOND=0'

,end_date        => NULL

,job_class       => 'DEFAULT_JOB_CLASS'

,job_type        => 'PLSQL_BLOCK'

,job_action      => 'GENERIC_SUMMARY.procprocessreport ( 54 );'

,comments        => 'trunc(sysdate+1)+3/24'

);

DBMS_SCHEDULER.enable (name => 'log_parallel_process_job');

End;

/

For further details, and thanks goes to below links:

http://forums.oracle.com/forums/thread.jspa?threadID=646581

You can find your Time Zone Names in Oracle® Database Globalization Support Guide:

For eample: http://download-uk.oracle.com/docs/cd/B28359_01/server.111/b28298/applocaledata.htm#i637736

Firewall in Ubuntu Server

root@myserver:/#ufw enable

Firewall is active and enabled on system startup

root@myserver:/#ufw allow 80

Rule added

root@myserver:/#

Source:

https://help.ubuntu.com/8.04/serverguide/C/firewall.html

Manual install in Ubuntu

1) download deb packages *deb
2) dpkg -i *.deb

ORA-01102: cannot mount database in EXCLUSIVE mode

Problem:

I had used DBCA to create Oracle database and after doing all; had started the database from SQL and got the error message:

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             402655344 bytes
Database Buffers         1191182336 bytes
Redo Buffers                7360512 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

I looked for the pmon process;

[oracle@geoppdb01 ~]$ ps -ef|grep pmon
oracle   11758     1  0 Jan05 ?        00:00:00 ora_pmon_mydb
oracle   17754     1  0 14:17 ?        00:00:00 ora_pmon_MYDB
oracle   17795 17715  0 14:19 pts/1    00:00:00 grep pmon

Cause:

ORACLE_SID environment variable is case sensitive and in the .bash_profile I had set this as uppercase, despite the fact that  it was lower case.

Solution:

I had first changed the ORACLE_SID variable as lowercase, and then shutt down the two instances and startup solved my problem.

SQL> startup
ORACLE instance started.

Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             402655344 bytes
Database Buffers         1191182336 bytes
Redo Buffers                7360512 bytes
Database mounted.
Database opened.
SQL>