Download - Manual de Oracle Xp Sp3 - Ingles
-
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
1/10
1
TOP TECHNOLOGY INSTITUTE ESCARCEGA
Computer Systems Engineering
SUBJECT
Database administration
Manual installation of a database manager
MEMBERS:
Mario Alberto Chan BalanRub Esmeralda Espinoza Martnez
David Montiel RamrezRigo Alberto Rodrguez Mex
Daniel Magaa RodrguezJazmn Montiel Ramrez
ISMA- 618-04-2013
-
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
2/10
2
Introduction ---------------------------------------------------------------------------3
Requirements ------------------------------------------------------------------------4
Installation Development -------------------------------------------------------4
conclusion --------------------------------------------------------------------------10
-
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
3/10
3
INTRODUCTION
In this manual we will see step by step installation of Oracle
Database XE 11g R2 Express Edition as well as some relevantinformation about the DBMS, this is on the Windows platform, ie the
can follow this guide if you operating system is Windows XP, WindowsVista, Windows 7, Windows Server 2003, Windows Server 2008 and
Windows Server 2008 R2, for those who are installing on Windows
Vista or Windows 7 have to do it this way, select the executable, press
right mouse button and a menu will default on what is selected - Run
as administrator, this is important because if you do then you can have
problems during installation or if the installation is complete we will
either unforeseen errors.
-
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
4/10
4
REQUIREMENTS FOR INSTALLING HADWARE DBMSrequest value
SystemArchitecture
Intel x86 (desde Windows 2000 hasta seven) oLinux x86 (Debian, Mandriva, Novell, Red Hat yUbuntu )
NetworkProtocol
TCP/IP
Disk SpaceServer: 1.6 gigabytes minimum
Client: 75 megabytes
RAM256 megabytes least 512 megabytesrecommended
These ports are used by default Oracle Database XE
1521: Oracle database listener
2030: Oracle Services for Microsoft Transaction Server
8080: Port for Oracle XML DB and GUI Oracle Database XE
DBMS INFORMATIONOracle Database 11g Enterprise Oracle Application Release
includes a graphical development environment for building Webapplications with database. Oracle Database 11g is a reduced
version of Oracle with the same characteristics and potential ofOracle Database. It should be emphasized that supports all datatypes in Oracle Database XE.
Oracle Database 11g includes the following utilities:
SQL Command Line (SQL * Plus) to execute SQL commands and PL /SQL and execute scriptsSQL * Loader to insert data into the databaseUtilities to import, export and database dump
-
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
5/10
5
STEPS TO INSTALL ORACLE DATABASE 11G R2 IN WINDOWS XPSP3Once we have run the Setup window will appear here this first wemust put the path where Oracle Install It comes default C drive, butif you want you can install it on another drive as student D, Back E.
Then we asked the name of the database We will Oracle is thedatabase default Oracle and give you a password and confirm it.Then click Next.
3.-Now we will see the following interface appears we selecteddefault blue (Compatibility Check the root directory of Oracle. Herewe do not touch anything in sgte we click.
http://4.bp.blogspot.com/_p4Xfzbl1HFw/S6T1Bi1nAuI/AAAAAAAAAHY/TlWRj6oGc2E/s1600-h/d2.bmphttp://4.bp.blogspot.com/_p4Xfzbl1HFw/S6T2AaCod-I/AAAAAAAAAHg/HXeJ9nsG67M/s1600-h/d3.bmp -
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
6/10
6
4.-Here we see the sgte Interface Configuration Manager is only insgte we click.
5.-Now we only need to install Oracle We will install and click Done.Waited about 8-10 min.
6.-When we finished installing this confirmation window appears thatOracle has been installed successfully and we accept.
http://4.bp.blogspot.com/_p4Xfzbl1HFw/S6T3LKplQUI/AAAAAAAAAHw/6ILMB15IhZA/s1600-h/d5.bmphttp://3.bp.blogspot.com/_p4Xfzbl1HFw/S6T20YPv7eI/AAAAAAAAAHo/A4rw8-r5dWU/s1600-h/d4.bmp -
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
7/10
7
7.-Now we click Exit, and we see a small window asking forconfirmation or an output of the facility and give if
8.-Now let's test if Oracle is installed correctly. We go to the StartMenu ---- all programs --- we --- oracle-folder oradb11g_home1Control --- Oracle database and we click here.
http://1.bp.blogspot.com/_p4Xfzbl1HFw/S6T4tpgUTiI/AAAAAAAAAII/hTQpn48b_lg/s1600-h/d8.bmphttp://1.bp.blogspot.com/_p4Xfzbl1HFw/S6T3zWhRUmI/AAAAAAAAAH4/uEnAUv94DnE/s1600-h/d7.bmp -
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
8/10
8
9.-It appears in the Internet browser sgte Explore the window wherewe ask for the username and password the default user name issysman and put the password you typed in step 2.
And we will connect.
10.-We reached the final step where we see the Oracle interfacewhere we work.
http://3.bp.blogspot.com/_p4Xfzbl1HFw/S6T6e4Y1FgI/AAAAAAAAAIg/S-xEefjIqzo/s1600-h/d10.bmphttp://2.bp.blogspot.com/_p4Xfzbl1HFw/S6T5l3RICEI/AAAAAAAAAIQ/mc9O91zKKTM/s1600-h/d9.bmp -
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
9/10
9
Ready Hope you can aid these steps and if you have any questionssend me a comment.
http://1.bp.blogspot.com/_p4Xfzbl1HFw/S6T6WQR1YxI/AAAAAAAAAIY/1HDGKIjiL1Q/s1600-h/d11.bmp -
7/28/2019 Manual de Oracle Xp Sp3 - Ingles
10/10
10
CONCLUSIONTo conclude, this tool is very good from my point of view, because
you can do everything that is needed for database design,implementation and management of the same, and it is easier and
convenient to use this software if you you are interested indatabases.