Oracle dba on CentOS: STARTUP configuration problems after Oracle is installed

1. Unable to initialize the database file

After we installed Oracle, we couldn't wait to start it. come on

Use an oracle user to log on to the system

$ Dbstart $ ORACLE_HOME

The following error is returned:

Cannot read $ ORACLE_BASE/admin/dbs/initORCL. ora

Unable to read the $ ORACLE_BASE/admin/dbs/initORCL. ora File

Cause:

The file cannot be read when the database is initialized.

Solution:

Generate database Initialization File
Source File $ ORACLE_BASE/admin/dbs/init. ora
Target File $ ORACLE_BASE/admin/dbs/initORCL. ora
Change <ORACLE_BASE> In the lecture file to the corresponding address.

OK. Restart the oracle service.

2. memory_target is greater than/dev/shm

$ Sqlplus/as sysdba

Connect to the database and start the oracle instance now

Idel> startup

Then, an error is returned:

Memory_target not supported on this system

Memory capacity cannot meet System Requirements

Cause: sga, pga is greater than/dev/shm

Sga is the global zone of oracle and an important area of the database.

/Dev/shm is a shared memory structure in linux. By default, its size is limited by the physical memory. in fact, its actual size can be set to (physical memory + swap) to store some shared data structures during inter-process communication. Generally, when the physical memory is sufficient, data is exchanged in the memory. If the physical memory is insufficient, swap is used for data exchange. supports dynamic online adjustment. we can increase or decrease its size as needed.

1 2 Next Page