Есть полностью вновь установленная Docker имидж Oracle 19c.
Подключаюсь коммандой sqlplus / as sysdba. После подключения любой запрос выдаёт ошибку, например:
SELECT * FROM all_users
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Ну если не доступно, тогда пробую запустить БД:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initorclcd.ora'
Проверяю запущенные процессы:
$ ps aux | grep pmon
oracle 22 0.0 0.2 2028516 66372 ? Ss 21:52 0:00 ora_pmon_ORCLCDB
oracle 2421 0.0 0.0 9112 852 pts/1 S+ 22:47 0:00 grep --color=auto pmon
И выглядит, что всё работаеет.
Что тут не так?
Свободный перевод вопроса sqlplus :: ORA-01078: failure in processing system parameters от участника @Francesco Mantovani
задан 20 июл 2020 в 17:23
0xdb0xdb
51.4k194 золотых знака56 серебряных знаков233 бронзовых знака
1
Образ БД имеет SID ORCLCDB, что видно по суфиксу PMON процесса.
Но при попытке запустить БД, идёт обращение к файлу инициализации initorclcd.ora, а это заначит, что его поиск был для SID orclcd.
Думаю, опечатка при установке переменной окружения ORACLE_SID, недoстaет последней «B».
- проверте, что сейчас установлено:
echo $ORACLE_SID - установите правильно:
export ORACLE_SID=ORCLCDB; . oraenv - сделайте установку постоянной:
echo "export ORACLE_SID=ORCLCDB; . oraenv" >> ~/.bashrc
Теперь запустите SQL*Plus и всё должно работать.
Свободный перевод ответа от участника @Connor McDonald
ответ дан 20 июл 2020 в 17:23
0xdb0xdb
51.4k194 золотых знака56 серебряных знаков233 бронзовых знака
У Вас не выставлены переменные окружекния
export ORACLE_SID=ORCLCDB
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_BASE=/opt/oracle
sqlplus / as sysdba
И работайте на здоровье.
Можно еще проверить содержание файла oratab.
cat etc/oratab
ответ дан 22 июл 2020 в 11:03
2
public:5266_issue:ora-01078:failure_in_processing_system_parameters_error_when_restoring_an_oracle_12c_database_to_an_alternate_location_on_a_windows_server
Table of Contents
Article ID:
5266
Reviewed:
2017-08-07
Product Version:
AhsayOBM: 7.5.0.0 to 7.x
OS: Windows
ATTENTION
1st January, 2022: v7 officially End-of-Life [details]
Problem Description
</b>
<br/>
When performing a Oracle 12c database restore to an Alternate location on a Windows server the following error message is shown:
<br/>
<br/>
<table 800“=”“ border=“0” cellpadding=“0” cellspacing=“0” width=“700”>
<!-- <tbody>tr --> <tr> <!-- td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> No. </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Type </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Timestamp </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Log </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> * </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> ... </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> ORA-01078: failure in processing system parameters </span> </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </b> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> LRM-00109: could not open parameter file </span> </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </b> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> Restore database fail., Reason = "Set database parameter fail" </span> </td> <!-- td --> </tr> <!-- tr<br /><br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> * </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> info </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> ... </td> <!-- td --> </tr> <!-- tr<br />[/td1][/tr]</tbody> -->
</table>
<br/>
</html>
Cause
This is a known issue on AhsayOBM v7 when restoring an Oracle 12c database to an Alternate location on a Windows server. If the «Temporary directory for storing restore files» is left on the default setting, i.e.
«C:UsersAdministratortemp»
. As the Windows account used to start the Oracle database service does not have permission to access the folder
«C:UsersAdministratortemp»
.
Resolution
To workaround this issue either:
Change the «Temporary directory for storing restore files» to location where the Oracle service has full read and write permissions.
OR
Grant full read and write permission to the «C:UsersAdministratortemp» folder to the Oracle login account.
Keyword
Oracle 12c, Windows, Alternate location, temporary folder, permission, restore
· Last modified: 2021/12/16 05:41 by
anna.olalia
by Mohamed Azar on April 27, 2010
I tried to start my test db , it shows following errors, I struggled with these errors, though finally i find out and fix it. oops but It’s so easy 🙂
Enter user-name:sys/sys as sysdba Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora' SQL> exit Disconnected [oracle@localhost dbs]# ls hc_azar.dat initdw.ora lkAZAR orapwazar spfileazar.ora hc_TEST.dat init.ora lkTEST orapwTEST spfileTEST.ora
Here inittest.ora file is does not exist, so i created pfile from spfile and then It’s working.
SQL> create pfile from spfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/spfileTEST.ora'; File created. SQL> startup ORACLE instance started. Total System Global Area 285212672 bytes Fixed Size 1218992 bytes Variable Size 92276304 bytes Database Buffers 188743680 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL>
Or
If you’re not set proper SID Path , you may get this error
[oracle@netbackuptest ~]$ cat /etc/oratab netbktest:/u01/app/oracle/product/11.2.0/dbhome_1:N cigna:/u02/oracle/product/10.2.0/db_1:N brokertest:/u02/oracle/product/10.2.0/db_1:N The above three are my current database. Here I'm going to set another Oracle Sid here, [oracle@netbackuptest ~]$ export ORACLE_SID=testdb [oracle@netbackuptest ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 25 08:56:42 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u02/oracle/product/10.2.0/db_1/dbs/inittestdb.ora' SQL> exit Disconnected
If I set proper Oracle SID , I can able to start the database.
[oracle@netbackuptest ~]$ export ORACLE_SID=cigna [oracle@netbackuptest ~]$ sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 25 08:57:28 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1224736768 bytes Fixed Size 2020384 bytes Variable Size 167775200 bytes Database Buffers 1040187392 bytes Redo Buffers 14753792 bytes Database mounted. Database opened. SQL>
Hi friends,
How to resolve LRM-00109 with ORA-01078 errors?
— Advertisement —
New article has been realeased for solution of ORA-01078 with LRM-00109 errors.
Generally these errors are occurring due to not exist of pfile or spfile on system. May be oracle doesn’t find out parameter file in default location. Or may be file there but contents of file is wipe off.
Read full article to our website “Oracle DBA Tips and Articles”
You can directly read article from direct link “How to resolve LRM-00109 with ORA-01078 errors”
— Advertisement —
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.
— Advertisement —
ORA-01078
ORA-01078: сбой в посылаемых системных параметрах
Причина:
Сбой произошел во время обработки параметров INIT.ORA в течении запуска системы.
Действие:
Справляйтесь по диагностической информации в стеке сопровождающего сообщения об ошибке в трейс файле, и на основании этого можете предпринять соответствующее действие.