Tuesday, October 30, 2012
Oracle jobs
SELECT JOB_NAME, OWNER, ENABLED FROM DBA_SCHEDULER_JOBS;
Tuesday, October 23, 2012
When I tried to recompile a package in sqlplus, the sqlplus window freezes and has not responding.
When I tried to recompile a package in sqlplus, the sqlplus window freezes and has not responding.
The reason is that some objects you are trying to use is locked. Go and check what locks the object.
Monday, October 22, 2012
AIX 6.1 Time Zone and Daylight Saving Time
Time Zone:
http://www-01.ibm.com/support/docview.wss?uid=isg3T1000252
DST problem:
http://www-01.ibm.com/support/docview.wss?uid=isg3T1013017#formatcompare
Summary:
TZ=EST5EDT,M3.2.0/2:00:00,M11.1.0/2:00:00
If you change the System TZ, you need to reboot the machine for activating the change.
If you change the date, you don't need to do rebooting.
http://www-01.ibm.com/support/docview.wss?uid=isg3T1000252
DST problem:
http://www-01.ibm.com/support/docview.wss?uid=isg3T1013017#formatcompare
Summary:
TZ=EST5EDT,M3.2.0/2:00:00,M11.1.0/2:00:00
If you change the System TZ, you need to reboot the machine for activating the change.
If you change the date, you don't need to do rebooting.
Friday, October 19, 2012
SP2-1503: Unable to initialize Oracle call interface
Problem:
Install everything correctly, but can't use sqlplus from both double-click and command line.
Solution:
Run as adminstrator
Install everything correctly, but can't use sqlplus from both double-click and command line.
Solution:
Run as adminstrator
Set AIX date and time
# date 0819092612
mmddHHMMyy
all see the man page
mm-month
MM-minutes
yy-last two digits of year
mmddHHMMyy
all see the man page
mm-month
MM-minutes
yy-last two digits of year
Saturday, October 13, 2012
Vim setting
set tabstop=4
set shiftwidth=4
set number
set backupdir=c:\vim_backup
vi/vim tips
1.Copy and paste
In normal model:
10yy --Copy next 10 lines
p --Paste the content
2. Tab multiple lines
v -- Go into Visual Mode
shift + direction(h,j,k,l or arrows) -- select lines
> or < -- indent or unindent
In normal model:
10yy --Copy next 10 lines
p --Paste the content
2. Tab multiple lines
v -- Go into Visual Mode
shift + direction(h,j,k,l or arrows) -- select lines
> or < -- indent or unindent
Friday, October 12, 2012
Display the output of oracle procedure
I wrote a simple sample like:
DECLARE
hello varchar(10);
BEGIN
dbms_output.put_line('Hello World');
END;
/
When I run it on sqlplus, it showed: PL/SQL procedure successfully completed. Nothing else.
The solution is:
sqlplus> set serveroutput on
Then you can see the output.
DECLARE
hello varchar(10);
BEGIN
dbms_output.put_line('Hello World');
END;
/
When I run it on sqlplus, it showed: PL/SQL procedure successfully completed. Nothing else.
The solution is:
sqlplus> set serveroutput on
Then you can see the output.
Thursday, October 11, 2012
Unsupported major.minor version 49.0
The application is compiled by java 1.5, but I want to run it on a java 1.4 machine.
Monday, October 8, 2012
java.lang.NoClassDefFoundError: oracle/sysman/eml/app/Console
This issue and solution is stated in ORACLE document at http://docs.tpu.ru/docs/oracle/en/oas/10.1.2.0.2/aix.1012/relnotes.1012/relnotes/install.htm
check OEM status
..../bin/emctl status agent -details
Friday, October 5, 2012
panic: JVMST017: Cannot allocate memory in initializeMarkAndAllocBits(markbits1)
$ ./c_report.sh
Starting to compile report
Converting RPT_005.rdf
Unable to alloc heap of requested size, perhaps the maxdata value is too small - see README.HTML for more information.
**Out of memory, aborting**
*** panic: JVMST017: Cannot allocate memory in initializeMarkAndAllocBits(markbits1)
./c_report.sh[14]: 9437210 IOT/Abort trap(coredump)
Converting RPT_008.rdf
Unable to alloc heap of requested size, perhaps the maxdata value is too small - see README.HTML for more information.
**Out of memory, aborting**
Solution:
http://www-01.ibm.com/support/docview.wss?uid=swg21524989
Tuesday, October 2, 2012
Thread: ORA-01552: cannot use system rollback segment for non-system tablespace
The undo_ xxx is set to manual in my pfile and init-ora. So I changed it to AUTO.
ORA-30012: undo tablespace ‘UNDOTBS01′ does not exist or of wrong type
I modified the undo_tablespace in init-ora file and spfile by changing undotbs01 to undotbs02 and it worked.
liboraInstaller.so (Cannot open or remove a file containing a running program.)
Erroin writing to file
'................/oracle/product/10.2.0/db_1/oui/lib/aix/liboraInstaller.so'.
[................/oracle/product/10.2.0/db_1/oui/lib/aix/liboraInstaller.so (Cannot open or remove a file containing a running program.)]
You will see four options.
click Help
click Retry
click Ignore
click Cancel to stop this installation
The solution is that:
Go to that directory and rename the old file, for example: mv liboraInstaller.so liboraInstaller.so.bak
OUI-18001: The operating system 'AIX Version 6100.05' is not supported.
I am installing ORACLE 10.2.0.2 today on an AIX 6.1 machine. This error poped up when the software is checking the prerequisites of the system. Since AIX 6.1 comes after ORACLE 10.2.0.2, so just ignore the error and keep installing.
Monday, October 1, 2012
Can't shutdown oracle database
Last time, I accidentally deleted the control file and can't shutdown the database by using "shutdown immediate". I was so panic....The solution is that using "shutdown abort"...
TOAD windows 7 (ORA-06413 : Connection Not Open)
Problem:
When using TOAD on Windows 7, it pops up an error:
ORA-06413 : Connection Not Open
Solution:
Copy Quest Software from C:\Program(x86) to C:\Program
When using TOAD on Windows 7, it pops up an error:
ORA-06413 : Connection Not Open
Solution:
Copy Quest Software from C:\Program(x86) to C:\Program
alert log
Check Alert Log for the detailed error messages under ORACLE_HOME/admin/db_name/bdump/alert.log
refer to http://www.adp-gmbh.ch/ora/concepts/alert_log.html
refer to http://www.adp-gmbh.ch/ora/concepts/alert_log.html
Subscribe to:
Posts (Atom)