Manual Oracle database creation

To sum up, manual database creation is a basic skill that DBAs must possess. Of course, it is not always usable, but it can be clearly understood by me.

What is the directory structure of Oracle? Oracle files, tablespaces, authentication methods, and other concepts. Of course, you need to work on your own. Of course, don't forget the most important thing.

These are all for us to learn how to plan oracle. Of course, this is difficult. Learn it slowly.

Before creating a database:

Unique instance name and Database Name

Character Set

Confirm parameter file

Database status (three stages: nomount, mount, and open: Of course, you need to understand the files started in these three stages)

Logs

Database creation

Generate data dictionary

Create a user tablespace.

Note: The above points must be mastered.

Create a database named cuug and support Chinese Characters

1. Create a password file.

Before creating a password file, let's take a look at the authentication methods such as OS and oracle. By default, operating system authentication is enabled after each platform is installed.

That is to say, you can log on without the user name or password.

OS authentication: you can log on to the operating system as an administrator to log on to the database.

Oracle (password file): You must log on with an oracle Administrator Account (the default is sys. Of course, you can also authorize dba by sys ).

Oracle provides us with an orapwd tool, which is very convenient to use. Password text

In the $ ORACLE_HOME/dbs directory (the password file orapwdcuug is created here)

Use orapwd to create a password file

Command: -- orapwdfile = orapwdSID password = password entries = n force = y;

Number of Entries user connections.

1 2 3 Next Page