We're moving to hollyghozi.wordpress.com!

I’m moving this blog to my own domain. Please follow the link hollyghozi.wordpress.com See you there!

Eclipse: Security Manager for Eclipse

Sometime you need to start RMI application inside your eclipse, to do this, you need to edit the eclipse.ini file

-D-Djava.security.manager -Djava.security.policy="server.policy"

Then create a file in eclipse directory security.conf with the following values:
grant
{
permission java.security.AllPermission;
};

And then start your eclipse

Oracle: Drop database 10g

Steps to drop your 10g database:

bash$sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jun 24 17:40:08 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup restrict mount;
ORACLE instance started.

Total System Global Area 838860800 bytes
Fixed Size 2076464 bytes
Variable Size 805306576 bytes
Database Buffers 25165824 bytes
Redo Buffers 6311936 bytes
Database mounted.
SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

All files that relate with the database control-file will be deleted as well. But all other file, *dump, password file, pfile still intact. If you wish to delete completely, use $ORACLE_HOME/bin/dbca

XSL: Accessing child or parent node

For example, accessing the child node which the column_node_01 equal to 'a' :
<xsl value="parent_node[child_column_node_01='a']/child_column_node_02"/>

From child node, accessing the parent node, as easy as :
<xsl value="../../parent_column_node_01"/>

It's easy playing with XML/XSL.... :)

Cisco: User access from HTTP

When I try to configure the web access to my catalyst 2970 switch. After googling, I found the clue from here. I have to change the authentication method of the switch first, below is the step I use when connected to my switch using serial connection.

#enable
#config terminal
(config)#aaa new-model
(config)#aaa authentication login default local
(config)#aaa authorization exec local
(config)#username one privilege 15 password one
(config)#username three password three
(config)#username four privilege 7 password four
(config)#ip http server
(config)#ip http authentication aaa(config)#end
#end

and then I try to connect it through web.. and walaaa... :)

Citrix: Change the IP Address

In CITRIX environment, sometimes we have to change the ipaddress. After changing the windows ip-address, we alse have to update the citrix database. Base on the www.thin-world.com , we have to use the 'altaddr' command.

c:\>altaddr /SERVER:METAFRAME01 /SET 192.168.25.77

From the point we set the IP, Citrix will not search for the old IP.

Solaris: How to change the xserver color depth to 24

By default solaris 5.8 use 8-bit color depth. To change it to 24-bit, you have to update the file Xservers.

#vi /etc/dt/config/Xservers
:0 –nobanner –dev /dev/fb0 defclass TrueColor defdepth 24 –dev /dev/fb1 defclass TrueColor defdepth 24 –auth /var/dt/A:

Update the line with the bold section as seen above.

Oracle: When Windows XP's Firewall blocks Oracle connection

When client try to make connection to the listener (default using port 1521), the listener spawn new user-process. This user process use random port to handle the client's request. Mainly, oracle use two main program, which are " oracle.exe" for oracle-instance, and "tnslsnr.exe" for listener. We can check it through "Task Manager"
Windows firewall support port and program exception. We use both to make exception in Windows-Firewall.

From Control Panel --> Windows Firewall :
1. "Add Port" => 1521
2. "Add Program => browse to the ORACLE_HOME/bin for " oracle.exe" and "tnslsnr.exe"

Ok, now try to reconnect your client to the Oracle Server, and feel that your firewall configuration works... good luck!