Oracle User Locked(Timed)

Why Oracle user get locked(timed) ? I had change profile : PASSWORD_LIFE_TIME, PASSWORD_LOCK_TIME, PASSWORD_GRACE_TIME to UNLIMITED, but it doesn’t work.

Then I run audit trail :

1. alter system set audit_trail=db scope=spfile; (then restart db)
   
2. audit connect whenever not successful;
3. monitoring via this query : 

   SELECT *
   FROM dba_audit_session
   WHERE action_name = ‘LOGON’ AND returncode > 0
   ORDER BY timestamp DESC;

4. then login fail and then locked because the user password case-sensitive, so I run : alter system set sec_case_sensitive_logon=false;
5. done ^_^

 

Reset Admin Password in Prestashop

I’ve lost the password for my localhost install, and I didn’t have a SMTP server available. So, I can’t recover my lost password.
After some googling, I found a solution that I post in here,

1. Open the setting.inc.php (located in config folder)
2. Copy the _COOKIE_KEY_ value
3. Use SQL tool (PHPMyAdmin or Toad for MySQL)
4. In SQL editor, paste this code
   

   UPDATE ps_employee SET passwd=md5(“newpassword”) WHERE email=”your email login”

   example:
   my _COOKIE_KEY_ = “mzRSjVM75MDsBRd6ALu5UoovCoADGX3WZITgiudEAGAEC1FG0EdDGLjc“
   my new password = pshop
   then the SQL :

   UPDATE ps_employee
   SET passwd = md5(“
   mzRSjVM75MDsBRd6ALu5UoovCoADGX3WZITgiudEAGAEC1FG0EdDGLjc
   pshop“)
   WHERE email = “thepandazen@gmail.com”;

5. Replace with the string you copy (step 2)
6. Execute the SQL
7. Login back to your Prestashop admin

Hope it helps someone saving some time

Tranparent Pentaho Dialog in Pentaho Administration Console

I am glad to know that the latest edition Pentaho BI Server – Community Edition today, 3.9.0, have a new visual interface (check and download the latest Pentaho BI server from sourceforge.net).

Here the screenshot on Pentaho User Console (PUC),

But Pentaho Administration Console (PAC) not updated, even now pentaho dialog box display transparently when I adding new database connection,

I try to do some experiments (ie. check the html code in the PAC) to outsmart the above problem,

1. add 1 line css style
   

   .pentaho-dialog { background-color: #00ccff;}

   to PentahoAdminConsole.html

   the result,

2. use Onyx style,
   1. copy folder “onyx” from “pentaho-solutions\system\common-ui\resources\themes\onyx” to “administration-console\www\org.pentaho.pac.PentahoAdminConsole”

   2. <link rel=”stylesheet” href=”onyx/globalOnyx.css” type=”text/css”>

the result,

Oracle RMAN Backup Script In Oracle Linux

This is rman.sh

ORACLE_SID=ITCAPPS; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
rman target / log=/home/oracle/rman.log << EOF
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
sql 'alter system switch logfile';
backup database format '/disk1/backup/full_%U.bkp';
delete noprompt obsolete;
EOF

And this is RMAN configuration,

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ITCAPPS are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/disk1/backup/controlfile_autobackup_%F.bkp';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_ITCAPPS.f'; # default

Oracle Database in Oracle Linux Cannot Start / Open

Today I mess around with the Oracle database that can not start and open. I get some error messages from various places such as alert.log, sqlplus, rman.

These errors are,

ORA-03110: end-of-file on communication channel
ORA-03135: connection lost contact
ORA-00845: MEMORY_TARGET not supported on this system
ORA-16038: log 3 sequence# 400 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/ITCAPPS/redo03.log'
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-00257: archiver error. Connect internal only, until freed.

I have do this step :
1. replace the  current spfile with the old one
2. startup with pfile
3. restore and recover database using rman

But that no help at all.

And the real solution is to enlarge the capacity of the folder where the archivelog is

Oracle Parameter optimizer_index_cost_adj Performance

From Oracle Documentation,

Default value 100
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values 1 to 10000

OPTIMIZER_INDEX_COST_ADJ lets you tune optimizer behavior for access path selection to be more or less index friendly—that is, to make the optimizer more or less prone to selecting an index access path over a full table scan.

The default for this parameter is 100 percent, at which the optimizer evaluates index access paths at the regular cost. Any other value makes the optimizer evaluate the access path at that percentage of the regular cost. For example, a setting of 50 makes the index access path look half as expensive as normal.

The default value 100 and 0 for OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING respectively are set for Data Warehouse System.

For OLTP system, setting 10 to OPTIMIZER_INDEX_COST_ADJ and 90 to OPTIMIZER_INDEX_CACHING will perform good result.

Oracle Parameter db_block_checksum Performance

From Oracle Documentation,

Default value TYPICAL
Modifiable ALTER SYSTEM
Range of values OFF | TYPICAL | FULL

DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum (a number calculated from all the bytes stored in the block) and store it in the cache header of every data block when writing it to disk. Checksums are verified when a block is read – only if this parameter is TYPICAL or FULL and the last write of the block stored a checksum. In FULL mode, Oracle also verifies the checksum before a change application from update/delete statements and recomputes it after the change is applied. In addition, Oracle gives every log block a checksum before writing it to the current log.

If this parameter is set to OFF, DBWn calculates checksums only for the SYSTEM tablespace, but not for user tablespaces.

Checksums allow Oracle to detect corruption caused by underlying disks, storage systems, or I/O systems. If set to FULL, DB_BLOCK_CHECKSUM also catches in-memory corruptions and stops them from making it to the disk. Turning on this feature in TYPICAL mode causes only an additional 1% to 2% overhead. In the FULL mode it causes 4% to 5% overhead. Oracle recommends that you set DB_BLOCK_CHECKSUM to TYPICAL. For backward compatibility we preserve use of TRUE (implying TYPICAL) and FALSE (implying OFF) values.

Note: If your application is I/O intensive and you are short on CPU capacity, then you might want to disable it.

Cannot Compile Oracle Function ORA-04021

I was get this error when I alter and compile one function

ORA-04021: timeout occurred while waiting to lock object

First try, I use this query to find what cause this error

SELECT p.spid “Thread”,
s.sid “SID-Top Sessions”,
SUBSTR (s.osuser, 1, 15) “OS User”,
SUBSTR (s.program, 1, 25) “Program Running”,
s.username
FROM v$process p, v$session s
WHERE p.addr = s.paddr
ORDER BY SUBSTR (s.osuser, 1, 15)

Then I use

SELECT * FROM v$access where object = ‘[function_name]‘

, the query took lonq execution. So, I use the simple query

SELECT * FROM v$access

then I find and now I can see who is locking the function. Just kill the user and I can compile the function again

alter function [function_name] compile;

How To See Oracle Database Parameter

You can run this sql to see Oracle Database Parameter :

SELECT name,
value,
isdefault default_value,
description,
isses_modifiable session_modifiable,
issys_modifiable system_modifiable,
isdeprecated deprecated,
update_comment
FROM v$parameter
ORDER BY name

ISDEFAULT	Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE)
ISSES_MODIFIABLE	Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
ISSYS_MODIFIABLE	Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:
	IMMEDIATE – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
	DEFERRED – Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
	FALSE – Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
ISINSTANCE_MODIFIABLE	For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). If the ISSYS_MODIFIABLE column is FALSE, then this column is always FALSE.
ISMODIFIED	Indicates whether the parameter has been modified after instance startup:
	MODIFIED – Parameter has been modified with ALTER SESSION
	SYSTEM_MOD – Parameter has been modified with ALTER SYSTEM (which causes all the currently logged in sessions’ values to be modified)
	FALSE – Parameter has not been modified after instance startup
ISADJUSTED	Indicates whether Oracle adjusted the input value to a more suitable value (for example, the parameter value should be prime, but the user input a non-prime number, so Oracle adjusted the value to the next prime number)
ISDEPRECATED	Indicates whether the parameter has been deprecated (TRUE) or not (FALSE)

And this sql to compare Oracle Database Parameter between 2 database :

SELECT a.name mdn_name, b.name jkt_name, a.VALUE mdn_value, b.VALUE jkt_value
FROM v$parameter a, v$parameter@db2 b
WHERE a.name(+) = b.name
ORDER BY a.name

Create Oracle Schedule Backup Script on Oracle Linux :

1. create backup directory for USERME
   

   CREATE OR REPLACE DIRECTORY BCK_DIR AS ‘/home/oracle/bck’;
   GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO EXP_FULL_DATABASE;
   GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO IMP_FULL_DATABASE;

2. using vi to create script
   

   #!/bin/bash
   clear
   #echo “Hello, linux world from pandazen world.”
   echo “backup pandazen data with script on Oracle Linux”
   NOW=$(date +”%Y%m%d”)
   FILE=”pandazen$NOW”
   echo $FILE

   #export data pump with compression
   expdp USERME/<PASSWORD> dumpfile=$FILE.dmp logfile=$FILE.log directory=BCK_DIR compression=all

   #archive with tar
   tar -cf $FILE.tar $FILE.dmp $FILE.log

   #compress again with gzip
   gzip $FILE.tar
   [ESC]
   :wq

3. using crontab to schedule it
   

   crontab -e
   0 22 * * * /home/oracle/script/bckmis.sh
   [ESC]
   :wq

Oracle Fine-Grained Auditing (Oracle FGA)

Today my first time using Oracle Fine-Grained Auditing. Why do I need to use Oracle Fine-Grained Auditing?
This is because there is a table that is accessed by many procedures, triggers and packages. So that in case of deletion, I can not track from which the “DELETE” order came from.

I’ve tried using a trigger on a table to track it down. But this action, I think is still not enough. So I tried to use Oracle FGA.

Here’s an example that I use Oracle FGA :

– truncate the audit trail log
CONN sys/password AS SYSDBA
TRUNCATE TABLE fga_log$;

– add the policy TST_AUDIT to the MIS schema all column of the TRD_STATEMENTS table
BEGIN
DBMS_FGA.add_policy (object_schema => ‘MIS’,
object_name => ‘TRD_STATEMENTS’,
policy_name => ‘TST_AUDIT’,
audit_condition => NULL,
audit_column => NULL,
statement_types => ‘DELETE’);
END;

– check the audit trail result
SELECT * FROM dba_fga_audit_trail;

Cancel Oracle Trigger to Execute The Commands

Hi, I want to cancel the trigger of a table that does not work if the logic condition is not met. So as if I want the trigger to rollback (for example = cancel delete in before-delete trigger). At first, the trigger like this :

CREATE OR REPLACE TRIGGER MIS.TRIG01_TABLE_A
BEFORE DELETE
ON PANDAZEN.TABLE_A
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
INSERT INTO PANDAZEN.TABLE_B
SELECT * FROM PANDAZEN.TABLE_A;
END;

The trick to achieve what I want, ie – cancel delete command in the before-delete trigger is to use the command

raise_application_error

So, now triggernya be like this :

CREATE OR REPLACE TRIGGER MIS.TRIG01_TABLE_A
BEFORE DELETE
ON PANDAZEN.TABLE_A
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
IF (:OLD.TABLE_A_VALUE = ‘OLD’) THEN
RAISE_APPLICATION_ERROR (-20000, ‘CANCEL DELETE’);
END IF;

INSERT INTO PANDAZEN.TABLE_B
SELECT * FROM PANDAZEN.TABLE_A;
END;

NetBeans 7.0 Get CORBA and OMG

I use NetBeans IDE 7.0 running the default GlassFish Server 3.1 from the NetBeans installation file. I got this error :

WARNING: IOP00010002: Unknown user exception thrown by the server – exception: java.lang.NullPointerException; message: null
org.omg.CORBA.UNKNOWN: WARNING: IOP00010002: Unknown user exception thrown by the server – exception: java.lang.NullPointerException; message: null vmcid: OMG minor code: 2 completed: Maybe
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
.
.
.

I have tried to find various solutions on the internet but no solution that could solve this issue.
CORBA is COBRA?
OMG is Oh, My God?

When I try to trace, the code stop at

generic.persist (m);

. Not a single clue.

So, I tried to install another version of Glassfish, the version 3.0.1, my problem solved. Now I want to try downloading the GlassFish Server 3.1 which is separate from the NetBeans installation file.

the quick red fox jumps over the pink rabbit and seen by the brown dog

This is a continuation of the post previous post “the quick red fox jumps over the pink rabbit”. After I saw that at PandaZen’s QR Code, there is a brown dog, so I edit the QR Code. And here the old and new PandaZen’s QR Code.

the quick red fox jumps over the pink rabbit

the quick red fox jumps over the pink rabbit and seen by the brown dog

Error regsvr32 TortoiseSVNSCC.dll

I run regsvr32 TortoiseSVNSCC.dll on Vista, but it fails and Windows shows this message :

Microsoft(C) Register Server has stopped working

A problem caused the program to stop working correctly.
Windows will close the program and notify you if a solution is available.

Then “Problem Report and Solutions” window appear.
===========================================

The solution I try :
run this file TortoiseSVNSCC.reg using regedit

PHP error – Unable to initialize module API=20060613 – 20090626

My PHP on Apache error.log show this message :

PHP Warning: PHP Startup: java: Unable to initialize module\nModule compiled with module API=20060613\nPHP compiled with module API=20090626\nThese options need to match\n in Unknown on line 0

The solution :

uncommented 2 lines in php.ini,
;extension=D:\oss\php-5.3.6\ext\php_java.dll
;extension=D:\oss\php-5.3.6\php5servlet.dll

then restart apache, and the message disappear ^_^

Pentaho – Steel Wheels – Analysis – Market Analysis By Year Error

When I click Market Analysis By Year on Steel Wheels | Analysis, I got this error message :

Error Occurred While getting Resultset
An error occurred while rendering Pivot.jsp. Please see the log for details.

So the solution I found :
1. use “Pentaho Schema Workbench”
2. open “steelwheels.mondrian.xml” on “D:\pentaho\pentaho-solutions\steel-wheels\analysis”
3. fix all invalid error messages, like : “Schema must be set, Table DIM_TIME is invalid, Hierarchy is invalid, Table ORDERFACT is invalid, Cube SteelWheelsSales is invalid”
4. publish to
url = http://localhost:8123/pentaho/
location = /steel-wheels/analysis
name = analysis_customers.analysisview.xaction

Then I click again the link, it’s work now, so the “Product Line Analysis”

Tomcat – Pentaho : ‘docbase’ did not find a matching property

I’ve been using Pentaho “biserver-ce-3.8.0-stable” run on Tomcat 7. But everytime I start Tomcat, show some message like this:

May 11, 2011 3:02:13 PM org.apache.catalina.startup.SetContextPropertiesRule begin
WARNING: [SetContextPropertiesRule]{Context} Setting property ‘docbase’ to ‘webapps/pentaho/’ did not find a matching property.

So to get rid of this warning message, I delete

docbase=”webapps/pentaho/”

from

<Context path=”/pentaho” docbase=”webapps/pentaho/”>

in “webapps\pentaho\META-INF\context.xml”. Now, I see Tomcat run smoothly (“INFO: Deploying web application directory pentaho”). ^_^

Netbeans 7 – “Cannot locate java installation in specified jdkhome:”

I’ve installed previous versions of jdk1.6.0_17, and then after installing netbeans 7, I upgrade jdk to version jdk1.6.0_25.

Now, everytime I start Netbeans, it always show me this message :

Cannot locate java installation in specified jdkhome:
C:\Program Files\Java\jdk1.6.0_17
Do you want to try to use default version?

If I click “Yes”, the next time Netbeans started, the same message appear.

 

So to remove this, I change “netbeans.conf” in “C:\Program Files\NetBeans 7.0\etc”.

Change “netbeans_jdkhome” like this :

netbeans_jdkhome=”C:\Program Files\Java\jdk1.6.0_25″

then your Netbeans run as normal. ^_^

Warning On Startup Tomcat – Pentaho

Whenever I start Tomcat to work with Pentaho, I always got like this warning error :

May 11, 2011 1:50:48 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles

INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>

The solution is to add <security-role> to ” tomcat\webapps\pentaho\WEB-INF\web.xml”,after the <security-constraint> tag.

<security-role>

<description>security role assignment for Non-Existent Role – this prevents direct access to JSPs</description>

<role-name>PENTAHO_ADMIN</role-name>

</security-role>