Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

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

2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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

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.

Views: 252

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report