C # Operations in the Windows environment Oracle 10G/11G Insights

Starting from August to receive a project, the business logic is not complicated, because there is no previous experience of the C#L connection to Oracle, so the stumbling, and now finally finished. Now comb the way of the experience.

The first is the Oracle download installation. Start directly from the official website under 11g, download the required after you install the server and client. After the installation is complete, you must first configure the listener. DOS Enter LSNRCTL status to view the current listening status. Input NETCA Enter

Monitor the configuration interface. Note that a server is generally as long as a listener, 2 monitoring will be chaotic. Configuring the parameters of the listener is as good as the default. Then lsnrctl the start command to start monitoring. Input Sqlplus sys/yf9450206 as Sysdba

You can connect to it. Note the contents of the Dbhome_1\network\admin\tnsnames file under the server and client NETWORK folders are exactly the same. If the Oracle client wants to connect to the server remotely, the client's

Configure the IP address and port number of the remote database server on Netmanager and enter Sqlplus sys/[email protected]/ORCL as SYSDBA connection. If the client is a win764 bit and the Oracle client is 32-bit, you should set the Allow 32-bit program to run on IIS on the publishing site.

In the program, C # connects Oracle with OLE DB connections. The first is the connection string. The following is an example connection string <add key= "ConnectionString" value= "user id=sa;password=*******;d ata source=127.0.0.1;persist Security Info=false;initial catalog=cooper "/>. This allows Oracle to successfully connect to the C # program.

Another: When I finished the project only to find that the company has a configured Oracle 10g database, installed directly can be used. is a lot of detours, but also learned a lot of things.

C # Operations in the Windows environment Oracle 10G/11G Insights