Oracle – Page 5 – Database & Cloud

Dangerous behavior of ‘create spfile’ in 12c RAC

These days I was testing some commands of the system parameters and the PFILE/SPFILE, and unfortunately, I encountered a really bad bug in my test environment.My RAC DB is 12.1.0.2.0, and I did be...

11/04/2016Oracle1,311 viewsComments

Failed today

Today I failed the test, while I thought it is good for me.I didn't prepare well for the test, and the timeline was too urgent for me. I tried to learn all the things but in fact I almost lost all t...

25/02/2016Life101 viewsComments

Could I ignore the SID clause in command ‘alter system’?

When we change the parameters in the RAC systems, I always recommend to specify the SID clause clearly, which means you know which or all instances will be modified.If you ignore it, the result wi...

26/08/2021Oracle275 viewsComments

TNS-12533: TNS:illegal ADDRESS parameters

Several days ago I got this error when I wanted to start a Listener: TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/network/admin/listener...

09/11/2017Oracle1,834 views2

Register

Login

Retrieve password