Set hostname without reboot

Monday 28 Apr 2008 by Gun nee | No Comments
Filed under: Solaris 
bash> uname -a
SunOS Trojan 5.9 Generic_118558-33 sun4u sparc SUNW,Netra-T12

replace old "hostname" with new "hostname" in file /etc/hosts, /etc/nodename, /etc/hostname."ethernet_port_name", /etc/net/ticlts/hosts, /etc/net/ticotsord/hosts, /etc/net/ticots/hosts

bash> vi /etc/hosts
bash> vi /etc/nodename
bash> vi /etc/hostname.bge0
bash> vi /etc/net/ticlts/hosts
bash> vi /etc/net/ticotsord/hosts
bash> vi /etc/net/ticots/hosts

and then execute command :

hostname "new hostname"
bash> hostname worm
bash> . /.profile

ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:

Monday 24 Mar 2008 by Hendrawan | No Comments
Filed under: Solaris

When I log via ssh to another machine

bash> ssh gandalf@rohan.lotr.com
unable to initialize mechanism library [/usr/lib/gss/gl/mech_krb5.so]

the following message appears was appears

rohan.lotr.com sshd[23418]: [ID 530472 auth.error] Kerberos mechanism library initialization error:
Can't open/find Kerberos /etc/krb5/krb5.conf

Workaround:

Edit /etc/ssh/ssh_config and add the following

Host *
StrictHostKeyChecking no
GSSAPIKeyExchange no
GSSAPIAuthentication no

And
Edit /etc/ssh/sshd_config and add the following

GSSAPIAuthentication no
GSSAPIKeyExchange no
GSSAPIStoreDelegatedCredentials no

Tracking Down “Last Reboot” on windows

Sunday 9 Mar 2008 by Hendrawan | No Comments
Filed under: Windows

when you handful on your windows environment, you must know this

edit uptime.bat
systeminfo   | find "Up Time"

and then save with "alt+f > s > x"
last reboot action here..

uptime.bat
systeminfo   | find "Up Time"
System Up Time:            3 Days, 19 Hours, 6 Minutes, 26 Seconds

Backup Listener log

Sunday 9 Mar 2008 by Hendrawan | 1 Comment
Filed under: Oracle Tags:

In database production, the log of listener was grow rapidly, some times if you move the "listener.log" while the listener is up and running, listener will stop writing to log file after you move/delete the "listener.log", it won't create new log file.
The listener log status will be 'off', You need to start the "listener log" again manually. For this reason you must do this procedure.

bash> lsnrctl stat
LSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 09-MAR-2008 12:43:22
 
Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.6.0 - Production
Start Date                11-SEP-2007 03:34:17
Uptime                    180 days 9 hr. 9 min. 4 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/app/product/9.2.0/network/admin/listener.ora
Listener Log File         /oracle/app/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOSTNAME)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "DB_SID.domain.com" has 2 instance(s).
Instance "DB_SID", status UNKNOWN, has 1 handler(s) for this service...
Instance "DB_SID", status READY, has 1 handler(s) for this service...
The command completed successfully
bash> lsnrctl
LSNRCTL> SET log_status off
Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" SET TO OFF
The command completed successfully
bash> mv /oracle/app/product/9.2.0/network/log/listener.log /backup/listener.log_9-March-2008
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER parameter "log_status" set to ON
The command completed successfully

Oracle Heterogeneous Configuration Service (ORACLE to MySQL)

Wednesday 5 Mar 2008 by Henri Simatupang | 6 Comments
Filed under: Oracle Tags:

PART I : Setting up ODBC driver

1. Install mysql-connector-odbc-3.51.12-linux-i686.rpm

bash> rpm –ivh mysql-connector-odbc-3.51.12-linux-i686.rpm

2. Start Mysql Daemon

bash> /etc/init.d/mysqld start
Initializing MySQL database:                               [  OK  ]

3. Configure ODBC

bash> ODBCConfig

4. Modify : /etc/odbc.ini

bash> vi /etc/odbc.ini
[trans]
Driver = MySQL ODBC 3.51 Driver
DATABASE = kampus
DESCRIPTION = punya_kampus
PWD = password
PORT = 3306
SERVER = localhost
UID = root

Read the rest of this entry »


« Older Entries
Newer Entries »

  • Search