Assignment 1: Accessing Oracle

Intro to Relational Dbase Management Sys

Accessing the Strayer University Oracle Server is not a hard task to do with the proper instructions presented to you. I have broken down the steps in which accessing the database can be an easy experience even for those that are not experienced with Telnet sessions. The tool I used to take my screen shots is SnagIt 11 which is a great tool for capturing screen shots especially inside a telnet session or remote desktop. The program allows for capturing the image you want without have to crop it which would happen using the Ctrl-Print Screen option which will capture your entire desktop work space. The first steps in accessing the Strayer University Oracle server is making sure you have a good telnet session in which to remote into the server. As described in the Strayer University procedures I’ll be showing this telnet session using the program Putty. There are many other telnet programs available to advanced users such as IBM’s 3270 and Microsoft Telnet that can be used as well. First step to accessing an Oracle Server via a Telnet session is actually configuring the session to make the connection to the server happen. Below shows the setup within Putty to establish the connection:

Configure the Host Name or IP address to the Oracle server and Port number are the biggest part of making the connection happen. Once this information has been setup you are able to create it as a saved session so you won’t have to rewrite the information and also save your preferences. Once completed click on the open button which in term will open the session to the Oracle Server as seen below:

At the above login screen the user will type in the user name that was assigned or created by the system administrator of the server that allowed the person access into the server. Once the login name is put in hit the enter key. At this point you will be prompted with a password as shown below:

The password will not be shown as you type it so be careful when typing in the password. Once the password has enter you can proceed in hitting the enter key to access the Oracle Server if the credentials are correct. After you press the enter key you will have the below screen:

If you don’t see a screen similar to this your credentials may be incorrect. Most Telnet sessions will show the username and the cursor prompted after a Dollar symbol or a pound sign depending on the Telnet application used. Now that we are in the server we can start working on the database. Most Telnet sessions will end upon a certain amount of time of inactivity. If this occurs just follow the steps above to reconnect to the session. In closing, it is up to the Server administrator to allow access into the server to the right people within an organization. This allows the security of the server and contents to not be compromised by an outside source. Always check log files to make sure all access into the server has been of an approved source and always remember to report unauthorized access to your security manager or Information Technology Professional.