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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.