Shulou(Shulou.com)06/01 Report--

It is believed that many inexperienced people have no idea about how to create an oracle database in the Linux server. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Steps to create a database instance:

1. Open xshell, create a new session, enter the host address: 10.4.10.52, and other defaults.

two。

3. Enter the server host user name root, password xxx, and enter the session

4.

5. Type su-oracle, and enter to enter the oracle directory

6.

7. Set the dbca environment variable and enter export DISPLAY= local IP:0.0; (local xmanager port 0.0)

8. Enter dbca to open the dbca interface; (that is, open the local xmanager to enter the visual DBCA interface)

9.

10. Create a database instance in the local dbca interface and follow the steps

11.

twelve。 Create a typical database configuration; global database name: orcl;SID:orcl; administrator user password: orcl_01; pluggable database name:pdb

13.

14. The database is created; (the typical database is configured as the default configuration Typical configuration, which is relatively easy to create, and all are some of the default settings of Oracle; there are many advanced configuration Advance configuration configurations, such as monitoring, storage location, file variables, database options, initialization parameters, and so on. )

15.

16.

17. Click Finish to start creating the database

18. 19. By default, only two sys/system users are unlocked, and all other users are locked. You can click Password Management to unlock the user and set the password. (for example, the SYSBACKUP user is unlocked and the password is set to sysbackup)

20.

21. Click close to finish creating database instances.

Second, connect to Oracle database instance

1. Open xshell to connect to Oracle database server 10.4.10.52

two。 Input. Oraenv; ORACLE_SID enter orcl; to enter Oracle environment

3.

4. Enter sqlplus sys/orcl_01 (database user / password) as sysdba to connect to the database.

5.

6. You can then manipulate the database, creating users, authorizations, creating tablespaces, creating tables, backing up, restoring, and so on.

After reading the above, have you mastered how to create an oracle database in the Linux server? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.