Installing Oracle 10g Solaris10.

Checking Requirement:

—————————-

#/usr/sbin/prtconf | grep “Memory size” [Check RAM size]
# /usr/sbin/swap -s [check swap]
# df -k /tmp [check /tmp size (>400mb)]
# uname -r [check solaris version]

# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt

# cat /etc/nsswitch.conf | grep hosts
# hostname
# domainname


---------------------------------------------------------------------------------
RUN INSTALL:
---------------------------------------------------------------------------------
A. create group name “dba”, oracle inventory group “oinstall” and “oracle” user

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba

{Determine oracle user exist or not
# id -a oracle
{if exist, should be look like this=
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)

{create oracle user=
# useradd -d /export/home/oracle -g dba -G oinstall -m -s /bin/ksh oracle

#mkdir /export/home/oracle
#chown oracle:dba /export/home/oracle

{set password=
# passwd -r files oracle

{to determine nobody user=
# id nobody
# /usr/sbin/useradd nobody >>run if does not exist

B. EDIT FILE /export/home/oracle/.profile
————————————–
umask 022
TMP=/tmp
TMPDIR=$TMP
DISPLAY=localhost:0.0
export TMP TMPDIR DISPLAY
ORACLE_BASE=/u01/app/oracle [replace with ur Oracle base Directory]
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 [replace with ur Oracle home Directory]

ORACLE_SID=jktdb [replace with your database]
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

C. Configure Kernel Parameter
—————————–
Note: Do not follow the official installation instruction, they contain misleading and out errors of fact!

#projadd oracle [This command will create a new 'resource project']
edit the /etc/user_attr file:
adm::::profiles=Log Management
lp::::profiles=Printer Management
root::::auths=solaris.*,solaris.grant;profiles=Web Console Management,All;lock_after_retries=no

oracle::::project=oracle [add this line]

then:

#su – oracle
$ id -p
$ prctl -n project.max-shm-memory -i project oracle

The display look like this:
project: 100: oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 126MB – deny -
system 16.0EB max deny -

leaving the oracle user still connected in the original one Then, as root in the new terminal, you can issue this command:

#prctl -n project.max-shm-memory -v 4gb -r -i project oracle [create max memory to 4GB]

As soon as you’ve issued that command, switch back to the oracle user’s session and re-issue the earlier command:

$ prctl -n project.max-shm-memory -i project oracle

Note:
#prctl -n project.max-shm-memory -v 4gb -r -i project oracle [this setting will lost after reboot]
to set permanently, run this: #projmod -s -K “project.max-shm-memory=(priv,4gb,deny)” oracle

D. Performing the Oracle Installation
————————————-
#su – oracle
$xhost +
$export DISPLAY=localhost;0.0
$ xhost + >>run this if you install from remote PC
$ cd /export/home/database/ [the source unzipped here]

./runInstaller

FOR SOLARIS SPARC:
====================
$ gunzip ship_rel10_sol64_db.cpio.gz
$ cpio -idm < ship_rel10_sol64_db.cpio $./runInstaller If you found unsufficient SWAP disk space on your disk, create folder under / then run this command: ————————————————— $ TMP=/directory $ TMPDIR=/directory $ export TMP TMPDIR Follow the screen>>NEXT>>NEXT

last, run this as root user:
—————————-
/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/10.2.0/db_1/root.sh

Create db:
———-
orc1
jktdb

E. 6.0 On-going Administration
——————————–
Finally, it’s time to get the web-based Enterprise Manager database administration tool up and running.
Since we’re using 10g Release 2, you should be able to launch a browser (Launch -> Web Browser) and simply navigate to : http://localhost:1158/em

If you do not know the correct port number to use, look for the following line in the $ORACLE_HOME/install/portlist.ini file.

in order to be able to log on as SYS with a password of whatever you supplied to the first screen of the Oracle installation wizard. In fact, getting a meaningful result at this point relies on three things having been performed successfully:

1. starting a listener (lsnrctl start)
2. opening the database (sqlplus / as sysdba then startup)
3. starting the Enterprise Manager agent (emctl start dbconsole)

F. Automating Database Startup
———————————————–
edit file “/var/opt/oracle/oratab” script to find lines with ‘Y’ at their ends
Create file “/etc/init.d/dbora”
——-
#!/bin/sh
ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo “Oracle startup: cannot start”
exit
fi

case “$1″ in
‘start’)
su – $ORA_OWNER -c “$ORA_HOME/bin/dbstart”
;;
‘stop’)
su – $ORA_OWNER -c “$ORA_HOME/bin/dbshut”
;;
esac

———
#chmod 777 /etc/init.d/dbora
#/etc/init.d/dbora stop

To integrate dbora file to standart Solaris startup and shutdown process:
————————————————————————
#ln -s /etc/init.d/dbora /etc/rc0.d/K01dbora
#ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora

IF u found error this:
———————–
ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

edit file “dbstart” & “dbshut”, find line $ORACLE_HOME_LISTNER=$1

and change to = $ORACLE_HOME_LISTNER=/u01/app/oracle/product/10.2.0/db_1

RECOMMENDED DIRECTORY STRUCTURE:
———————————————-

[Oracle Base Directory:]
/u01/app/oracle
/u01/app/orauser
/opt/oracle/app/oracle

[Oracle Inventory Directory:]
ORACLE_BASE/oraInventory

[Oracle Home Directory:]

ORACLE_BASE/product/10.2.0/db_1

[Identify an existing oracle base directory:]
#more /var/opt/oracle/oraInst.loc
[the output should be:]

inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall

# more /var/opt/oracle/oratab

*:/u03/app/oracle/product/10.2.0/db_1:N

*:/opt/orauser/infra_904:N

*:/oracle/9.2.0:N

COMMON INSTALLATION ERROR:
===========================
Unable to convert from “UTF-8″ to “646″ for NLS!
Solution: Install SUNWuiu8 package.

error adduser:
———————
UX: useradd: ERROR: Inconsistent password files. See pwconv(1M)

This is because the /etc/passwd and /etc/shadow files are out of synchronization on your machine. [CSCdi74894]
To fix this, run the pwconv command, and then rerun cwconfigure.

try to run:

wc -l /etc/passwd /etc/shadow

————–
ERROR Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for
display colors using command /usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before continuing with theinstallation, at which time they will be rechecked.

Solution(s):
1. Install SUNWxwplt package
2. Set DISPLAY variable
3. Execute xhost + on target (set in DISPLAY) computer

———————————————————-
Exception in thread “main” java.lang.UnsatisfiedLinkError:
… libmawt.so: ld.so.1: java: fatal: libXm.so.4: open failed: No such file or directory

Solution: Install the SUNWmfrun package.

—————————————————————————————————-
Can’t load ‘/usr/perl5/5.8.4/lib/i86pc-solaris-64int/auto/Sun/Solaris/Project/Project.so’ for module
Sun::Solaris::Project: ld.so.1: perl: fatal: libpool.so.1: open failed: No such file or directory at
/usr/perl5/5.8.4/lib/i86pc-solaris-64int/DynaLoader.pm line 230. at /usr/sbin/projadd line 19 Compilation
failed in require at /usr/sbin/projadd line 19. BEGIN failed–compilation aborted at /usr/sbin/projadd line 19.

Solution: Install the SUNWpool SUNWpoolr packages.

———————————————————————–
bash-3.00$ /u01/app/oracle/product/10.2.0/db_1/bin/./emctl start dbconsole
Exception in getting local host
java.net.UnknownHostException: -a: -a
at java.net.InetAddress.getLocalHost(InetAddress.java:1191)
at oracle.sysman.emSDK.conf.TargetInstaller.getLocalHost(TargetInstaller.java:4977)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3758)
Exception in getting local host

Solution : check server hostname and /etc/hosts
————————————————————————-

UNINSTALL ORACLE 10G:
———————
1. remove all database, by running $dbca
2. stop any oracle process running:
Database Control : $ORACLE_HOME/bin/emctl stop dbconsole
Oracle Net listener : $ORACLE_HOME/bin/lsnrctl stop
iSQL*Plus : $ORACLE_HOME/bin/isqlplusctl stop
Ultra Search : $ORACLE_HOME/bin/searchctl stop

3. Start Oracle Universal installer:

$ORACLE_HOME/oui/bin/runInstaller

4. In the Welcome window, click Deinstall Products.
5. In the Inventory screen, select the Oracle home and the products that you want to remove,
then click Remove.

Pengertian VAS

Untuk yang bergelut di dunia Content Provider mungkin istilah VAS / VASP mungkin tidak asing lagi.
Buat yang ngerti tentang VAS ini maka mengutip dari Wikipedia.org :

A value-added service (VAS) is a telecommunications industry term for non-core services or, in short, all services beyond standard voice calls. On a conceptual level, value-added services add value to the standard service offering, spurring the subscriber to use their phone more and allowing the operator to drive up their ARPU. For mobile phones, while technologies like SMS, MMS and GPRS are usually considered value-added services, a distinction may also be made between standard (peer-to-peer) content and premium-charged content.

Value-added services are supplied either in-house by the mobile network operator value-added service provider (VASP). VASPs typically connect to the operator using protocols like Short message peer-to-peer protocolshort message service centre (SMSC) or, increasingly, to a messaging gateway that allows the operator to control and charge of the content better. themselves or by a third-party (SMPP), connecting either directly to the short message service centre (SMSC) or, increasingly, to a messaging gateway that allows the operator to control and charge of the content better.

Singkatnya para Content Provider (CP) membuat layanan dengan bekerja sama dengan operator dan berkomunikasi dengan protocol tertentu yang disepakati.
Dengan demikian maka CP dapat memberikan layanan kepada pengguna ponsel dan melakukan charging sesuai layanan tersebut.

Layanan-layanan yang populer saat ini:

Download wallpaper/image
Download ringtone/music
Quiz berhadiah
Ringbacktone (VAS yang palink populer/menguntungkan didunia?)
Download aplikasi/game mobile
Dll -> Layanan-layanan unik lainnya
Demikian pengenalan mengenai VAS untuk hari

ORA-00371

#ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
solution

edit init.ora


#ORA-00205: error in identifying control file, check alert log for more info

ORA-01078: LRM-00109 :

-> hari minggu pagi ini dapet sarapan
#ORA-01078: failure in processing system parameters
#LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora'
di vbox gw,, karna gw mo yobail biki simulasi oracle to oracle replicte..
tdi mlm gw install oracle di RHEL 05 di vbox, pass beres install oracle na gw startup ehh
keluar error tdi..

ngembah google dulu....

nie solutionnya

-> cari init,pfile atau spfile

[oracle@redhost ~]$ find $ORACLE_BASE -name init*.ora
/u01/app/oracle/product/10.2.0/db_1/srvm/admin/init.ora
/u01/app/oracle/product/10.2.0/db_1/dbs/init.ora <--
/u01/app/oracle/product/10.2.0/db_1/dbs/initdw.ora
/u01/app/oracle/product/10.2.0/db_1/hs/admin/inithsodbc.ora

-> start database
SQL> startup pfile ='/u01/app/oracle/product/10.2.0/db_1/dbs/init.ora'

cara menghitung achivelog perhari

# nie cara menghitung perharinya

SQL> select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1;

TIME SIZE_MB
---------- ----------
2011-02-12 71797.87
2011-02-13 75880.52
2011-02-14 73569.37
2011-02-15 76776.81
2011-02-16 73959.86
2011-02-17 69969.71
2011-02-18 74677.10
2011-02-19 75474.95
2011-02-20 77967.07
2011-02-21 67802.70

# ini perjamnya

SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24';
Session altered.

SQL> select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'HH24') order by 1;

TIME SIZE_MB
------------- ----------
2011-02-21 00 6396.65
2011-02-21 01 2797.31
2011-02-21 02 2010.45
2011-02-21 03 1871.77
2011-02-21 04 1481.5
2011-02-21 05 2868.20
2011-02-21 06 2363.89
2011-02-21 07 4269.26
2011-02-21 08 2469.08
2011-02-21 09 3007.06
2011-02-21 10 3561.97
2011-02-21 11 2530.57
2011-02-21 12 3509.08
2011-02-21 13 3022.5
2011-02-21 14 3514.97
2011-02-21 15 4057.45
2011-02-21 16 3021.27
2011-02-21 17 4014.31
2011-02-21 18 4011.66
2011-02-21 19 4008.10
2011-02-21 20 3015.46

# gimana klo RAC??

SQL> select INST_ID, RECID, NAME, to_char(COMPLETION_TIME,'YYYY-MM-DD HH24:MI:SS'), ARCHIVAL_THREAD# , blocck * block_size from GV$ARCHIVED_LOG order by COMPLETION_TIME;

INST_ID RECID NAME TO_CHAR(COMPLETION_ ARCHIVAL_THREAD#
---------- ---------- -------------------------------------------------- ------------------- ----------------
4 258572 +ARCH/DB/4_73214_617849235.dbf 2011-02-21 20:29:52 4
2 258572 +ARCH/DB/4_73214_617849235.dbf 2011-02-21 20:29:52 4
1 258572 +ARCH/DB/4_73214_617849235.dbf 2011-02-21 20:29:52 4
3 258572 +ARCH/DB/4_73214_617849235.dbf 2011-02-21 20:29:52 4
1 258573 +ARCH/DB/1_55739_617849235.dbf 2011-02-21 20:44:22 1
3 258573 +ARCH/DB/1_55739_617849235.dbf 2011-02-21 20:44:22 1
4 258573 +ARCH/DB/1_55739_617849235.dbf 2011-02-21 20:44:22 1
2 258573 +ARCH/DB/1_55739_617849235.dbf 2011-02-21 20:44:22 1

# klo RAC perhari??

SQL> select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME) order by 1;

TIME SIZE_MB
---------- ----------
2011-02-12 71797.87
2011-02-13 75880.52
2011-02-14 73569.37
2011-02-15 76776.81
2011-02-16 73959.86
2011-02-17 69969.71
2011-02-18 74677.10
2011-02-19 75474.95
2011-02-20 77967.07
2011-02-21 67802.70

# klo RAC perjama??

SQL> alter session set nls_date_format = 'YYYY-MM-DD HH24';

Session altered.

SQL> select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'HH24') order by 1;

TIME SIZE_MB
------------- ----------
2011-02-21 00 6396.65
2011-02-21 01 2797.31
2011-02-21 02 2010.45
2011-02-21 03 1871.77
2011-02-21 04 1481.5
2011-02-21 05 2868.20
2011-02-21 06 2363.89
2011-02-21 07 4269.26
2011-02-21 08 2469.08
2011-02-21 09 3007.06
2011-02-21 10 3561.97
2011-02-21 11 2530.57
2011-02-21 12 3509.08
2011-02-21 13 3022.5
2011-02-21 14 3514.97
2011-02-21 15 4057.45
2011-02-21 16 3021.27
2011-02-21 17 4014.31
2011-02-21 18 4011.66
2011-02-21 19 4008.10
2011-02-21 20 3015.46


ada ide lain ??? :)


souce :[http://surachartopun.com]

Installing mysql di fedora 14

#curhat :D
hari nie gw baru install Fedora d labtop Acer tua gw,
tadi nya gw mo install backtrack 4rc eeh cd na rusak gtu, bete :(
akhirnya gw ngubek" barak gw(kamar :p), eh nemu fedora 14, dari pada ga ada yacg daah gw install
daah beres install pertama dapet masalah adalah dia turunan red hat yg ga suport mp3..
ngubek" s embah akhirnya nemu jga cara buat yetel mp3nya :D

karna gw kangen ma java(biarpun ga ada bakat sama sekali ;p) gw download eclipse ma mysql

trus gw coba kan
#yum install mysql-server
daah beres install dan download
gw coba kan command
#mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysq/mysql.sock' (2)

arrrrggggg
gogling lagi....

coba sana sini
yg sukses yg nie nie :D :

[souce tutorial: http://www.if-not-true-then-false.com] cek aja gan ada centos dan kawan"nya :D

---------------
ni step" na :D :

- jadi root supaya bisa install :)
# su -

- Remi Dependency on Fedora 14, 13, 12, 11, 10, 9, 8
# rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
# rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm

-fedora 14
# rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm


-check list paket yg tersedia
# yum --enablerepo=remi list mysql mysql-server

-install atau update mysql
# yum --enablerepo=remi install mysql mysql-server

-start servises mysql
# /etc/init.d/mysqld start

-mulai isntall mysql
/usr/bin/mysql_secure_installation

isi dengan kebutuhan anda :). selamat berfedora :)

Purge Oracle 10g

purge sangat berguna "saat anda benar" ingin menghapus table"

dalam 10g, tables bisa d "undropped":

ops$tkyte@ORA10G> desc t;
Name Null? Type
---------------------------------------- -------- ----------------------------
X VARCHAR2(2000)

ops$tkyte@ORA10G> select count(*) from t;

COUNT(*)
----------
0

ops$tkyte@ORA10G> drop table t;

Table dropped.

ops$tkyte@ORA10G> desc t;
ERROR:
ORA-04043: object t does not exist


ops$tkyte@ORA10G> select count(*) from t;
select count(*) from t
*
ERROR at line 1:
ORA-00942: table or view does not exist


ops$tkyte@ORA10G> flashback table t to before drop;

Flashback complete.

ops$tkyte@ORA10G> desc t;
Name Null? Type
---------------------------------------- -------- ----------------------------
X VARCHAR2(2000)



di dalam logic, kita membuat "drop table t" into " tapi sebenarnya kita menyembunyikanya seperti reciclebyn jendela :p
consider:

ops$tkyte@ORA10G> drop table t;
Table dropped.

ops$tkyte@ORA10G> select table_name from user_tables;
no rows selected

ops$tkyte@ORA10G> select object_name from recyclebin;

OBJECT_NAME
------------------------------
BIN$7oTtcup30ZfgMAGK/3hjKw==$0

ops$tkyte@ORA10G> flashback table t to before drop;
Flashback complete.

ops$tkyte@ORA10G> select object_name from recyclebin;
no rows selected

ops$tkyte@ORA10G> select table_name from user_tables;

TABLE_NAME
------------------------------
T

ops$tkyte@ORA10G>


jadi, setiap anda men drop table, sebenarnya kita menyembunyikannya -- tidak seluruhnya menghapusnya (sama dengan
indexes, etc)


anda mungkin ingin agar situasi ini tidak terjadi. kadang kala
(poorly written) aplication yg membuat creates dan drops ratusan "scratch" tables (instead
of using global temporary tables created once...)

itu, bisa membuat banjir data dictionary dengan ratusan atau ribuan object yg di sembunyikan ini
-- ini mengakibatkan queries ke dictionary menjadi slow down. anda mungkin menginginkan table ini benar hilang.

jadi, anda dapate menggunakan drop table T purge:

ops$tkyte@ORA10G> drop table t purge;

Table dropped.

ops$tkyte@ORA10G> select table_name from user_tables;

no rows selected

ops$tkyte@ORA10G> select object_name from recyclebin;

no rows selected

ops$tkyte@ORA10G>


atau anda bisa menggunakan purge untuk purge all dropped objects d database atau table space, scema.

souce asktom.oracle.com

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 :)

: 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 :))

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

./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 :)

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