Tools You Will Need For This Course

You will learn how to use the following tools to administer your oracle database.

 

  • Oracle ClientThe client enables services and their applications to reside on different computers and communicate as peer applications. The main function is to establish network sessions and transfer data between a client machine and a server or between two servers.Essentially, the client (SQL*NET) provides the software layer between Oracle and the networking software, providing seamless communication between an Oracle client machine (running, for example, SQL*Plus) and the database server or from one database server to another.Download Oracle Client
    Steps To Install Oracle ClientSteps To Connect To Kudrant Oracle Server Using SQL*Plus
  • SQL developerOracle SQL Developer is a free graphical user interface which  allows database users and administrators to do their database tasks in fewer clicks and keystrokes. You can use SQL to perfrom the following tasks:
    • Run queries
    • Generate execution plans
    • Data Pump
    • Recovery Manager (RMAN)
    • Oracle Auditing
    • User and Role management
    • Storage management, including the ability to add space to your tablespaces
    • Resource Manager
    • Logical, relational, physical, dimensional modeling
    • Data Flow Diagrams
    • DDL scripting
    • Importing from data dictionaries, DDL scripts, Oracle Designer Repositories, and ERwin
    • a Reporting Repository
    • Versioning of your designs via Subversion
    • Comparing models with generation of ALTER scripts
    • a powerful search and reporting utility
    • Migrate third party applications
    • Diagnostic Pack features:
      • Snapshots
      • Baselines
      • ADDM
      • ASH
      • AWR

    Download SQL Developer

    Steps To Install SQL Developer

    Steps To Connect To Kudrant Oracle Server Using SQL Developer

  • Xming X11 ServerIs a free X window server for Microsoft Windows. It is used use load Linux graphical applications remotely.

    Download Xming X11 Server

    Steps To Install Xming X11 Server
  • Xming fontFont-dirs is a tool used by an Xming installer to create a custom font-dirs file.Download Xming font

    Steps To Install Xming Font
  • Putty

    SSH, Telnet and Rlogin are three ways you can log on to multi-user computer system such as Linux/unix/VMS over a network.Linux servers usually present a command-line interface to the user, much like the ‘Command Prompt’ or ‘MS-DOS Prompt’ in Windows. The system prints a prompt, and you type commands which the system will execute.Using this type of interface, there is no need for you to be sitting at the same machine you are typing commands to. The commands, and responses, can be sent over a network, so you can sit at one computer and give commands to another one, or even to more than one.SSH, Telnet and Rlogin are network protocols that allow you to do this. On the computer you sit at, you run a client, which makes a network connection to the other computer (the server). The network connection carries your keystrokes and commands from the client to the server, and carries the server’s responses back to you.

    PuTTY is a Telnet and SSH terminal software for Unix and Windows platforms that enables any users to remotely access computers over the internet. PuTTY is a free and open source and network file transfer Application which supports several network protocol.

     Some features of PuTTY

    – PuTTY supports multiple variations on the secure remote terminal.

    – It provides control over the SSH encryption key and protocol version.

    – It stores hosts and preferences for later usage.`

    – It allows remote, local or dynamic port forwarding with SSH.

    Download  putty

    Steps To Install Putty

  • WinSCPWinSCP (Windows Secure Copy) is a free and open-source SFTP, FTP, WebDAV and SCP client for Microsoft Windows. Its main function is secure file transfer between a local and a remote computer.Download winscp

  Steps To Install Winscp

Discussion