Oracle Database Instant Client

Oralce Database Client is an Oracle database client software that is simple and convenient to operate, powerful and practical. Using Oralce Database Client not only helps you connect to remote databases, but also has many other special features. Provide users with an efficient and convenient experience. Huajun Software Park provides you with Oracle database download.

Introduction to Oracle database functions

　　Complete data management capabilities:

1. Massiveness of data

2. Durability of data storage

3. Data sharing

4. Data reliability

　　Completely related products:

1. Information guidelines

2. Guidelines for ensuring access

3. View update guidelines

4. Data physical and logical independence criteria

Oracle database installation steps

1. After downloading Oracle Database Instant Client 11g directly on this page, double-click to install it. You will be prompted with the number of bits of the software. If it is the same as the computer, click "Yes" to continue the installation. If it is not compatible, re-download other versions.

2. Enter the Oracle Database Instant Client 11g installation interface, as shown in the figure below, we click Next to continue the installation.

3. Enter the Oracle database license agreement interface, and click the I accept option at the bottom of the interface to continue the installation. If you do not accept the agreement, the installation cannot be performed. Click Cancel to exit.

4. Enter the selection interface. As shown below, there are different components that you need to choose from. After completing the selection, click Next at the bottom of the interface. If you know what the components do, you can freely choose the components you need. If you are a newbie, then you can just follow its default functional components.

5. Enter the Oracle database installation location selection interface. You can choose the default installation and click Next. The software will be installed to the system C drive by default, or click Browse to select the appropriate installation location, and then click Next.

6. Enter the start menu folder selection interface, as shown in the figure below. You can select the default menu folder or enter a new menu folder, and then click Next.

7. Enter the Oracle database start menu visibility selection interface. You can choose to create a start menu for all users, or only create a start menu for the current user. After selecting, click Next.

8. Enter the Oracle database preparation installation interface. In this interface, you can see the previously set installation location, functional components and other information. After confirming that it is correct, click Install.

9. The Oracle database is being installed. We just need to wait patiently for the installation progress bar in the picture below to be completed. The installation speed is relatively fast. We can open and use it after the Oracle database installation is completed.

Oracle database usage tutorial

　 How to create a user in Oracle database? How to create a new user?

1. First, we need to download and install the Oracle database on this site. Next, we open the Oracle console, then enter the account and password to log in and enter the main interface of the software, as shown in the figure below.

2. After we find the server option in the figure below on the main interface of the Oracle database and click it, there will be security in the interface. We click on the user option under it to enter the next step.

3. Enter the user interface, as shown in the figure below. There is an existing user account in this interface. We click the create option in the upper right corner, and then proceed to the next step.

4. Enter the Oracle database creation user interface. We need to enter the name, password, default table space and other information in the general information column of the interface. After the input is completed, go to the next step. If you don't have high control over the database, you only need to configure general information and roles.

5. Next, we click the role column, and then the user role editing window pops up. After clicking the role label, the user role editing pops up. We can set the permissions of the role. Then assign the roles to the corresponding users.

6. Click the "Edit Role" option, and we can enter the role editing window. Then we will select the user role and click the "Move" button. Select the role from the left frame to the right frame to indicate that the addition is successful, or you can directly double-click the left role to add the role to the right frame.

7. After we successfully add the role in the previous step, we can click the OK button in the upper right corner of the interface, so that we can complete the creation of the user, and you can find the user role just created in the user list. The above is the detailed method for creating a new Oracle database or creating a user brought by the editor. Friends in need can download and use it.

oracle database frequently asked questions

　 Oracle database configuration failed?

Add listening to deng-PC (local host name) or IP address in listener.ora. The specific steps are as follows:

1. Start the oracle configuration tool (NCA), add an address under "Listener" - Listener, write the computer name or IP as the host name, the port number is still 1521, and then save.

You can also manually modify the listener.ora file

2. Restart the monitoring service

3. Set system environment variables.

Set oracle_HOME:

The variable value is set to: D:appdengproduct11.2.0dbhome_1

First, in the environment variables, the Oracle client configuration in the path must be behind the server, otherwise an error will be reported (ORA-12560: TNS: protocol adapter error).

Second, in the environment variable, ORACLE_HOME=D:appdengproduct11.2.0dbhome_1 (must be the server address, not the client address).

Third, in the environment variable, ORACLE_SID=ORCL (Oracle instance name, that is, database name)

Fourth, in the environment variable, TNS_ADMIN=D:oracleproduct10.2.0client_1NETWORKADMIN (that is, set the tnsname.ORA file in the Oracle version to be called)

4. Start the Database configuration Assistant "Configuration Database Option" to reconfigure em without deleting the database. The above error will not be reported when the database is created again.

How to uninstall oracle database?

1. First, after we install the oracle database on the computer, we can click the Start option in the lower left corner of the computer desktop, and then the menu bar will pop up. We find the oracle database in the options in the menu and select the oracle folder. As shown below.

2. After we open the oracle database folder, as shown in the figure below, we can see the file named oracle installation products. We double-click the folder with the left mouse button to enter.

3. After entering the folder, we can see that there is a universal installer option, which is "Universal Installer". We double-click this option to proceed to the next step.

4. Next, we can enter the welcome interface of oracle universal installers as shown in the figure below. We can see the option to uninstall the product in the interface. We click to uninstall the product.

5. As shown in the figure below, we enter the product list interface. We select the installed Oracle product, and then click the delete option at the bottom of the interface to start uninstalling the Oracle database. We can close the interface after the uninstallation is completed.

　　How to import dmp file into oracle database?

1. First, we open sqldeveloper and enter the login interface, as shown in the figure below. Enter the user name, password, database and other information, and then click OK to log in and enter the main interface.

2. We click the Tools option above the main interface of the Oracle database, then find the export table option in the drop-down option and click it, and then proceed to the next step.

3. Enter the export interface, as shown in the figure below. We need to select the exported table, then select the save location in the output file at the bottom of the interface, and click the Close option after completing the selection.

4. Next, we return to the main interface, click Tools Options, find the Import Table option in the drop-down menu bar, click it, and then proceed to the next step.

5. Enter the import interface, where we select the file path to be imported, and click the Close option after the selection is completed. In this way we can complete the import and export of dmp files.

Oracle database update log

1. This software is suitable for 32-bit systems, and 64-bit systems are also available;

2. This time, a problem in reading and writing the registry when installing this 32-bit package on a 64-bit system has been fixed;