Thu, 03 Sep 2009 02:45:05 +0700 http://dedisys.or.id/ DediSys en-us http://dedisys.or.id/images/dedisys_logo.gif http://dedisys.or.id/ admin@dedisys.or.id http://dedisys.or.id/index.php?name=News&file=article&sid=32 To disable a user to connecting to Database login using connect "/ as sysdba" after login to OS : 1. In $ORACLE_HOME/network/admin/sqlnet.ora file modify the following line to SQLNET.AUTHENTICATION_SERVICES=(NONE) 2. Restart listener, with this command : lsnrctl stop lsnrctl start or Remove dba group to the user who is logging in to the OS. Note : orapwd file is used to authenticate users over the network only. Users who already logged in to the Database can not be restricted to connect '/ as sysdba' until they logout. --- Dedi Thu, 03 Sep 2009 02:45:05 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=31 For ENABLE restricted access : Edit the sqlnet.ora file in $ORACLE_HOME/network/admin/ : change "tcp.validnode_checking = yes" and "tcp.invited_nodes=(myhost,172.16.3.251)" only "myhost" and host with ip "172.16.3.251" can connect to database. this the content of sqlnet.ora file : ... NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10 tcp.validnode_checking = yes tcp.invited_nodes=(myhost,172.16.3.251) ... For DISABLE restricted access : change "tcp.validnode_checking = no" so, every client can connect to database. this the content of sqlnet.ora file : ... NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10 tcp.validnode_checking = no tcp.invited_nodes=(myhost,172.16.3.251) ... You must restart the oracle listener to activated that new setting above, with the following command : lsnrctl stop lsnrctl start --- Dedi Thu, 03 Sep 2009 02:33:50 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=30 Purpose I'm working on building a python app that needs to connect to an existing Oracle Database. The server it will be deployed on is Ubuntu 9.04 Server - 32 bit. No gui is installed. When I started down the road of installing Oracle Instant Client and cx_Oracle, I ran into several problems. I was able to find bits and pieces on the web that helped me along, but I did not find an all in one document. I'm sure there are some out there, but my Google-fu failed me. Sat, 25 Jul 2009 15:12:59 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=29 Oracle Applications (11.5.10.2) Installation on Oracle Enterprise Linux 4.5 This article is intended as a brief guide to installing Oracle Applications (11.5.10.2) on Oracle Enterprise Linux 4.5. The article is based on a server installation with a minimum of 2G swap, secure Linux disabled and the following package groups installed: X Window System GNOME Desktop Environment Editors Graphical Internet Server Configuration Tools Development Tools Administration Tools System Tools Tue, 07 Jul 2009 03:33:27 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=28 ORA-02068: following severe error from DBLINK ORA-03113: end-of-file on communication channel ORA-02068: following severe error from DBLINK ORA-00603: ORACLE server session terminated by fatal error ORA-00604: error occurred at recursive SQL level 52 ORA-00036: maximum number of recursive SQL levels (50) exceeded ORA-00604: error occurred at recursive SQL level 52 ORA-00036: maximum number of recursive SQL levels (50) exceeded Thu, 11 Jun 2009 10:36:58 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=27 ESC key button = CTRL + [ Sat, 30 May 2009 13:44:19 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=26 OCFS2: ocfs2console fails to add node: "o2cb_ctl: Unable to access cluster service while creating node" Thu, 30 Apr 2009 07:47:29 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=25 Howto: Configure Linux Virtual Local Area Network (VLAN) Tue, 07 Apr 2009 05:02:19 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=23 In order to configure serial ports for Linux, you will need to make use of the setserial command. Firstly, you will need to know the card's base address and and which IRQ it is using. For an ISA card, this can be read off the jumpers on the card. Mon, 02 Mar 2009 15:56:05 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=22 metastat | grep done If the output is blank, that's mean the process synchronization is done. Sun, 01 Mar 2009 01:07:36 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=21 Edit in file: /etc/udev/rules.d/70-persistent-net.rules Change the 'eth0 to eth1'. Sat, 28 Feb 2009 13:12:06 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=20 Minicom --> console / text based terminal Minicom is a clone of the MS-DOS "Telix" communication program. It emulates ANSI and VT102 terminals, has a dialing directory and auto zmodem download. CuteCom Cutecom is a graphical serial terminal, like minicom. It is aimed mainly at hardware developers or other people who need a terminal to talk to their devices. It features lineoriented interface instead of character-oriented, xmodem, ymodem, zmodem support (requires the lrzsz package) and hexadecimal input and output among other things. It is written using the Qt library by Trolltech (www.trolltech.com). If using with USB to Serial(RS232) Port Converter, by default the device is : /dev/ttyUSB0 or /dev/ttyUSB1 Sat, 28 Feb 2009 09:00:53 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=19 libpng12.so.0: no version information available Sat, 07 Feb 2009 08:06:51 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=18 For VMware-workstation-5.5.0-18463.tar.gz Steps required to get VMware Workstation 5.5.0 installed on Ubuntu 5.10 system on i686. 1. Install the required compiler and kernel headers needed to compile the vmware kernel module. sudo apt-get install linux-headers-$(uname -r) build-essential g++-3.4 2. Download VMWare Workstation 5.5 from VMware and unpack it. tar xzf VMware-workstation-5.5.0-18463.tar.gz 3. Run the VMware install script. ( cd vmware-distrib && sudo ./vmware-install.pl ) It is safe to take all the defaults. Sat, 07 Feb 2009 07:57:39 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=17 HaloHybrid card : *888# *889# switch to prepaid *888*773# switch to postpaid *888*767# HaloFlash Unlimited card : *999# sms 333 halo internet apn: internet user: blank pwd: blank Sat, 07 Feb 2009 07:17:38 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=16 ------------------------------------- This is my backup wvdial.conf ------------------------------------- Sat, 07 Feb 2009 07:08:25 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=15 Install PPTP plugin for Network Manager applet (http://www.gnome.org/projects/NetworkManager/) sudo apt-get install pptp-linux network-manager-pptp sudo /ect/init.d/dbus restart VPN Setup : 1. Click on the Network Manager applet in your system tray, and select VPN Connections --> Configure VPN… 2. Click Add and follow the wizard to begin configuration. - "Create VPN Connection" --> click Forward - "Create VPN Connection - 1 of 2" --> Connect To: "pptp tunnel" --> Click Forward - "Create VPN Connection - 2 of 2" on Connection Tab : Enter a name for the connection (eq. yg-vpn-1) , on Type : Choose "Windows VPN (PPTP)", on Gateway : enter the address of the VPN server (eq. 202.123.123.22). on Authentication Tab : only checked : "Refuse CHAP" on Compress & Encryption Tab : leave as default on PPP Options Tab : uncheck "Use Peer DNS", the others leave as default on Routing Tab : uncheck "Peer DNS through tunnel", the others leave as default or change as you need. - Click "Forward" - Click "Apply" 3. Connect to Windows VPN Server (PPTP) Click on the Network Manager applet in your system tray, and select VPN Connections --> Choose your VPN Name (eq. yg-vpn-1), put your user name and password. Once connected, Network Manager will display a "lock" icon on your connection, signifying that your secure tunnel is in place. Done ! OK. You can connect to your Windows VPN Server (PPTP) ! Sat, 07 Feb 2009 02:26:34 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=14 If you have problem like this when run : srvctl start database -d orcl PRKP-1001 : Error starting instance orcl2 on node rac02 CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.orcl.orcl2.inst' has placement error. PRKP-1001 : Error starting instance orcl3 on node rac03 CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.orcl.orcl3.inst' has placement error. PRKP-1001 : Error starting instance orcl4 on node rac04 CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.orcl.orcl4.inst' has placement error. and, you must do like this : /etc/init.d/init.crs stop wait 5 minute /etc/init.d/init.crs start and start again : srvctl start database -d orcl [oracle@rac01 ~]$ srvctl status instance -d orcl -i orcl1 Instance orcl1 is running on node rac01 [oracle@rac01 ~]$ srvctl status instance -d orcl -i orcl2 Instance orcl2 is running on node rac02 [oracle@rac01 ~]$ srvctl status instance -d orcl -i orcl3 Instance orcl3 is running on node rac03 [oracle@rac01 ~]$ srvctl status instance -d orcl -i orcl4 Instance orcl4 is running on node rac04 Thu, 05 Feb 2009 10:18:39 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=13 ( O2 Atomlife as A Modem 3G / HSDPA ) How to connect to HSDPA/3G trough USB with Linux and Windows Mobile 6. Thu, 29 Jan 2009 08:40:50 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=12 sdb_ftp_auto.sh #!/bin/sh # ftp_auto.sh : Non-interaktif get data via ftp # And write to tape or another device. # Copyright (c)2001 Dedi Mulyadi # Script by Dedi++ dedisys@yahoo.com # 2001-02-03 12:05 ########################################################### TGL=`date '+%Y%m%d_%H%M%S'` #LCD='/u3/oradata/arch' LCD='/u3/oradata/arch/tmp' #RCD='/u3/oradata/arch' RCD='/home/oracle/arch' LOG='/home/oracle/script/ftp_auto.'$TGL'.log' ARCH='arch*.*' echo ' ' echo 'Ftp data arch from Production, starting ...' echo 'Please wait ...' echo ' ' ftp -n > $LOG o 192.11.12.27 user oracle oracle bin prompt lcd $LCD cd $RCD mget $ARCH bye EOF cd $LCD echo ' ' echo 'Getting data arch ... done.' echo ' ' echo 'Starting Backup arch to tape ...' echo ' ' ###tar rv $ARCH tar rvf /u4/arch.$TGL.tar $ARCH echo ' ' echo ' Horaay ... Done!' echo ' ' ### End of Script ### Tue, 20 Jan 2009 03:53:11 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=11 Maximum Size 16M :    File php.ini settings: file_uploads = on upload_max_filesize = 16M post_max_size = 16M max_file_size = 16M File bb_upload.php : if (isset($_POST['Submit'])=="Submit"){ $x=$_FILES['FileUpload']['name']; $d=$_SESSION['ls']."/".basename($_FILES['FileUpload']['name']); $note = ""; if (!move_uploaded_file($_FILES['FileUpload']['tmp_name'], $d)) { $note = "Failed to upload file. ".$x." to ".$d; }else{ $note = $note." "."File '".$x."' has been uploaded to ".$d.", with size ".$_FILES['FileUpload']['size']; } } --- Dedi Wed, 14 Jan 2009 04:51:17 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=10 prtconf|grep Mem prtdiag Tue, 13 Jan 2009 03:36:13 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=9 cd /tmp #file libXau.la: cp /usr/lib/libXau.a ./ libtool link gcc -g -O -o libXau.la libXau.a -lm #file libXdmcp.la: cp /usr/lib/libXdmcp.a ./ libtool link gcc -g -O -o libXdmcp.la libXdmcp.a -lm Fri, 09 Jan 2009 09:29:37 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=8 # date; ntpdate -u 172.16.1.6 ; date # date; hwclock --set --date="`date '+%m/%d/%y %H:%M:%S'`"; date for changing the time zone : (in debian system or derivation), using command : # tzconfig Fri, 09 Jan 2009 09:24:31 +0700 http://dedisys.or.id/index.php?name=News&file=article&sid=6 After installation of Oracle Express, I can access database via browser from local PC : http://localhost:8080/apex or http://127.0.0.1:8080/apex. But, I can not access from another pc, http://myhost:8080/apex. This is the solution : Wed, 10 Sep 2008 04:32:42 +0700