Friday, April 5, 2013

Install Oracle 10.2.0.4 on Solaris x86

1. Create oracle User Account
Login as root and create te user oracle which belongs to oinstall,dba,asmdba and asmadmin groups.

su -
# groupadd dba
# groupadd oinstall
# groupadd asmdba
# groupadd asmadmin
# useradd -g oinstall -G dba,asmdba,asmadmin -m -d /export/home/oracle -s /usr/bin/bash oracle


2. Setting System parameters
Edit the /etc/system and add following line:

set noexec_user_stack=1

set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set max_nprocs=30000
set maxuprc=16384


Sunday, February 3, 2013

Cisco VPN Client 5 on Windows 8


NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8 right around the corner it is inevitable that people will want to get in there and check it out. If you are working someplace that uses the Cisco VPN client you may run into a little issues getting it to work on Windows 8. Luckily the fix is REALLY simple. I’m sure they will add support in the future, but for the time being check out the issue and fix below.
The client will install and run just fine on the OS, at least it did for me. The problem comes when connecting to VPN resulting in the following error:

Friday, November 2, 2012

Export CSV directly from MySQL

How ofter were you asked by a client for a CSV (or excel) file with data from their app? I get asked that question quite often, so I wanted make the process as easy as possible. And guess what? You can create CSV files directly from MySQL with just one query!
Let's say you want to export the id, name and email fields from your users table to a CSV file. Here is your code:
SELECT id, name, email INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY ‘\\’
LINES TERMINATED BY '\n'
FROM users WHERE 1
Well, if you know MySQL, you'll know how to customize this query to spit out the the right data. Your csv file can be found in /tmp/result.csv
Make sure your MySQL server has write permissions to the location where you want to store your results file.

Monday, October 29, 2012

Installation of Oracle 11g R1 (11.1.0.6.0) on SuSE Linux Enteprise Server (SLES) 10 and OpenSuSE 10.3

This paper (HOWTO) describes step-by-step installation of Oracle 11g R1 database software on SuSE Linux Enteprise Server (SLES) 10 and OpenSuSE 10.3 (currently for x86_64. x86 version will come soon). Note that OpenSUSE distribution is not certified by Oracle Corporation.
This article does not cover database creation process, and ASM Instance creation process.

This paper covers following steps:

Thursday, September 20, 2012

Dhcp client stopped at startup

1- first you have to login using any user with administrative
privileges.
2- start---> Run---> regedit
3- go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip.
4- right-click on the Tcpip from the left tap menu and choose
permission.
5- Choose (Allow) for all listed groups and users, then press apply and
ok.
6- go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Dhcp.
7- do the same as before.
8- now plug your network cable or connect to the wireless, if u got an
IP from the DHCP then it's done, if not you have to open the services
from the administrative tools to run the DHCP clinet or stop and run the
service again.

*** YOU HAVE TO DO THIS EVERYTIME U LOG IN OR CONNECT TO THE
NETWORK.
*** THIS PROBLEM ASLO EXIST WITH WINDOWS 7 ULTIMATE.

This problem might be related to the DHCP server, seems like up-grading
from windows 2000 advanced server to windows 2003 may cause this probem,
or maybe the group policy in the active directory.


Or try this *netsh winsock reset catalog *