Oracle Learning Notes Section 4 some introduction after installing the database (including how to view the status of the library)

To install the database, generally install the grid infrastructure first, and then install the database, and the network must first come out on port 1521 on the pre-installed grid infrastructure.

Each time the template library is built, there will be an avatar. Look at the avatar.

You have to decide which environment variable is before you read it.

Sqlplus / nolog

Conn / as sysdba

Show user

Check the status of the database, mainly based on two views

Desc v$database_incarnation

Set linesize 10000 will fold the line display at 80 by default.

Select * from vested database national; see running CURRENT on No.2

The auxiliary al16 utf16 international code al32utf8 is a subset of these two.

If the main zhs16gpk is coded in China + al32utf8, then all can be solved.

Once the database character set is selected, it is difficult to change, otherwise it will encounter a lot of unpredictable problems and a lot of garbled code.

NLS_LANG in the registry of the client needs to be implicitly converted. Windows must be zhs16gpk. Linux and mac can only write AL32UTF8 (default code table).

OFA-OMF

In dbca, if only oracle programs are installed on a server, then 80% of the memory can be allocated to oracle and 20% to the operating system.

. Oraenv toggles oracle environment variables

Conn / as sysdba

Show parameter db_name

Show parameter db_domain

Show parameter service should correspond to lsnrctl service.

Startup opens the database to mounted state to opened