Oracle "Database" configuration and ADO. Net "accessing Oracle Database" Method

1. Enable the Scott user and specify the password.

2. To enable SQL developer, you must configure the Java Virtual Machine. If it is oracle32bit, you can directly use oracle java.exe. If it is oracle64-bit, you can download the "java7 64bit plugin" from the official website, and then install and define its own java.exe path, because the "SQL developer" for oracle64-bit is 32-bit. Alternatively, install the 64-bit "SQL developer ".

3. Change "Scott" to "dba"
Sqlplus sys/123456 @ orcl as sysdba
Grant DBA to Scott;

4. import data.
IMP Scott/123456 @ orcl file = D: \ cmdatas \ waterdatas \ 2012-12-07.dmp fromuser = energy touser = Scott log = D: \ cmdatas \ waterdatas \ 2012-12-07.txt

SCOTT: User Name

123456: Password

Orcl: Database

File: Location of the backup file

Fromuser: Backup user

Touser: restore a user

Log: Process log files

5. "TNS" must be configured for data import. You can use "net configuration assistant" and "net manager" to configure the listening address and network service.

6. Ado. netProgramTo connect to the Oracle database, you must install the "Oracle client" on the client where the program is located, and ensure that the "Oracle client" can be connected to the "oracle" server. Only such ADO. net
To access the "oracle" data server.

7. Use WebService on the data layer to Avoid installing the driver on the client.

8. The "32-bit" Oracle client can connect to the "64-bit ORACLE Server", and the "Oracle 11g client" can connect to the "Oracle 10g server", and vice versa.

10. For "listener. ora" and "tnsnames. ora", you can directly copy the "oracle" server to the program connected to the "client", which is generally easy to use.