Tools to Monitor Linux PerformanceLinux How to Close and Open Ports with iptables How to Reset "root" Password with GRUB on Enterprise Linux Forcefully unmount a Linux disk partition Get...
Sunday, November 20, 2016
VNC in Linux
VNC server config
I am trying to configure VNC server following instructions below
VNC Server configuration
Setting up VNC server in RHEL or Fedora.
1. up2date vnc-server (RHEL) or yum install vnc-server (Fedora) if you don't have it installed.
2. Edit /etc/sysconfig/vncservers as root.
Uncomment the line:
VNCSERVERS="1:put_the_user_you_will_log_in_as_here"
The...
Mount Windows CDROM in Linux
Make sure your have samba configured and running
smbmount //192.188.101.133/D /mnt/cd -o username=mpasha,workgroup=saudilighting,password=userp...
Get Tape Serial Num in Linux
[root@vmbackup dev]# sg_inq /dev/st0
standard INQUIRY:
PQual=0 Device_type=1 RMB=1 \[ANSI_version=3] version=0x03
\[AERC=0] \[TrmTsk=0] NormACA=0 HiSUP=0 Resp_data_format=2
SCCS=0 ACC=0 ALUA=0 3PC=0 Protect=0
BQue=0 EncServ=0 MultiP=0 MChngr=0 \[ACKREQQ=0] Addr16=1
\[RelAdr=0] WBus16=1 Sync=1 Linked=0 \[TranDis=0] CmdQue=0
Clocking=0x3...
Forcefully unmount a Linux disk partition
How do I forcefully unmount a Linux disk partition?
It happens many times you try to unmount a disk partition or mounted CD/DVD disk and if you try to unmount device, which is accessed by other users, then you will get error umount: /xxx: device is busy. However, Linux/FreeBSD comes with fuser command to kill forcefully mounted partition.
Understanding...
How to Reset "root" Password with GRUB on Enterprise Linux
How to Reset "root" Password with GRUB on Enterprise Linux
If somehow you have lost the password for the system administrator user "root" you will need to reset it. This document provides a practical method to do that if you have configured system with the GRUB boot loader during the OS installation.
It procedure is to boot the system in the "single...
How to Close and Open Ports with iptables
How to Close and Open Ports with iptables
Linux dedicated servers typically rely a software firewall system called iptables. With it you can control which ports allow inbound and/or outbound access. It is very important to have iptables configured properly, both for your server’s functionality and for its security.
There are many tools, both command-line...
Tools to Monitor Linux Performance
Linux/Unix System administrators need to monitor and debug Linux System Performance problems every day. It is very hard to monitor and keep systems up and running without using proper tools or utilities. Below are some frequently used command line monitoring tools that might...
Saturday, November 19, 2016
Validating Parameters in Oracle Reports using PL/SQL
Parameters can be populated and validated using various srw pl/sql triggers.The following gives examples of: Validation trigger in parameter spread sheet Before parameter form trigger After parameter form trigger Before report trigger Examples of validation triggers on the property sheet for parameter PARAM_SAL. Query:...
ORACLE REPORTS PERFORMANCE TIPS
Doc ID 61535.1Performing operations in SQL may be faster than performing them in OracleReports or PL/SQL. The list below explains the most common cases where usingSQL would improve performance: - perform calculations directly in your query rather than in a formula or summary, - use a WHERE clause instead of a group filter or format trigger to...
Using SRW Packaged Procedures in Reports
Oracle Reports is shipped with a collection of PL/SQL constructs that containmany functions, procedures, and exceptions that you can reference in your libraries or reports. The name of Oracle Reports' package is SRW. Therefore, anytime you reference a construct in the SRW package, you must prefix it with SRW (such as, SRW.DO_SQL). SRW...
Running SQL*Trace on an Applications Report
There are two methods to running a Report with SQL*Trace which are:Method #1: Normally, in order to run a report with SQL*Trace, you would have to do the following: 1. Turn SQL*Trace on by modifying your init.ora file. 2. Shut down the concurrent managers and the database. 3. Bring the database and the...
SQL Commands
SQL COMMANDSCREATE COMMANDSCreate TableCREATE TABEL EMP(empno number, ename varchar2(30), hiredate date);CREATE TABLE scott.emp (empno NUMBER CONSTRAINT pk_emp PRIMARY KEY,ename VARCHAR2(10) CONSTRAINT nn_ename NOT NULL CONSTRAINT upper_ename CHECK (ename = UPPER(ename)),job VARCHAR2(9),mgr NUMBER CONSTRAINT fk_mgr REFERENCES scott.emp(empno),hiredate...
