I tried to restore because the Oracle database initialization parameter setting failed.

Make a note so as not to forget it.

What happened

I didn't notice that I set the initialization parameter incorrectly from sqlplus, and when I did shutdown with momentum, it never started again. If you don't fix the initialization parameters, it won't start! It seemed to be said, so I managed to do it image.png

environment

Term notes

What i did

$ sudo su - oracle
$ ls /u01/app/oracle/diag/rdbms/
odgb_nrt1ws
$ sudo su - grid
$ asmcmd ls -l +DATA/odgb_nrt1ws/PARAMETERFILE/
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   OCT 03 16:00:00  Y    spfile.286.1048251613
$ sudo su - grid
$ asmcmd cp +DATA/ODGB_NRT1WS/PARAMETERFILE/spfile.286.1048251613 /tmp
copying +DATA/ODGB_NRT1WS/PARAMETERFILE/spfile.286.1048251613 -> /tmp/spfile.286.1048251613
$ sudo su - oracle
$ sqlplus / as sydba
sql> create pfile='/tmp/tmp.pfile' from spfile='/tmp/spfile.286.1048251613';
File created.
 
sql> exit
$ ls -l /tmp
-rw-r--r-- 1 oracle asmadmin 3705 Oct  3 16:35 tmp.pfile

Corrected the value of "sga_max_size" that failed this time "Sga_target" has also changed, so fix it for the time being

$ vim /tmp/tmp.pfile
~
*.sga_max_size=20401094656
*.sga_target=14495514624
~
⬇︎
~
*.sga_max_size=6G
*.sga_target=3G
~
$ sudo su - oracle
$ sqlplus / as sysdba
sql> startup mount pfile='/tmp/tmp.pfile';
ORA-00821: Specified value of sga_target 3072M is too small, needs to be at least 4656M
ORA-01078:Failed to process system parameters

After the correction, it starts properly this time. ..

SQL> startup mount pfile='/tmp/tmp.pfile';
The ORACLE instance has started.

Total System Global Area 6442449872 bytes
Fixed Size                  9149392 bytes
Variable Size            4848615424 bytes
Database Buffers         1560281088 bytes
Redo Buffers               24403968 bytes
The database has been mounted.
SQL> 
sql> create spfile='+DATA' from pfile='/tmp/tmp.pfile';

The file has been created.
sql> shutdown  

The database has been dismounted.
The ORACLE instance has been shut down.
$ sudo su - grid
$ asmcmd ls -l +DATA/ODGB_NRT1WS/PARAMETERFILE/
Type           Redund  Striped  Time             Sys  Name
PARAMETERFILE  UNPROT  COARSE   OCT 03 17:00:00  Y    spfile.285.1052845549
PARAMETERFILE  UNPROT  COARSE   OCT 03 16:00:00  Y    spfile.286.1048251613
$ sudo su - oracle
$ srvctl modify database -db odgb_nrt1ws -spfile +DATA/odgb_nrt1ws/PARAMETERFILE/spfile.285.1052845549
$ srvctl start database -db odgb_nrt1ws
$ srvctl status database -db odgb_nrt1ws
 Instance odgb is running on node odgb
$ sqlplus / as sysdba

racle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0
Connected to.

Somehow recovered. .. ..

Now it works normally. I realized that it would be dangerous if I made a mistake when playing with the initialization parameters, so be careful. .. ..

Recommended Posts

I tried to restore because the Oracle database initialization parameter setting failed.
I tried to move the ball
I tried to estimate the interval.
I tried to summarize the umask command
I tried to recognize the wake word
I tried to summarize the graphical modeling.
I tried to estimate the pi stochastically
I tried to touch the COTOHA API
Python -I tried to restore the dictionary comprehensive notation to its original form-
I tried web scraping to analyze the lyrics.
I tried to optimize while drying the laundry
I tried to save the data with discord
I tried to touch the API of ebay
I tried to correct the keystone of the image
Qiita Job I tried to analyze the job offer
LeetCode I tried to summarize the simple ones
I tried to implement the traveling salesman problem
I tried to predict the price of ETF
I tried to vectorize the lyrics of Hinatazaka46!
I tried to make it easy to change the setting of authenticated Proxy on Jupyter
I tried to learn the sin function with chainer
I tried to graph the packages installed in Python
I tried to detect the iris from the camera image
I tried to summarize the basic form of GPLVM
I tried to touch the CSV file with Python
I tried to predict the J-League match (data analysis)
I tried to solve the soma cube with python
I tried to put pytest into the actual battle
[Python] I tried to graph the top 10 eyeshadow rankings
I tried to visualize the spacha information of VTuber
I tried to erase the negative part of Meros
I tried to solve the problem with Python Vol.1
I tried to simulate the dollar cost averaging method
I tried to redo the non-negative matrix factorization (NMF)
I tried to identify the language using CNN + Melspectogram
I tried to notify the honeypot report on LINE
I tried to complement the knowledge graph using OpenKE
I tried to classify the voices of voice actors
I tried to compress the image using machine learning
I tried to summarize the string operations of Python
I tried to debug.
I tried to paste
I thought a little because the Trace Plot of the stan parameter is hard to see.
When I tried to install Ubuntu 18.04, "Initramfs unpacking failed: Decoding failed" was displayed and the startup failed.
I forgot to evaluate the performance because of the habit of skipping "I tried to aim for the fastest FizzBuzz"
I tried to find the entropy of the image with python
I tried to find out the outline about Big Gorilla
I tried to introduce the block diagram generation tool blockdiag
I tried porting the code written for TensorFlow to Theano
[Horse Racing] I tried to quantify the strength of racehorses
I tried to simulate how the infection spreads with Python
I tried to analyze the whole novel "Weathering with You" ☔️
[First COTOHA API] I tried to summarize the old story
I tried to get the location information of Odakyu Bus
I tried to notify the train delay information with LINE Notify
I tried to simulate ad optimization using the bandit algorithm.
I tried to summarize the code often used in Pandas
I tried to illustrate the time and time in C language
I tried to display the time and today's weather w
[Python] I tried to visualize the follow relationship of Twitter
I tried to summarize the commands often used in business