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 :)
Saturday, January 15, 2011
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 :))
/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
(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 :)
./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
* 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
Subscribe to:
Posts (Atom)