Bug on Bits

With the introduction of the new Solaris OS 9/10 a hot new feature was the Virtualization. And the Solaris virtualization use a concept called zones. In this post I'm about to describe how to configure a zone in Solaris OS. In order to configure, it is needed to be installed Solaris OS on the server so called Global zone. creating a zone * gather = zonename and zonepath * dedicate cpu resource or capped cpu resource 1.) To create the role and assign the role to a user "solaris Management tools with RBAC" in Basic administration guide 2.) Setup a zone configuration with a zone name (eg: my-zone) #zonecfg -z my-zone will get an error if the first time and ask to create. 3.) create new zone configuration zonecfg:my-zone> create 4.) set the zone path, /export/home/my-zone zonecfg:my-zone> set zonepath=/export/home/my-zone 5.) set the autoboot value( set true to autoboot the zone) make sure svc:/system/zones:default is enabled zonecfg:my-zone...

This Guide provides how to extract .pfx and generate private key and certificate to import in to the server like Apache  Export the private key file from the pfx file shell>> openssl pkcs12 -in filename.pfx -nocerts -out key.pem Export the certificate file from the pfx file shell>> openssl pkcs12 -in filename.pfx -clcerts -nokeys -out cert.pem Remove the passphrase from the private key shell>> openssl rsa -in key.pem -out server.key Now you have generated the certificate ( cert.pem ) and the private key ( server.key ) from the .pfx file. Note : It is better if you are familier with these file formats. .csr   This is a Certificate Signing Request. Some applications can generate these for submission to certificate-authorities. It includes some/all of the key details of the requested certificate such as subject, organization, state, whatnot. These get signed by the CA and a certificate is returned. The returned certificate is the public cert...

If you are an Oracle DBA you will have to come across this topic or might not. However if we have to Chage the archive destination in Oracle Database then this article provides more details on how to proceed. If you are using a spfile then create a pfile as fail safe practice. connect to the database SQL> CREATE PFILE='$ORACLE_HOME/dbs/initORA.ora' FROM SPFILE='SPFILEORA.ORA'; Change the log_archive_dest parameter using SQL> alter system set log_archive_dest='/vol2/oradata/archives' scope=spfile; Shutdown the database SQL> Shutdown immediate start the database; SQL> startup trigger the log change; SQL> alter system switch logfile; Then move to new archive destination directory and check weather archive logs are creating. If creating then the change is successfull otherwise you may need to check the permission for the new log destination and configuration. ===========================================================...

Installation of Cisco VPN client on Linux is something quiet easy. You just need to download the installation file. Extract it using shell>> tar zxvf vpnclient-linux-x86_64-4.8.01.0640-k9.tar.gz Move inside the vpnclient folder created after extracting the tarball using shell>> cd vpnclient Run the executable file vpn_install using shell>> ./vpn_install Provide necessary locations or confirm the defaults. Start the service using shell>> /etc/init.d/vpnclient_init start Copy the configuration file ( *.pcf ) or edit the existing sample.pcf file accordingly in the path of the profile folder. E.g : mine is /etc/CiscoSystemsVPNClient/profiles/sample.pcf After changing the or placing the new configuration file restart the vpn client using shell>> /etc/init.d/vpnclient_init restart And connect to the vpn using shell>> vpnclient connect sample ( if you have provide another name instead of sample to the .pcf file use that name...

If you are new reader, kindly note that this post contains it's first part on post   "Installation of MySQL Enterprise Server Manager" . As the second step as mySQL monitor installation we need to install the monitoring agent for each instance. So in order to accomplish that we first need to create a user and grant relevent permission to that user. Create agent user on mySQL mysql> CREATE USER 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';   mysql> GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS  ON *.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';  mysql> GRANT CREATE, INSERT ON mysql.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';     mysql> GRANT SELECT ON mysql.inventory TO 'replicationuser'@'%' IDENTIFIED BY 'replication_password'; NOTE : SET SQL_LOG_BIN=0 to stop replicating the below ...

Today I had to install mysql enterprise monitor with zero knowledge. So after hours of reading and testing found another great day at workplace. for this solution we need to follow the below steps. 1) Download and install a Service Manager. 2) Open the Enterprise Dashboard in your browser and go through the first-time setup screen that    appears. 3) Download and install an Agent on each machine to be monitor. 4) Configuration of the Agent to connect to the server monitor and to the database. Task 1 ===== So I started installation of the enterprise monitor system management server. Unzip to get the installation files. ======================== [root@test1 intallation]# unzip V32221-01.zip Archive:  V32221-01.zip   inflating: mysqlmonitor-2.3.10.2153-linux-x86_64-installer.bin    inflating: mysqlmonitor-2.3.10.2153-linux-x86_64-update-installer.bin    inflating: AdvisorScript-Platinum-2.3.10.2153.jar    infla...

Installed the mysql using oracle e-delivery package shell> unzip -t V33087-01.zip Archive:  V33087-01.zip     testing: MySQL-devel-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-test-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-embedded-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-client-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-shared-compat-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-shared-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: MySQL-server-advanced-5.5.25-1.rhel5.x86_64.rpm   OK     testing: README.txt               OK No errors detected in compressed data of V33087-01.zip. shell> rpm -ivh MySQL-server-advanced-5.5.25-1.rhel5.x8...

Each and every dba someday will or will not face this situation. But anyway I had to face this scenario. So I decided to blog the steps I followed thinking this might be helpful to some other newbie like me..... 1) Create all the mountpoint as identical to the source 2) Copy all the RMAN backup files to the RMAN source directory 3) Put the DB in to the nomount state    startup nomount 4) set the environment using . oraenv(if linux) 5) connect to RMAN    RMAN taget / 6) Restore the control file    RMAN> restore controlfile from '/BACKUP/RMAN_BACKUP/DB1/c-974303543-20120319-00'; 7) Mount the database    RMAN> Alter database mount 8) select the max sequence using    SQL> select max(sequence#) from v$log; 9) Connect back to the RMAN and execute    RMAN> run    { set until sequence $number;     restore database; } P.S $number is the number found executing the statement...

If you face this error message when powering on a Virtual host, try the below steps to get over it. Go to your disk file location. and type..   vmkfstools -i nagiosxi.vmdk -d zeroedthick nagiosxi1.vmdk and then delete the original .vmdk file (Mine : nagiosxi.vmdk) and rename the newly created file (Mine: nagiosxi1.vmdk) as the name of the original file (Mine : nagiosxi.vmdk) Good luck.....................

After years of studies I became a graduate. Hope life will bring me more adventures. Although I specialized in Communication Engineering I had to work as a Systems Engineer including Network administration and Database administration. Keeping Cisco on one hand and Oracle on other hand it was very difficult to manage but now I'm getting use to it. Hope I would have a better career....