Sunday, 7 July 2013

Linux command (yum)

NAME

       yum - Yellowdog Updater Modified


SYNOPSIS

       yum [options] [command] [package ...]


DESCRIPTION

       yum  is  an interactive, automated update program which can be used for
       maintaining systems using rpm

       command is one of:
        * install package1 [package2] [...]
        * update [package1] [package2] [...]
        * check-update
        * upgrade [package1] [package2] [...]
        * remove | erase package1 [package2] [...]
        * list [...]
        * info [...]
        * provides | whatprovides feature1 [feature2] [...]
        * clean [ packages | headers | metadata | cache | dbcache | all ]
        * makecache
        * groupinstall group1 [group2] [...]
        * groupupdate group1 [group2] [...]
        * grouplist [hidden]
        * groupremove group1 [group2] [...]
        * groupinfo group1 [...]
        * search string1 [string2] [...]
        * shell [filename]
        * resolvedep dep1 [dep2] [...]
        * localinstall rpmfile1 [rpmfile2] [...]
        * localupdate rpmfile1 [rpmfile2] [...]
        * deplist package1 [package2] [...]

       Unless the --help or -h option is given, one of the above commands must
       be present.


       install
              Is  used  to install the latest version of a package or group of
              packages while ensuring that all dependencies are satisfied.  If
              no  package  matches the given package name(s), they are assumed
              to be a shell glob and any matches are then installed.


       update If run without any packages, update will update every  currently
              installed  package.   If one or more packages are specified, Yum
              will only update the listed packages.  While updating  packages,
              yum  will  ensure  that  all  dependencies are satisfied.  If no
              package matches the given package name(s), they are  assumed  to
              be a shell glob and any matches are then installed.

              If  the  --obsoletes  flag  is  present yum will include package
              obsoletes in its calculations - this makes it  better  for  dis-
              tro-version  changes,  for example: upgrading from somelinux 8.0
              to somelinux 9.


       check-update
              Implemented so you could know if your machine  had  any  updates
              that  needed  to  be  applied  without running it interactively.
              Returns exit value of 100 if there are packages available for an
              update.  Also  returns  a list of the pkgs to be updated in list
              format. Returns 0 and no packages are available for update.


       upgrade
              Is the same as the update command with the --obsoletes flag set.
              See update for more details.


       remove or erase
              Are  used  to  remove  the specified packages from the system as
              well as removing any packages which depend on the package  being
              removed.


       list   Is  used  to  list various information about available packages;
              more complete details are available in the List Options  section
              below.


       provides or whatprovides
              Is used to find out which package provides some feature or file.
              Just use a specific name or a file-glob-syntax wildcards to list
              the packages available or installed that provide that feature or
              file.


       search Is used to find any packages matching a string in  the  descrip-
              tion,  summary, packager and package name fields of an rpm. Use-
              ful for finding a package you do not know by name  but  know  by
              some word related to it.


       info   Is  used  to  list  a  description and summary information about
              available packages; takes the same  arguments  as  in  the  List
              Options section below.


       clean  Is  used  to clean up various things which accumulate in the yum
              cache directory over time.  More complete details can  be  found
              in the Clean Options section below.


       shell  Is  used  to enter the ’yum shell’, when a filename is specified
              the contents of that file is executed in  yum  shell  mode.  See
              yum-shell(8) for more info


       resolvedep
              Is  used  to list packages providing the specified dependencies,
              at most one package is listed per dependency.


       localinstall
              Is used to install a set of local rpm  files.  If  required  the
              enabled repositories will be used to resolve dependencies.


       localupdate
              Is used to update the system by specifying local rpm files. Only
              the specified rpm files of which an  older  version  is  already
              installed  will  be  installed, the remaining specified packages
              will be ignored.  If required the enabled repositories  will  be
              used to resolve dependencies.


       deplist
              Produces  a  list  of all dependencies and what packages provide
              those dependencies for the given packages.




GENERAL OPTIONS

       Most command line options can be set using the  configuration  file  as
       well  and  the descriptions indicate the necessary configuration option
       to set.


       -h, --help
              Help; display a help message and then quit.

       -y     Assume yes; assume that the answer to any question  which  would
              be asked is yes.
              Configuration Option: assume-yes

       -c [config file]
              Specifies the config file location - can take http, ftp urls and
              local file paths.

       -d [number]
              Sets the debugging level to [number] -  turns  up  or  down  the
              amount of things that are printed. Practical range: 0 - 10
              Configuration Option: debuglevel

       -e [number]
              Sets the error level to [number] Practical range 0 - 10. 0 means
              print only critical errors about which you must be told. 1 means
              print  all  errors,  even ones that are not overly important. 1+
              means print more errors (if any) -e 0 is good for cron jobs.
              Configuration Option: errorlevel

       -R [time in minutes]
              Sets the maximum amount of time yum will wait before  performing
              a command - it randomizes over the time.

       -C     Tells  yum  to  run  entirely  from cache - does not download or
              update any headers unless it has to  to  perform  the  requested
              action.

       --version
              Reports the yum version number and exits.

       --installroot=root
              Specifies  an  alternative  installroot,  relative  to which all
              packages will be installed.
              Configuration Option: installroot

       --enablerepo=repoidglob
              Enables specific repositories by id or glob that have been  dis-
              abled in the configuration file using the enabled=0 option.
              Configuration Option: enabled

       --disablerepo=repoidglob
              Disables specific repositories by id or glob.
              Configuration Option: enabled

       --obsoletes
              This  option  only  has  affect  for an update, it enables yum´s
              obsoletes processing logic. For more information see the  update
              command above.
              Configuration Option: obsoletes

       --exclude=package
              Exclude  a  specific package by name or glob from updates on all
              repositories.
              Configuration Option: exclude

       --noplugins
              Run with all plugins disabled.
              Configuration Option: plugins



LIST OPTIONS

       The following are the ways which you can invoke yum in list mode.  Note
       that  all list commands include information on the version of the pack-
       age.


       yum list [all | regexp1] [regexp2] [...]
              List all available and installed packages.

       yum list available [regexp1] [...]
              List all packages  in  the  yum  repositories  available  to  be
              installed.


       yum list updates [regexp1] [...]
              List  all  packages  with updates available in the yum reposito-
              ries.


       yum list installed [regexp1] [...]
              List the packages specified by args.  If an  argument  does  not
              match  the  name  of an available package, it is assumed to be a
              shell-style glob and any matches are printed.


       yum list extras [regexp1] [...]
              List the packages installed on the system that are not available
              in any yum repository listed in the config file.


       yum list obsoletes [regexp1] [...]
              List  the packages installed on the system that are obsoleted by
              packages in any yum repository listed in the config file.


       yum list recent
              List packages recently added into the repositories.


       Specifying package names
              All the list options mentioned above take file-glob-syntax wild-
              cards or package names as arguments, for example yum list avail-
              able foo* will list all available packages that match foo*.




CLEAN OPTIONS

       The following are the ways which you can invoke yum in clean mode.


       yum clean packages
              Eliminate any cached packages from the system.  Note that  pack-
              ages are not automatically deleted after they are downloaded.


       yum clean headers
              Eliminate  all  of  the  files  which  yum uses to determine the
              remote availability of packages. Using this  option  will  force
              yum to download all the headers the next time it is run.


       yum clean all
              Runs yum clean packages and yum clean headers as above.




MISC

       Specifying package names
              A  package can be referred to for install,update,list,remove etc
              with any of the following:

              name
              name.arch
              name-ver
              name-ver-rel
              name-ver-rel.arch
              name-epoch:ver-rel.arch
              epoch:name-ver-rel.arch

              For example: yum remove kernel-2.4.1-10.i686




PLUGINS

       Yum can be extended through the use of plugins. A plugin  is  a  Python
       ".py"  file  which  is installed in one of the directories specified by
       the pluginpath option in yum.conf. For a plugin to work, the  following
       conditions must be met:

       1.  The plugin module file must be installed in the plugin path as just
       described.

       2. The global plugins option in /etc/yum.conf must be set to ‘1’.

       3. A configuration file for the plugin must exist  in  /etc/yum/plugin-
       conf.d/<plugin_name>.conf and the enabled setting in this file must set
       to ‘1’. The minimal content for such a configuration file is:

              [main]
              enabled = 1

       See the yum.conf(5) man page for more  information  on  plugin  related
       configuration options.




FILES

       /etc/yum.conf
       /etc/yum/repos.d/
       /etc/yum/pluginconf.d/
       /var/cache/yum/




SEE ALSO

       yum.conf (5)
       http://linux.duke.edu/yum/




AUTHORS

       See the Authors file included with this program.




BUGS

       There  of  course  aren’t any bugs, but if you find any, they should be
       sent  to  the  mailing  list:  yum@lists.linux.duke.edu  or  filed   in
       bugzilla.

Friday, 21 June 2013

Hosts file location on various platform

Windows 7:         %systemroot%\system32\drivers\etc\
                        or, c:\windows\system32\drivers\etc\

 where,
 %systemroot% is usually c:\windows unless you installed Windows on a different partition.

Tuesday, 11 June 2013

How to Enable Telnet Client in Windows 7

Telnet Client is used to connect to remote machine by using the Telnet protocol. For example, I'm an old fashion IT guy, and I still like to configure Cisco Switches/Routers using telnet. If you started to use Windows 7, you will notice that telnet is not enabled by default !! Don't panic, it is just a matter of few clicks and telnet will be enabled again.
Telnet Client allows a computer to connect to a remote Telnet server and run applications on that server. Once logged on, a user is given a command prompt that can be used as if it had been opened locally on the Telnet server's console. Commands that you type at the Telnet client command prompt are sent to the Telnet Server and executed there, as though you were locally logged on to a command prompt session at the server. Output from the commands that you run are sent back to the Telnet client where they are displayed for you to view.

When you first try to run a telnet command, Windows will informs you that telnet is not recognized as a command




To enable Telnet Client on Windows 7, follow these steps :
  1. Click on Start    then right click on Control Panel

  2. From Control Panel, click on Programs

  3. Under Programs and Features, click on Turn Windows Features on or off

  4. From the Windows Features window, using the slider, scroll down till you reach Telnet Client, select the checkbox beside it, then click on OK



    The selected feature will be installed.



    Once it is installed, the Windows Features windows will be closed.
  5. To confirm that Telnet is installed, open command prompt and type telnet /?



Summary

By default, Telnet Client is not enabled in Windows 7. To enable it, you have to add the Telnet Client Windows Feature.

Another Method:
  • Open a command prompt window.
  • Click Start,type cmd in start search box, and then press Enter.
  • Type the following command
pkgmgr /iu:"TelnetClient"
  • If the User Account Control(UAC) dialog box appears, confirm that the action it displays is want you want, and then click continue.
  • When the command prompt appears again, the installation is complete

Friday, 26 April 2013

ORACLE Export/Import






Oracle Import :

imp
Username:.......
Password:.......
Import data Only: no
Import file: EXPDAT.DMP
List contents of import file only (yes/no): no > no
Ignore create error due to object existence:>no
Import grants>yes
Import table data>yes
Import entire export file>no
Username:........


[root@fws Desktop]# cd /opt
[root@fws opt]# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@fws opt]# ls
Disk1                             New Text Document.txt
f101(1).sql                       oracle-xe-11.2.0-1.0.x86_64.rpm
f111(4).sql                       putty.rpm
image.sql                         rh
libaio-0.3.109-5.fc17.x86_64.rpm  SAJIB(1.oct.13).sql
lsnrctl status                    SAJIB.5.oct.13.DMP
lsnrctl status~                   teamviewer_linux.rpm
[root@fws opt]# imp

Import: Release 11.2.0.2.0 - Production on Tue Oct 8 03:51:27 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Import data only (yes/no): no > no

Import file: expdat.dmp > SAJIB.5.oct.13.DMP

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by SAJIB, not by you

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > no

Ignore create error due to object existence (yes/no): no > no

Import grants (yes/no): yes > yes

Import table data (yes/no): yes > yes

Import entire export file (yes/no): no > no
Username: sajib

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:

. importing SAJIB's objects into SAJIB
. . importing table              "ADD_STOCK_FIBER"          4 rows imported
. . importing table                    "APEX$_ACL"          0 rows imported
. . importing table               "APEX$_WS_FILES"          0 rows imported
. . importing table             "APEX$_WS_HISTORY"          0 rows imported
. . importing table               "APEX$_WS_LINKS"          0 rows imported
. . importing table               "APEX$_WS_NOTES"          0 rows imported
. . importing table                "APEX$_WS_ROWS"          0 rows imported
. . importing table                "APEX$_WS_TAGS"          0 rows imported
. . importing table      "APEX$_WS_WEBPG_SECTIONS"          0 rows imported
. . importing table "APEX$_WS_WEBPG_SECTION_HISTORY"          0 rows imported
. . importing table          "APEX_ACCESS_CONTROL"         42 rows imported
. . importing table            "APEX_ACCESS_SETUP"          2 rows imported
. . importing table                          "BAF"         20 rows imported
. . importing table                          "BZB"         38 rows imported
. . importing table                         "CEPZ"         61 rows imported
. . importing table                          "CGB"         57 rows imported
. . importing table                         "CHKB"         59 rows imported
. . importing table                         "CHMB"          0 rows imported
. . importing table                         "CHWB"          0 rows imported
. . importing table               "DEMO_CUSTOMERS"          7 rows imported
. . importing table                  "DEMO_ORDERS"         10 rows imported
. . importing table             "DEMO_ORDER_ITEMS"         49 rows imported
. . importing table            "DEMO_PRODUCT_INFO"         10 rows imported
. . importing table                  "DEMO_STATES"         51 rows imported
. . importing table                   "DEMO_USERS"          2 rows imported
. . importing table                         "DEPT"          4 rows imported
. . importing table                         "DWHB"         67 rows imported
. . importing table                          "EMP"         14 rows imported
. . importing table                          "FGB"          0 rows imported
. . importing table                          "FWT"         29 rows imported
. . importing table                          "GEC"         71 rows imported
. . importing table                           "HQ"        332 rows imported
. . importing table                         "IMGB"         41 rows imported
. . importing table                         "KEPZ"         26 rows imported
. . importing table                          "KGB"          1 rows imported
. . importing table                          "KSB"         79 rows imported
. . importing table                          "LKB"         35 rows imported
. . importing table                       "MCOURT"          0 rows imported
. . importing table                          "MEB"         31 rows imported
. . importing table                          "MGB"         19 rows imported
. . importing table                          "NGB"         41 rows imported
. . importing table                          "NKB"        146 rows imported
. . importing table                          "PLB"         64 rows imported
. . importing table              "RADIO_LINK_INFO"         49 rows imported
. . importing table                           "SI"          0 rows imported
. . importing table                          "SPB"          1 rows imported
. . importing table                  "STOCK_FIBER"          6 rows imported
. . importing table                  "SWITCH_INFO"         56 rows imported
. . importing table                       "TEST10"          1 rows imported
. . importing table                  "UNIQUE_TEST"          4 rows imported
About to enable constraints...
Import terminated successfully without warnings.
[root@fws opt]#

Wednesday, 24 April 2013

Oracle-ARCHIVELOG

command on command Prompt:
...............................
sqlplus /nolog
connect / as sysdba

or sqlplus / as sysdba


Backing Up and Recovering:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>



***Enabling ARCHIVELOG Mode for Media Failure Protection:***
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

>sqlplus / as sysdba
>select log_mode from v$database;
>SHUTDOWN IMMEDIATE
>STARTUP MOUNT
>ALTER DATABASE ARCHIVELOG;
>ALTER DATABASE OPEN;
>exit;



***Flash Recovery Area***
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Two parameters:
* DB_RECOVERY_FILE_DEST and
* DB_RECOVERY_FILE_DEST_SIZE

Flash Recovery Area Default Location:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Linux:    /usr/lib/oracle/xe/app/oracle/flash_recovery_area/
Windows:  c:\oraclexe\app\oracle\flash_recovery_area/

To change the flash recovery area location:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

>sqlplus /as sysdba
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'new_path';
>@?/sqlplus/admin/movelogs
Example:(for windows)
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'E:\FRA';
>@?/sqlplus/admin/movelogs

 "C:\oraclexe\app\oracle\product\11.2.0\server/sqlplus/admin/movelogs.sql"



To Changing the Flash Recovery Area Size:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = new_size;
>exit;
Example:
>ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G;
>exit;



Monitoring Location & Space in the Flash Recovery Area:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


SELECT
NAME,
TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
AS SPACE_AVAILABLE,
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
AS PERCENT_FULL
FROM V$RECOVERY_FILE_DEST;


Restoring and Recovering the Database:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

> On Windows: Click Start, point to Programs (or All Programs), point to
Oracle Database 11g Express Edition, and then select Restore Database.

> On Linux with Gnome: In the Applications menu, point to Oracle Database
11g Express Edition, and then select Restore Database.

> On Linux with KDE: Click the icon for the K Menu, point to Oracle Database
11g Express Edition, and then select Restore Database.






Saturday, 20 April 2013

Setting Enviroment Variables on Linux platform for Oracle

Setting Enviroment Variables on Linux platform

For Bourne,Korn or Bash shell

>source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

For C shell:
>source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.csh

 not path for 11g2

>source /usr/lib/oracle/xe/app/oracle/product/11.2.0/server/bin/oracle_env.sh



For Remote login

SQL>EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

[sajib@fws ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-OCT-2013 22:33:15

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                05-OCT-2013 22:01:03
Uptime                    0 days 0 hr. 32 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/fws/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully



[sajib@fws ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sat Oct 5 22:34:37 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

Check HTTP Port:


SQL>SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

-- If the above returns 0 then run this

Set HTTP Port:

EXEC DBMS_XDB.SETHTTPPORT(8080);

 SQL>SELECT LOG_MODE FROM SYS.V$DATABASE;

 ARCHIVELOG  or  NO ARCHIVELOG

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
-----------
       8080


SQL> show parameter DB_RECOVERY_FILE_DEST;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /u01/app/oracle/fast_recovery_
                         area
db_recovery_file_dest_size         big integer 10G


SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 50G;

System altered.

SQL> show parameter DB_RECOVERY_FILE_DEST;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /u01/app/oracle/fast_recovery_
                         area
db_recovery_file_dest_size         big integer 50G



SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
NOARCHIVELOG

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  622149632 bytes
Fixed Size            2229048 bytes
Variable Size          394267848 bytes
Database Buffers      222298112 bytes
Redo Buffers            3354624 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
ARCHIVELOG

[root@fws Desktop]# lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-OCT-2013 02:57:19

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                08-OCT-2013 02:36:40
Uptime                    0 days 0 hr. 20 min. 41 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/fws/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fws.colbd.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fws.colbd.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@fws Desktop]#



 expdp system schemas=sajib directory=dmpdir dumpfile=sajib.dmp logfile=expsajib.log

expdp system/051502718 schemas=sajib directory=dmpdir dumpfile=expsajib.dmp logfile=expsajib.log

EXPORT COMMAND
for Full Data Mode:
exp full=y file=dba.dmp grants=y rows=y
exp full=y file=dba.dmp log=dba.log

for User Mode:
exp sajib/sajib file=sajib.dmp owner=sajib grants=y rows=y compress=y log=sajib.log

IMPORT COMMAND

imp full=y ignore=y file=expdat.dmp

Thursday, 18 April 2013

How do I stop firewall?


Start Iptables under Linux


Q. How do I start Iptables firewall under RHEL / Red Hat / CentOS / Fedora Linux from a shell prompt? How do I stop firewall?

A. First, you need to configure firewall rules by editing text file located at /etc/sysconfig/iptables. You can also use setup command to configure firewall. Just type the following as root user:

# setup

Select Firewall configuration and just follow on screen instructions.
Once configuration is updated type the following command at a shell prompt:

To start firewall from a shell enter:

# chkconfig iptables on
# service iptables start

To stop firewall, enter:

# service iptables stop



For Details about iptables:
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch14_:_Linux_Firewalls_Using_iptables#.UXFvBMr0nIV 






Tuesday, 20 November 2012

How to mirror the system and boot partition (RAID1) in Windows Server 2003

This step-by-step article describes how to mirror the system and boot partition in Windows Server 2003. This scenario is based on the assumption that the system and boot files are located on disk 0 and that disk 1 is unallocated space.

Requirements

  • At least two hard-disk drives; IDE, small computer system interface (SCSI), or mixed architecture is permissible.
  • The second drive must be at least the size of the volume on which the operating system boot and system files reside to permit mirroring.
  • The Windows Server 2003 system and boot files must reside on the same volume to be mirrored.
Note The memory dump file is written only to the boot hard disk. Windows Server 2003 can continue to work with a mirrored system disk configuration even if one of the disks in the mirror is removed. However, the memory dump file cannot be written to the remaining system disk in the mirror. You must schedule a system restart for the memory dump file to be written to the remaining hard disk.

Set up the disk management system

  1. Click Start, point to Administrative Tools, and then click Computer Management to open the Computer Management console.
  2. Expand the Storage node.
  3. Click Disk Management.
  4. On the View menu, point to Top, and then click Disk List.

    In the right pane, the attributes of each disk in the system are displayed.
  5. On the View menu, point to Bottom, and then click Graphical View.

    At the bottom of the right pane, a color-coded graphical view of the disks on the system is displayed:
    • Disk description panel: The disk description panel (which is gray) is located to the left of the volume description, which is in color. The disk description contains information about each disk's disk number, whether its configuration is basic or dynamic, its size, and its online or offline status.
    • Volume description panel: The volume description panels are color-coded. They hold information about each volume, such as the drive letter (if assigned), whether the volume is allocated or unallocated, the partition or volume size, and the health status of the volume.

Upgrade to dynamic disks

RAID systems require dynamic disks in Windows Server 2003. Any disks that you are upgrading must contain at least 1 megabyte (MB) of free space at the end of the disk for the upgrade to succeed. Disk Management automatically reserves this free space when it creates partitions or volumes on a disk, but disks with partitions or volumes that are created by other operating systems may not have this free space available.

Note You must be logged on as an administrator or a member of the Administrators group to complete this procedure. If your computer is connected to a network, network policy settings may also prevent you from completing this procedure.

To upgrade a basic disk to a dynamic disk, follow these steps:
  1. Before you upgrade disks, quit any programs that are running on those disks.
  2. Right-click the gray disk description panel, and then click Upgrade to Dynamic Disk.
  3. If the second disk is not a dynamic disk, follow these steps to upgrade it to a dynamic disk.

Mirror the boot and system volume

In this scenario, disk 1 is the disk on which the image of disk 0 will be mirrored.

Note Partitions are referred to as volumes when the disks are dynamic.
  1. Disk 1 must be unallocated space before you can proceed with mirroring.
  2. Right-click disk 0 (which contains the boot and system files), and then click Add Mirror.
  3. A dialog box opens in which any disk on your system that is available for mirroring is displayed. Select the disk of your choice (in this example, it is disk 1), and then click Add Mirror.

    Both disk 0 and disk 1 will now have the same color code, the same drive letter, and the volumes will have the status note "Regenerating" displayed while the information is being copied from the first disk to the second disk. The system will automatically size the volume of the new mirror to the same size as that of the original boot and system volume.
  4. If you now want to boot from the new mirrored disk, you have to change the Boot.ini ARC path that points the computer to the partition in which the system files are located.

Troubleshooting

After you upgrade a basic disk to a dynamic disk, any existing partitions on the basic disk become (dynamic) simple volumes. You cannot change the dynamic volumes back to partitions.

A dynamic disk cannot contain partitions or logical drives, nor can it be accessed by MS-DOS or by any Windows operating systems other than Windows Server 2003.

Important Do not use a hardware RAID solution and a software RAID solution on the same disk.