Ошибка при установке oracle 11g

I installed Oracle 11g XE on my Windows computer (running on Windows XP Pro), but unfortunately, can’t get it to work. There are no errors that the GUI installer shows up during the installation and I get the «installed successfully» message, but when I try to connect to Oracle using the SQL command prompt, I get the following error:

SQL> connect
Enter user-name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

The ‘Get Started’ shortcut icon takes me to :

http://127.0.0.1:8080/apex/f?p=4950

which gives me an «Unable to Connect» message

After having spent 2 days doing research on this, I found out that apart from this being a Listener issue, my ‘oradataXE’ folder located at: E:oraclexeapporacleoradataXE is empty. I think it should have contained the control files etc.

There are some errors related to creation of control files etc. reported in the log files located at : E:oraclexeapporacleproduct11.2.0serverconfiglog and am pasting them here ->

cloneDBCreation.log

SQL> Create controlfile reuse set database "XE"
  2  MAXINSTANCES 8
  3  MAXLOGHISTORY 1
  4  MAXLOGFILES 16
  5  MAXLOGMEMBERS 3
  6  MAXDATAFILES 100
  7  Datafile
  8  'E:oraclexeapporacleoradataXEsystem.dbf',
  9  'E:oraclexeapporacleoradataXEundotbs1.dbf',
 10  'E:oraclexeapporacleoradataXEsysaux.dbf',
 11  'E:oraclexeapporacleoradataXEusers.dbf'
 12  LOGFILE
 13  GROUP 1 SIZE 51200K,
 14  GROUP 2 SIZE 51200K,
 15  RESETLOGS;
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed 
ORA-01565: error in identifying file 
'E:oraclexeapporacleoradataXEsystem.dbf' 
ORA-27041: unable to open file 
OSD-04002: unable to open file 
O/S-Error: (OS 2) The system cannot find the file specified. 


SQL> exec dbms_backup_restore.zerodbid(0);
BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file 
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4754 
ORA-06512: at line 1 


SQL> shutdown immediate;
ORA-01507: database not mounted 


ORACLE instance shut down.
SQL> startup nomount pfile="E:oraclexeapporacleproduct11.2.0serverconfigscriptsinitXETemp.ora";
ORACLE instance started.

Total System Global Area  535662592 bytes                                       
Fixed Size                  1384760 bytes                                       
Variable Size             226496200 bytes                                       
Database Buffers          301989888 bytes                                       
Redo Buffers                5791744 bytes                                       
SQL> Create controlfile reuse set database "XE"
  2  MAXINSTANCES 8
  3  MAXLOGHISTORY 1
  4  MAXLOGFILES 16
  5  MAXLOGMEMBERS 3
  6  MAXDATAFILES 100
  7  Datafile
  8  'E:oraclexeapporacleoradataXEsystem.dbf',
  9  'E:oraclexeapporacleoradataXEundotbs1.dbf',
 10  'E:oraclexeapporacleoradataXEsysaux.dbf',
 11  'E:oraclexeapporacleoradataXEusers.dbf'
 12  LOGFILE
 13  GROUP 1 SIZE 51200K,
 14  GROUP 2 SIZE 51200K,
 15  RESETLOGS;
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed 
ORA-01565: error in identifying file 
'E:oraclexeapporacleoradataXEsystem.dbf' 
ORA-27041: unable to open file 
OSD-04002: unable to open file 
O/S-Error: (OS 2) The system cannot find the file specified. 


SQL> alter system enable restricted session;

System altered.

SQL> alter database "XE" open resetlogs;
alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted 


SQL> alter database rename global_name to "XE";
alter database rename global_name to "XE"
                                     *
ERROR at line 1:
ORA-01109: database not open 


SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open 


SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-01109: database not open 


SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01507: database not mounted 


SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'E:oraclexeapporacleoradataXEtemp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
ALTER TABLESPACE TEMP ADD TEMPFILE 'E:oraclexeapporacleoradataXEtemp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01109: database not open 


SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
select tablespace_name from dba_tablespaces where tablespace_name='USERS'
                            *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only 


SQL> select sid, program, serial#, username from v$session;

       SID PROGRAM                                                              
---------- ----------------------------------------------------------------     
   SERIAL# USERNAME                                                             
---------- ------------------------------                                       
         1 ORACLE.EXE (PMON)                                                    
         1                                                                      

         2 ORACLE.EXE (VKTM)                                                    
         1                                                                      

         3 ORACLE.EXE (DIAG)                                                    
         1                                                                      


       SID PROGRAM                                                              
---------- ----------------------------------------------------------------     
   SERIAL# USERNAME                                                             
---------- ------------------------------                                       
         4 ORACLE.EXE (DIA0)                                                    
         1                                                                      

         5 ORACLE.EXE (DBW0)                                                    
         1                                                                      

         6 ORACLE.EXE (RECO)                                                    
         1                                                                      


       SID PROGRAM                                                              
---------- ----------------------------------------------------------------     
   SERIAL# USERNAME                                                             
---------- ------------------------------                                       
         8 ORACLE.EXE (CKPT)                                                    
         1                                                                      

         9 sqlplus.exe                                                          
         3 SYS                                                                  

        10 ORACLE.EXE (MMNL)                                                    
         5                                                                      


       SID PROGRAM                                                              
---------- ----------------------------------------------------------------     
   SERIAL# USERNAME                                                             
---------- ------------------------------                                       
        88 ORACLE.EXE (PSP0)                                                    
         1                                                                      

        89 ORACLE.EXE (GEN0)                                                    
         1                                                                      

        90 ORACLE.EXE (DBRM)                                                    
         1                                                                      


       SID PROGRAM                                                              
---------- ----------------------------------------------------------------     
   SERIAL# USERNAME                                                             
---------- ------------------------------                                       
        91 ORACLE.EXE (MMAN)                                                    
         1                                                                      

        92 ORACLE.EXE (LGWR)                                                    
         1                                                                      

        93 ORACLE.EXE (SMON)                                                    
         1                                                                      


15 rows selected.

SQL> alter user sys identified by "&&sysPassword";
alter user sys identified by "tiger"
                             *
ERROR at line 1:
ORA-01109: database not open 


SQL> alter user system identified by "&&systemPassword";
alter user system identified by "tiger"
                                *
ERROR at line 1:
ORA-01109: database not open 


SQL> alter system disable restricted session;

System altered.

SQL> @E:oraclexeapporacleproduct11.2.0serverconfigscriptspostScripts.sql
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected.
SQL> set echo on
SQL> spool E:oraclexeapporacleproduct11.2.0serverconfiglogpostScripts.log

CloneRmanRestore.log

SQL> startup nomount pfile="E:oraclexeapporacleproduct11.2.0serverconfigscriptsinit.ora";
ORACLE instance started.

Total System Global Area  535662592 bytes                                       
Fixed Size                  1384760 bytes                                       
Variable Size             226496200 bytes                                       
Database Buffers          301989888 bytes                                       
Redo Buffers                5791744 bytes                                       
SQL> @E:oraclexeapporacleproduct11.2.0serverconfigscriptsrmanRestoreDatafiles.sql;
SQL> set echo off;

TO_CHAR(SYSTIMEST                                                               
-----------------                                                               
20140530 06:00:59                                                               

Allocating device....                                                           
Specifying datafiles...                                                         
Specifing datafiles...                                                          
Restoring ...                                                                   
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible 
ORA-19870: error while restoring backup piece 
E:ORACLEXEAPPORACLEPRODUCT11.2.0SERVERCONFIGSEEDDBEXPRESS.DFB 
ORA-19504: failed to create file "E:ORACLEXEAPPORACLEORADATAXESYSTEM.DBF" 
ORA-27044: unable to write the header block of file 
OSD-04008: WriteFile() failure, unable to write to file 
O/S-Error: (OS 112) There is not enough space on the disk. 
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5827 
ORA-06512: at line 16 



TO_CHAR(SYSTIMEST                                                               
-----------------                                                               
20140530 06:01:02                                                               

Connected.
SQL> spool E:oraclexeapporacleproduct11.2.0serverconfiglogcloneDBCreation.log

postDBCreation.log

SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected.
SQL> set echo on
SQL> //create or replace directory DB_BACKUPS as 'E:oraclexeapporaclefast_recovery_area';
SP2-0103: Nothing in SQL buffer to run.
SQL> begin
  2     dbms_xdb.sethttpport('8080');
  3     dbms_xdb.setftpport('0');
  4  end;
  5  /
   dbms_xdb.sethttpport('8080');
   *
ERROR at line 2:
ORA-06550: line 2, column 4: 
PLS-00201: identifier 'DBMS_XDB.SETHTTPPORT' must be declared 
ORA-06550: line 2, column 4: 
PL/SQL: Statement ignored 
ORA-06550: line 3, column 4: 
PLS-00201: identifier 'DBMS_XDB.SETFTPPORT' must be declared 
ORA-06550: line 3, column 4: 
PL/SQL: Statement ignored 


SQL> create spfile='E:oraclexeapporacleproduct11.2.0serverdbs/spfileXE.ora' FROM pfile='E:oraclexeapporacleproduct11.2.0serverconfigscriptsinit.ora';

File created.

SQL> shutdown immediate;
ORA-01507: database not mounted 


ORACLE instance shut down.
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> startup ;
ORACLE instance started.

Total System Global Area  535662592 bytes                                       
Fixed Size                  1384760 bytes                                       
Variable Size             226496200 bytes                                       
Database Buffers          301989888 bytes                                       
Redo Buffers                5791744 bytes                                       
ORA-00205: error in identifying control file, check alert log for more info 


SQL> select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;

'UTL_RECOMP_BEGIN:'||TO_CH                                                      
--------------------------                                                      
utl_recomp_begin: 06:01:55                                                      

SQL> execute utl_recomp.recomp_serial();
BEGIN utl_recomp.recomp_serial(); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7: 
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared 
ORA-06550: line 1, column 7: 
PL/SQL: Statement ignored 


SQL> select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;

'UTL_RECOMP_END:'||TO_CH                                                        
------------------------                                                        
utl_recomp_end: 06:01:55                                                        

SQL> alter user hr password expire account lock;
alter user hr password expire account lock
*
ERROR at line 1:
ORA-01109: database not open 


SQL> alter user ctxsys password expire account lock;
alter user ctxsys password expire account lock
*
ERROR at line 1:
ORA-01109: database not open 


SQL> alter user outln password expire account lock;
alter user outln password expire account lock
*
ERROR at line 1:
ORA-01109: database not open 


SQL> alter user MDSYS password expire;
alter user MDSYS password expire
*
ERROR at line 1:
ORA-01109: database not open 


SQL> @E:oraclexeapporacleproduct11.2.0serverapexapxxepwd.sql "&1"
SQL> Rem  Copyright (c) Oracle Corporation 1999 - 2006. All Rights Reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      apxxepwd.sql
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      Changes the password for the INTERNAL ADMIN user
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      Assumes the SYS user is connected.
SQL> Rem
SQL> Rem    REQUIRENTS
SQL> Rem      - Oracle 10g
SQL> Rem
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YYYY)
SQL> Rem      jstraub   08/01/2006 - Created
SQL> Rem      jkallman  09/29/2006 - Adjusted current_schema to FLOWS_030000
SQL> Rem      jkallman  08/02/2007 - Change FLOWS_030000 references to FLOWS_030100
SQL> Rem      jkallman  07/08/2008 - Change FLOWS_030100 references to FLOWS_040000
SQL> Rem      jkallman  10/02/2008 - Change FLOWS_040000 references to APEX_040000
SQL> 
SQL> Rem
SQL> 
SQL> set define '&'
SQL> 
SQL> set verify off
SQL> 
SQL> alter session set current_schema = APEX_040000;
ERROR:
ORA-01435: user does not exist 


SQL> 
SQL> prompt ...changing password for ADMIN
...changing password for ADMIN
SQL> 
SQL> begin
  2  
  3      wwv_flow_security.g_security_group_id := 10;
  4      wwv_flow_security.g_user := 'ADMIN';
  5      wwv_flow_security.g_import_in_progress := true;
  6  
  7      for c1 in (select user_id
  8               from wwv_flow_fnd_user
  9              where security_group_id = wwv_flow_security.g_security_group_id
 10                and user_name = wwv_flow_security.g_user) loop
 11  
 12          wwv_flow_fnd_user_api.edit_fnd_user(
 13          p_user_id   => c1.user_id,
 14          p_user_name     => wwv_flow_security.g_user,
 15          p_web_password  => '&1',
 16          p_new_password  => '&1');
 17      end loop;
 18  
 19      wwv_flow_security.g_import_in_progress := false;
 20  
 21  end;
 22  /
    wwv_flow_security.g_security_group_id := 10;
    *
ERROR at line 3:
ORA-06550: line 3, column 5: 
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_SECURITY_GROUP_ID' must be declared 
ORA-06550: line 3, column 5: 
PL/SQL: Statement ignored 
ORA-06550: line 4, column 5: 
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_USER' must be declared 
ORA-06550: line 4, column 5: 
PL/SQL: Statement ignored 
ORA-06550: line 5, column 5: 
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared 
ORA-06550: line 5, column 5: 
PL/SQL: Statement ignored 
ORA-06550: line 8, column 23: 
PL/SQL: ORA-01219: database not open: queries allowed on fixed tables/views 
only 
ORA-06550: line 7, column 16: 
PL/SQL: SQL Statement ignored 
ORA-06550: line 13, column 32: 
PLS-00364: loop index variable 'C1' use is invalid 
ORA-06550: line 12, column 9: 
PL/SQL: Statement ignored 
ORA-06550: line 19, column 5: 
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared 
ORA-06550: line 19, column 5: 
PL/SQL: Statement ignored 


SQL> commit;

Commit complete.

SQL> spool off;

XE.bat.log

Instance created.

I have not pasted the contents of the postScripts.log as it was causing the body of this question to exceed the allowed limit of characters.

As suggested in some articles/posts on the internet, I tried connecting to Oracle as sysdba to view the control_file parameter. This is what I got:

SQL> connect / as sysdba
Connected.

SQL> show parameter control_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      E:ORACLEXEAPPORACLEORADATA
                                                 XECONTROL.DBF

I am sorry for posting all the information from the log files, but I thought it might be necessary.

Also, pls be aware of the following:

• I am logged in as a User which is a part of the Administrators group.
• I am using a dual boot system, so my Windows XP is installed on drive
  E:
• I have used the GUI installer only and did not meddle in the
  installation process

Can some Oracle expert please help ? What is wrong with the installation and how do I get it to work ? I have tried reinstalling it several times, but am stuck with the same issues.

Ошибка при установке Oracle:

[INS-30131] Не удалось выполнить первоначальную настройку, необходимую для выполнения проверки установщика.

Не удалось получить версию exectask из узла «win7lhr»

Решение:

Метод 1: Панель управления> Все элементы панели управления> Инструменты управления> Службы> Запуск СЕРВЕРА

Метод 2: F: database> setup.exe -ignorePrereq -ignorePrereq -J»-Doracle.install.db.validate.supportedOSCheck=false»

Решение:

Шаг 1. Панель управления> Все элементы панели управления> Инструменты управления> Службы> Запуск СЕРВЕРА

Шаг 2: Панель управления> Система и безопасность> Администрирование> Управление компьютером> Системные инструменты> Общая папка> Общий доступ, щелкните правой кнопкой мыши «Общий доступ»> Новый общий ресурс> Нажмите «Далее» > Нажмите «Обзор»> выберите «Локальный диск (C :)»> ОК

«Совместное имя» введите «C $»> «Далее» ОК!

Установить oracle11g [INS-30131] Не удалось выполнить первоначальную настройку, необходимую для выполнения проверки установщика.

Решение

Первый шаг:
Панель управления> Все элементы панели управления> Инструменты управления> Службы> Запуск СЕРВЕРА

Начало TCP / IP

Шаг 2:

1. Нажмите «Пуск» -> «Выполнить», введите regedit, а затем нажмите «Ввод», чтобы войти в редактор регистрации .
2. Найдите и щелкните HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet services LanmanServer Parameters .
3. Если AutoShareServer и AutoShareWks равны 0, измените значение на 1

Шаг 3:
Перезагрузите компьютер [Вы также можете перезапустить службу сервера, не перезагружая компьютер]

Шаг 4:

Войдите в каталог установки oracle, щелкните правой кнопкой мыши и выберите «Запуск от имени администратора».

Oracle 11.2.0.4 и 12c устанавливают решение для разрешения временного местоположения INS-30131

Я давно не устанавливал базу данных, а сегодня установил базу данных версии 11.2.0.

[INS-30131] «Ошибка». Убедитесь, что у текущего пользователя есть необходимые разрешения для доступа к временному хранилищу »

Описание этой ошибки в документе также очень четкое:

[INS-30131] Initial setup required for the execution of installer validations failed

Cause: Failed to access the temporary location

Action: Ensure that the current user has required permissions to access the temporary location.

Убедитесь, что у вас есть разрешение на доступ к временному каталогу установки. Но на самом деле в Windows многие люди предлагают увеличить долю C $ на диске.

Но это не влияет на мою среду, и я знаю, что с временным каталогом проблем нет. Затем введите каталог установочного программного обеспечения в командной строке, запустите программу установки через командную строку и установите проверку ignorePrereq. В это время программное обеспечение базы данных может начать установку. Будет ли ошибка, это зависит от того, является ли проигнорированная проверка критической. Для временной проблемы с пространством в этом случае, Правильная установка базы данных:

F:database>dir

Directory of F:database

2017-07-03 09:21 <DIR> install
2013-10-25 09:09 29,747 readme.html
2013-10-25 09:06 <DIR> response
2013-10-25 09:06 345,480 setup.exe
2017-07-03 12:57 <DIR> stage
2013-10-25 09:09 500 welcome.html
3 File(s) 377,291 bytes
3 Dir(s) 88,050,397,184 bytes free

F:database> setup.exe -ignorePrereq -ignorePrereq -J»-Doracle.install.db.validate.supportedOSCheck=false»

Это простой и грубый метод, но иногда он эффективен.

About Me

взят из «блога ITPUB», ссылка: http://blog.itpub.net/26736162/viewspace-2215926/, если вам нужно перепечатать, укажите источник, в противном случае будет преследоваться юридическая ответственность.

Problem

While installing Oracle Client 11.2.0.4 on windows, installation fails with the error below:

[INS-30131] Initial setup required for the execution of installer validations failed

Cause — Failed to access the temporary location.

Action — Ensure
that the current user has required permissions to access the temporary
location. 

Solution

Using the Task Manager, check if RemoteExecService.exe *32 is running from your temp location, for example C:Users<your_user_name>AppDataLocalTemporaremservice. If it does, then kill the process and delete the
oraremservice folder.

Rerun your installation.