One, the Oracle 11g database download, installation:
Download:
Then, based on this hyperlink build your own user, database.
Http://wenku.baidu.com/view/caa21c1a650e52ea551898e2.html
Second, Navicat Premium connect Oracle
1. Review the Tnsnames.ora file in the installation directory (F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN).
2, the connection, the first configuration option under the Oci file, download:
Associated with the time,:
OCI directory: D:\tools\instantclient-basic-nt-12.1.0.2.0\instantclient_12_1\oci.dll;
Sql*plus Directory: F:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus.exe
3. New Oracle Connection:
Connection Property settings:
4, note, based on the above connected database establishment, you can use the user sys, advanced property settings: SYSDBA; and Scott, you can go in, you can go in your own built services fame Bookmana.domain, and Sid named Bookmana database. However, when manipulating the table, be careful to add different select,insert,delete,update permissions to different users.
If you use your own user (Bookmana) to go in, create a new table, with Navicat's own "dump SQL" structure and data features, automatically add double quotes to the table name and database name. Raise an error:
A small book management system with an SSH framework that modifies the SQL Server 2005 database to some of the problems encountered by the Oracle database is summarized under