Introduction, install, and configure Oracle on Windows.
Introduction to Database Management Oracle
- Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a database management object-relational, developed, delivered by Oracle Corporation.
- Oracle as a database administrator large and widely used worldwide.
- Oracle database management systems is a major management system, supporting a strong ability to manage data, data distribution over large information systems, decentralization.
- unsurpassed strength of ORACLE 10g, 11g is the ability to manage data from remote data access, distributed, support for online analytical systems (OLAP).
- Storage: Oracle stores data logically in tablespaces and files on the hard disk.
- A DBA can impose quotas on maximum storage per user trong each tablespace.
Installation on Windows
- Download Oracle Database version in https://oracle.com.
- Open the folder download, unzip and run setup.exe, such as the first screen, uncheck the box in the 2nd and click Next.
- At the next screen, click Create and select a configuration database.
- Next screen, choose Desktop or Server class and then click Next.
- next screen, choose the folder to install Oracle storage.
- Name the original database. Name oracle database consists of two parts Database_Name.Domain_Database_Name
- For example, we set the database name is orcl orcl.example.com the db_domain name is example.com (full name as on the Global Database Name is called - is the single global name defined in the whole database system system.)
- Set the default password for the user in the system, such as SYS, SYSTEM, ...
-
Can be set for each user on the next pass.
- next screen shows the options that the user has installed the user to summarize.
- It is possible to save the file on the drive to forget the room when this information later.
The necessary configuration information.
To view the configuration information for the database is:
Start -> run -> regedit -> browse to the directory in the Oracle Software and System.
The directory contains the configuration files needed% Database_home% / NETWORK / ADMIN
In the folder containing the file on as sqlnet.ora, listener.ora, tnsname.ora
In addition, we can create the file init <SID_NAME> .ora and init.ora directory for information on configuration necessary.
Create and granted to the user. Sign in to your user account on the local and remote machines.
Create users, asign permission.
$ CREATE USER user_name IDENTIFIED BY password $ GRANT role1, role 2, ... TO user_name
Access to the database on the local machine
> set orcl_sid = <sid_name>
> sqlplus /nolog
connect|conn username/password
connect|conn username/password@<database>
connect|conn sys as sysdba (connect as sysadmin)
Access database on a remote machine
Configure listener.ora on the server.
Listener role as one of the server headphones, listen to it instead of the database on the server. 1 listener can listen to multiple databases and 1 database can also be heard by many listeners.
- The <listener_name> is the name you want.
- For example, on the declaration allows listening orcl1 database (the database on the server orcl1.)
Configure tnsname.ora on the client.
tnsname.ora is one file containing the declaration of a database that allows clients to connect to. the database files in this report should be listening on the server side.
o Note: The host is the hostname or IP top of the database server.
o The <name> is the name of any place, the name used to access the command queries below. VD name is: orcl1
o Global_database_name is the name of the database on the server. As the example above is orcl1.example.com
Restart the listener on the server
Run -> cmd (admin) > lsnrctl stop > lsnrctl start=> Need return success status. otherwise => false.
Test configuration on successful or not in the client.
Run => cmd (admin)
> tnsping orcl1
=> Return OK => success, otherwise => false => reconfigure.
Access to server side from client
Run -> cmd
> sqlplus /nolog
> SQL> conn sys@orcl1 as sysdba
If the error ora-xxx: TNS ... then review tnsname.ora file.
The continue, i will write basic replication.(Read – only Materialized Views)
database oracle replication
0 comments:
Post a Comment