Oracle's Stuff.

Source: Internet
Author: User

Recently do the DRP project, can be the Oracle toss miserably, the first time installation of rough doomed after the temper, now I put these blood and tears of history are organized here, hoping to help you in Oracle's connection less detours, less hit several times the south wall.

§ Database connection:

In connection with this issue, we use XML files to connect MyEclipse and Oracle 11g together, so that our DRP project can acquire and manipulate data in Oracle, creating a new XML file under the SRC folder with the following content:

<span style= "FONT-FAMILY:FANGSONG_GB2312;FONT-SIZE:18PX;" ><?xml version= "1.0" encoding= "UTF-8"?><config><db-info><driver-name> Oracle.jdbc.driver.oracledriver</driver-name><url>jdbc:oracle:thin: @localhost (or IP of the machine where Oracle is located) : 1521: Database name </url>  <user-name> user name when Oracle is installed </user-name><password> password set when Oracle is installed < /password></db-info></config></span>

Where Jdbc:oracle:thin: Is the default method used, 1521 is the default port number, if set, change to the set port number.

installation of §oracle :

When I was installing Oracle 11g, I was referring to this blog http://blog.csdn.net/u010158267/article/details/42031655, but when I installed it, I clicked on the next step and then there was a two graph problem:

This problem is because the machine cannot connect to the email address you have filled in, so you can change your email address or leave it blank. Then click "Continue". This will allow the installation to proceed smoothly.

use of sqlplus in §oracle

After Oracle installation is successful we need to open sqlplus to implement the connection, here are some common problems:

1. Protocol Adapter Error

This is due to the fact that the local Oracle-related 6 services are not turned on, so open the Task Manager to turn on all services except the red box:


Then re-enter the user name and password in the Sqlplus, waiting for the news!

2.ERROR ora-01034:oracle Not available error

After solving the first problem, my sqlplus again appeared this problem, how to do? That's what's called "the ensuing!"

Check some information, follow the steps below to solve this problem:

(1) Open run, enter sqlplus "Sys/password as Sysdba", and then wait for the command Window "Connection successful, prompt connected to idle journey" after the command window after the sql> command line input startup

(2) Continue to wait, when the command window prompts the database to load, the database has been opened, we can directly enter some SQL statements, Oracle data table for the operation of the increase and deletion check.

PS: If the errors appear not only the above two, please refer to: reference URL ;


"Text does not match format string" in 3.sqlplus

When I wanted to use it to enter data into a data table, it sent me a signal of protest:

This is due to a problem with date format data, so we need to change the way we entered the date:

In this way we have successfully solved the error related to Sqlplus, so that it can better serve us.

These are my current mistakes in the small summary, I hope that through the history of my blood and blood to help you reduce some detours, can be more efficient development. Solve the error, let us develop together, refueling, small partners!!

Oracle's Stuff.

Related Article

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.