Pubudu: Data and Decisions

After installing RHEL 6 you may not be able to get network connection up on booting the machine. This is a reported bug in RHEL 6. Follow below steps to solve the issue. Edit   /etc/sysconfig/network-scripts/ifcfg-eth0  file, which is your default first NIC configuration file. If you are using DHCP server: Edit below file and change as given below #vi /etc/sysconfig/network-scripts/ifcfg-eth0 ONBOOT="yes" BOOTPROTO="dhcp" Save & restart networking service, #service network restart  If you are providing manual IP: Edit below file and change as given below #vi /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=eth0 IPADDR=192.10.110.10 NETMASK=255.255.255.0 NETWORK=10.10.10.0 GATEWAY=192.9.110.253 ONBOOT=yes BOOTPROTO=none USERCTL=no Save & restart networking service, #service network restart

You may get below error when trying to connect to the database using sqlplus or through an application login. ORA-12518: TNS:listener could not hand off client connection Reason: The process of handing off a client connection to another process failed. Solution;   Increase PROCESSES initialization parameter. Use the following command to check the value of the PROCESSES initialization parameter: show parameter processes; If the database was started using an spfile, then the following command can be used to increase the PROCESSES initialization parameter: alter system set processes=600 scope=spfile; If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.

Error: When trying to log in through ftp you may receive below error: ftp 500 OOPS: cannot change directory Solution: In the console do the following (Log in as ROOT) su - getsebool -a | grep ftp setsebool -P ftp_home_dir on getsebool -a | grep ftp Eg: [root@test ~]# getsebool -a | grep ftp allow_ftpd_anon_write --> on allow_ftpd_full_access --> off allow_ftpd_use_cifs --> off allow_ftpd_use_nfs --> off ftp_home_dir --> on httpd_enable_ftp_server --> off

In Oracle CSS Daemon refers to Cluster Synchronization Services  , a daemon process that is used for synchronization between different  RAC  nodes and synchronization between  ASM  and Oracle database instances. To stop the Oracle Cluster Services Synchronization (CSS) daemon, run the following command: On AIX: /etc/init.cssd stop On other platforms: /etc/init.d/init.cssd stop To start the CSS daemon, run the following command: /etc/init.d/init.cssd start This command stops the Oracle CSS daemon and then restarts it. $ORACLE_HOME/bin/localconfig reset

Quota A quota is the amount of space allocated to a user in a tablespace. You may get oracle error like below due to this problem. ORA-01536:space quota exceeded for tablespace 'string' Change quota allocation A user's quota can be changed with the ALTER USER command. Examples: Restrict user to 10M: ALTER USER test QUOTA 10M ON users; Allow unlimited space ALTER USER test QUOTA unlimited ON users; Monitor Query the USER_TS_QUOTAS view to see the quota allocation. SQL> SELECT * FROM user_ts_quotas;

1.  Right click on an empty area on desktop, and click on  New  and  Shortcut . 2.  Type the command below into the location area, and click on the  Next  button. (see screenshot below) Replace  USER-NAME  in the command with the actual name of the user account that you want to run the program as. runas /user:USER-NAME "C:\full\path\of\Program.exe" For example, if I wanted to run Notepad as the  test  user, I would type this command below. runas /user:myadmin "D:\myprogram\myprogram.exe" 3.  Type a name for the shortcut in the name section, and click on the  Finish  button.  4.  Right click on the new shortcut on the Desktop and click on  Properties . 5.  Click on the  Shortcut  tab, then click on the  Change Icon  button. 6. Now you can access the file through your new shortcut.  Double  click on the icon and you may...

DBVERIFY  is a utility of Oracle , that can be used to perform a physical structure integrity check against  database files. Note that the database should be off line before performing a DBVERIFY. But it will work with online data files also,but its not recommended. DBVERIFY is invoked using dbv command.It should be called from ORACLE_HOME/bin directory. To access help on DB_VERIFY type:   dbv help=y To perform a simple DBVIRIFY use below command.Output will be written to the dbv.log file. >dbv file=/u01/oracle/product/10.2.0/oradata/orcl/users01.dbf logfile=dbv.log Note that this is only a verification tool to get a idea about data files,whether they are corrupted or not.You'll have to follow other methods to recover corrupted data files. Exmples: dbv example of  a datafile with no corruption. (Pages are data blocks) DBVERIFY: Release 11.2.0.2.0 - Production on Tue Mar 13 15:41:47 2012 Copyright (c) 1982, 2009, Oracle and/or its ...