Saturday, January 15, 2011

Uninstall oracle 10g

1. Uninstall software Oracle 10g lewat Control panel : Control panel -> Add/Or
Remove Program -> Remove Oracle 10g

2. Matikan servis Oracle 10g : Run -> services.msc -> Matikan seluruh servise
Oracle 10g

3. Hapus seluruh registry di regedit : Run -> regedit -> Hapus file berikut:

- HKEY_CURRENT_USER\Software\Oracle
- HKEY_LOCAL_MACHINE \ SYSTEM\CurrentControlSet \ Services \ OracleDBConsoleorcl
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
OracleJobSchedulerORCL
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
OracleOraDb10g_home1iSQL*Plus
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
OracleOraDb10g_home1SNMPPeerEncapsulator
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
OracleOraDb10g_home1SNMPPeerMasterAgent
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
OracleOraDb10g_home1TNSListener
- HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ OracleServiceORCL

4. Restart komputer.

5. Hapus File dan directory Oracle 10g tempat instalasi Oracle.

6. Tidak lupa file yang ada di direktori C:\Program Files\Oracle juga perlu
dihapus.

selamat beroracle :)

Friday, January 14, 2011

: no version information available (required by /usr/bin/python)

ubuntu command terminal gw tiba begini setelah gw oprek nginstall Zend Server CE :D

/usr/bin/python: /usr/local/zend/lib/libcrypto.so.0.9.8: no version information available (required by /usr/bin/python)
/usr/bin/python: /usr/local/zend/lib/libssl.so.0.9.8: no version information available (required by /usr/bin/python)

setelah googling nie solusinya

# sudo mv /usr/local/zend/lib/libssl.so.0.9.8 /usr/local/zend/lib/libssl.so.0.9.8.hold
# sudo mv /usr/local/zend/lib/libcrypto.so.0.9.8 /usr/local/zend/lib/libcrypto.so.0.9.8.hold

yg di atas maksudnya supaya tak terbaca system na :D

# oracle@freakyhost-Rev-1-0:~$ sudo /usr/local/zend/bin/zendctl.sh start
Starting Zend Server 5.0.4 ..

httpd: Could not reliably determine the server's fully qualified domain name, using ::1 for ServerName
/usr/local/zend/bin/apachectl start [OK]
spawn-fcgi: child spawned successfully: PID: 4915
Starting Zend Server GUI [Lighttpd] [OK]
[ 15.01.2011 17:21:37 SYSTEM] watchdog for lighttpd is running.
[ 15.01.2011 17:21:37 SYSTEM] lighttpd is running.

note : efeksamping pada Zend Server CE blum d ketahui :D

selamat berubuntu :))

Friday, January 7, 2011

error 13, Permission denied for file ./dirchk/*.cpe

Error opening checkpoint for EXTRACT EU01
(error 13, Permission denied for file /ogg01/oragg/dirchk/EU01.cpe)

ubah file permision d dirchk/ dengan chown/chmod

exsample : chown [UserOsOgg]:[GroupOgg] dirchk/*.cpe

Tuesday, January 4, 2011

./ggsci: error while loading shared libraries: libnnz10.so

root@freakyhost-Rev-1-0:/ogg01/gg_souce# ./ggsci
./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory


lib itu ternyata terletak pada ORACLE_HOME.

oracle@freakyhost-Rev-1-0:/ogg01/oragg$ find $ORACLE_HOME -name libnnz10.so
/u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so

root@freakyhost-Rev-1-0:/# ln -s /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so libnnz10.so

dan satu lagi libnya.

oracle@freakyhost-Rev-1-0:/ogg01/oragg$ find $ORACLE_HOME -name libclntsh.so.10.1
/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1

root@freakyhost-Rev-1-0:/# ln -s /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 libclntsh.so.10.1


selamat berOGG Ora gelar gelar klo kata PM gw :p

FYI:
gw pake ogg V22227-01 untuk Oracle_GoldenGate_V11.1.1.0.0_for_Oracle_10g_on_Linux_x86_V22227-01.zip
di Ubuntu 10.10 :)

Monday, January 3, 2011

exp-00091 exporting questionable statistics

The precalculated optimizer statistics are flagged as questionable at export time if:

* There are row errors while exporting
* The client character set or NCHAR character set does not match the server character set or
NCHAR character set
* A QUERY clause is specified
* Only certain partitions or subpartitions are exported

If a table is missing the columns specified in the QUERY clause, an error message will be produced, and no rows will be exported for the offending table.

Restrictions
The parameter QUERY cannot be specified for full, user, or tablespace mode exports.
The parameter QUERY must be applicable to all specified tables.
The parameter QUERY cannot be specified in a direct path export (DIRECT=y)
The parameter QUERY cannot be specified for tables with inner nested tables.
You cannot determine from the contents of the export file whether the data is the result of a QUERY export.


Suggestion:
When OS character set different that ORACLE character set then BEFORE export you should set NLS_LANG=.CHARACTERSET according Oracle Database Character set.
Example : Oracle 10gr2 on Linux version 4
OS NLS_LANG = US7ASCII
Oracle NLS_LANG = WE8IS0XXXXX

Just Before export set NLS_LANG like
$export NLS_LANG=.WE8ISOXXXXX
$export your_data

Example on windows


First check "NLS_CHARACTERSET" of database through below query

SQL> select VALUE
2 from nls_database_parameters
3 where PARAMETER = 'NLS_CHARACTERSET';

VALUE
----------------------------------------
WE8MSWIN1252


On command prompt

c:\> set NLS_LANG=.WE8MSWIN1252

Souce Site