Saturday 26 March 2022

Monday 6 July 2015

Install Cacti Network Monitoring Tool on CentOS 6.4 / RHEL 6.4 / Scientific Linux 6.4

cactiCacti is an open source, front-end for the data logging tool called RRDtool. It is a web based network monitoring and graphing tool. For more information about Cacti refer the official link.

Friday 14 November 2014

How to change Apex Admin Password

login as: root
root@202.65.168.20's password:
Last login: Fri Nov 14 14:28:08 2014 from 114.130.138.17
[root@fws ~]# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@fws ~]# cd /u01
[root@fws u01]# ls
app

Sunday 9 November 2014

How to block facebook in Mikrotik using L7 Protocols (Layer 7)

http://rbgeek.wordpress.com/2012/05/29/how-to-block-facebook-in-mikrotik-using-l7-protocols-layer-7/?blogsub=confirming#subscribe-blog

Saturday 6 September 2014

How To Install and Secure phpMyAdmin on a CentOS 6.4 VP

Ref.link

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-a-centos-6-4-vps-

Introduction

Many websites and applications require databases to store and manage large sets of information. MySQL and MariaDB are popular database management systems because of their flexibility, power, and ubiquity.
For many users, managing databases is difficult from the command line. For those who prefer to use a web interface, phpMyAdmin is a great alternative to command driven management.
In this guide, we will cover how to install and configure phpMyAdmin on a CentOS 6.4 VPS. The procedure should be fairly similar for other versions.

Step One –– Add EPEL Repositories

The phpMyAdmin package is not included in the CentOS default repositories, but it is available in the Fedora Projects EPEL (Extra Packages for Enterprise Linux) repositories.
We can add the repository to our yum source list by downloading a configuration file from the repository itself. Run the following command:

cd ~
wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
 
 
 
Note that even though this file is coming from the 64 bit repository, it is architecture agnostic, meaning it will work for either 32 bit or 64 bit installations.
This will download the package into our home directory. Install it by typing:

sudo rpm -ivh epel-release*

 
 
Your installation now is aware of the EPEL repositories and will query it for packages.
We can check this by typing:


yum repolist
. . .
repo id         repo name                                       status
base            CentOS-6 - Base                                 6381
epel            Extra Packages for Enterprise Linux 6 - x86_64  9788
extras          CentOS-6 - Extras                                 13
updates         CentOS-6 - Updates                              1336
repolist: 17518
As you can see, the EPEL repo is present.
Since the repository is entered in the system now, you can remove the repository configuration package by typing:

rm epel-release*

Step Two –– Download and Configure MySQL

To use phpMyAdmin, you need database software to administer. We will install MySQL and preform some initial configuration from the command line.
To install it, simply type:

Friday 5 September 2014

Computer keyboard key explanations

When talking to tech support or to other people about keyboard commands, web pages, and command line commands, you may hear such things as forward slash, backward slash, and caret. Many times this can be confusing for anyone unfamiliar with each of the symbols on a keyboard. The chart below helps identify each non-alphanumeric keyboard key and a short description of the key or a link to a page with information about the key.


Symbol Explanation
Windows PC keyboards have a Windows key, which looks like a four-pane window
Command Apple Mac computers have a command key.
Esc Esc (Escape) key
F1 - F12 Information about the F1 through F12 keyboard keys.
Tab Tab key
Caps lock Caps lock key
Shift Shift key
Ctrl Ctrl (Control) key
Fn Fn (Function) key
Alt Alt (Alternate) key (PC Only; Mac users have Option key)
Spacebar Spacebar key
Arrows Up, Down, Left, Right Arrow keys
Back Space Back space (or Backspace) key
Delete Delete or Del key
Enter Enter key
Prt Scrn Print screen key
Scroll lock Scroll lock key
Pause Pause key
Break Break key
Insert Insert key
Home Home key
Page up Page up or pgup key
Page down Page down or pgdn key
End End key
Num Lock Num Lock key
~ Tilde
` Acute, Back quote, grave, grave accent, left quote, open quote, or a push
! Exclamation mark, Exclamation point, or Bang
@ Ampersat, Arobase, Asperand, At, or At symbol
# Octothorpe, Number, Pound, sharp, or Hash
£ Pounds Sterling or Pound symbol
Euro
$ Dollar sign or generic currency
¢ Cent sign
¥ Chinese Yuan
§ Micro or Section
% Percent
° Degree
^ Caret or Circumflex
& Ampersand, Epershand, or And
* Asterisk and sometimes referred to as star.
( Open parenthesis
) Close parenthesis
- Hyphen, Minus or Dash
_ Underscore
+ Plus
= Equals
{ Open Brace, squiggly brackets, or curly bracket
} Close Brace, squiggly brackets, or curly bracket
[ Open bracket
] Close bracket
| Pipe, Or, or Vertical bar
\ Backslash or Reverse Solidus
/ Forward slash, Solidus, Virgule, or Whack
: Colon
; Semicolon
" Quote, Quotation mark, or Inverted commas
' Apostrophe or Single Quote
< Less Than or Angle brackets
> Greater Than or Angle brackets
, Comma
. Period, dot or Full Stop
? Question Mark

Monday 25 August 2014

How to access memory card on computer if it says ''Access is Denied''?

Press(windows Button+R)
write-->> gpedit.msc
local group policy editor >computer configuration > Administrative templates >system > Removable > Storage Assess> Removable Disks: read access/write Access "need to sat not configured"

or

open Run
type gpedit.msc
click on the local group policy > computer configuration > administrative tools > all setting

make sure the" removable disks : deny execute access ( read / write ) " is set to the not configured 

Monday 31 March 2014

Enable Network Services in Oracle Database 11g

3.3.7.1 Granting Connect Privileges

The following example demonstrates how to grant connect privileges to any host for the APEX_040000 database user. This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role.
DECLARE
  ACL_PATH  VARCHAR2(4000);
  ACL_ID    RAW(16);
BEGIN
  -- Look for the ACL currently assigned to '*' and give APEX_040000
  -- the "connect" privilege if APEX_040000 does not have the privilege yet.

  SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
   WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;

  -- Before checking the privilege, ensure that the ACL is valid
  -- (for example, does not contain stale references to dropped users).
  -- If it does, the following exception will be raised:
  --
  -- ORA-44416: Invalid ACL: Unresolved principal 'APEX_040000'
  -- ORA-06512: at "XDB.DBMS_XDBZ", line ...
  --
  SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
    FROM XDB.XDB$ACL A, PATH_VIEW P
   WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
         EQUALS_PATH(P.RES, ACL_PATH) = 1;

  DBMS_XDBZ.ValidateACL(ACL_ID);
   IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040000', 
     'connect') IS NULL THEN 
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 
     'APEX_040000', TRUE, 'connect'); 
  END IF;

EXCEPTION
  -- When no ACL has been assigned to '*'.
  WHEN NO_DATA_FOUND THEN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
    'ACL that lets power users to connect to everywhere',
    'APEX_040000', TRUE, 'connect');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END; 
 
 
 
The following example demonstrates how to provide less privileged access to local network resources. This example would enable indexing the Oracle Application Express Online Help and could possibly enable email and PDF printing if those servers were also on the local host.


DECLARE
  ACL_PATH  VARCHAR2(4000);
  ACL_ID    RAW(16);
BEGIN
  -- Look for the ACL currently assigned to 'localhost' and give APEX_040000
  -- the "connect" privilege if APEX_040000 does not have the privilege yet.
  SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
   WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;

  -- Before checking the privilege, ensure that the ACL is valid
  -- (for example, does not contain stale references to dropped users).
  -- If it does, the following exception will be raised:
  --
  -- ORA-44416: Invalid ACL: Unresolved principal 'APEX_040000'
  -- ORA-06512: at "XDB.DBMS_XDBZ", line ...
  --

  SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID
    FROM XDB.XDB$ACL A, PATH_VIEW P
   WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND
         EQUALS_PATH(P.RES, ACL_PATH) = 1;

  DBMS_XDBZ.ValidateACL(ACL_ID);
   IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040000', 
     'connect') IS NULL THEN 
      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH, 
     'APEX_040000', TRUE, 'connect'); 
  END IF;

EXCEPTION
  -- When no ACL has been assigned to 'localhost'.
  WHEN NO_DATA_FOUND THEN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',
    'ACL that lets power users to connect to everywhere',
    'APEX_040000', TRUE, 'connect');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
END;


 http://docs.oracle.com/cd/E17556_01/doc/install.40/e15513/otn_install.htm#BABBHCID

Tuesday 25 March 2014

The Official Red Hat Linux Reference Guide

 Copyright © 2001 by Red Hat, Inc.
Red Hat, Inc.
2600 Meridian Parkway
Durham, NC 27713
USA
Phone: +1 919 547 0012
Phone: 888 733 4281
Fax: +1 919 547 0024
PO Box 13588
Research Triangle Park, NC 27709
USA