1 Reply Latest reply: Mar 16, 2012 11:19 AM by David Heisler-Oracle RSS

    mw installation error

    user12046143
      setup.sh started:Thu Mar 15 21:33:27 EET 2012
      BACKUP_DIR Already exists Removing it...Done.

      BACKUP_DIR does not exist creating it now...Done.

      prepare_vals
      -------------------------
      Setting up environment...
      TNS_ADMIN is now set to /home/oracle/oracle/product/10.2.0/db_1/network/admin
      Done.

      Values:

      TNS_ADMIN= /home/oracle/oracle/product/10.2.0/db_1/network/admin
      TWO_TASK= metu
      PLATFORM= Linux
      EOF_HOME= /home/oracle/oracle/product/10.2.0/db_1/eof
      EOF_PATCH_TOP= /home/oracle/oracle/product/10.2.0/db_1/eof/patches
      LOGNAME= oracle
      SHORT_HOST= localhost
      DOMAIN= localhost

      assumptions
      -------------------------


      Requirements:

      Before running this setup script, you must have done the following:

      1. Installed an Oracle RDBMS 10g and set the ORACLE_HOME
      environment variable to that directory.
      2. You have set TWO_TASK or ORACLE_SID to a valid running 10g database.
      3. You have created a tablespace called NEWEOF for the Maintenance Wizard tables.
      4. The unix account oracle owns the 10g ORACLE_HOME .

      If these requirements are not met, then the setup will not complete successfully.

      Have these requirements been met?(Y/N)
      validate_install_env
      -------------------------

      Checking for minimum requirements...
      Ensuring execute bit is on shell files...Done.
      ORACLE_HOME set to '/home/oracle/oracle/product/10.2.0/db_1'
      Checking for existence of ORACLE_HOME...found
      Checking for import utility (imp)...found
      Checking for sqlplus executable...found
      Checking for tnsping executable...found
      Checking for sed executable...found with proper execute permissions
      Checking for egrep executable...found with proper execute permissions
      Checking for zip executable...found with proper execute permissions
      Checking for ftp executable...found with proper execute permissions
      All Passed

      check_tnsnames
      -------------------------
      Checking for valid TWO_TASK in tnsnames.ora file...Done.

      check_lsnname
      -------------------------
      LSN_NAME : "LISTENER_METU"
      LSN_EXPECTED_NAME : "LISTENER_metu"
      LISTENER NAME: listener_metu adheres to the standard naming convention

      get_eof_config
      -------------------------

      validation
      -------------------------

      ***********************************************************************
      Maintenance Wizard configuration Information

      Domain = localhost
      Oracle Home = /home/oracle/oracle/product/10.2.0/db_1
      Connect String = metu
      System password = <not displayed>
      Database Schema = MW
      Maintenance Wizard Patch Stage = /home/oracle/oracle/product/10.2.0/db_1/eof/patches
      Email for Anonymous FTP = rabiak@metu.edu.tr
      Protocol = http
      HTTP port = 8080
      HTTP Proxy hostname = no proxy used
      HTTP Proxy port number = no proxy used
      My Oracle Support Username = rabiak@metu.edu.tr
      My Oracle Support Password = <not displayed>
      Maintenance Wizard Password = <not displayed>
      ***********************************************************************
      Are the above values correct? (Y/N)
      check_sqlplus
      -------------------------
      Checking for valid SQLPlus connection as SYSTEM...Done.

      copy_tnsnames
      -------------------------
      Copying tnsnames.ora to /home/oracle/oracle/product/10.2.0/db_1/eof/config...Done.

      cr_schema
      -------------------------
      Removing old Maintenance Wizard schema (MW)...Done.
      Creating new Maintenance Wizard schema (MW)...

      Installation error:
      Error Creating new database schema (MW)

      You should check the file
      /home/oracle/oracle/product/10.2.0/db_1/eof/config/install13179.log

      for errors.

      Log file : cr_schema13179.log
      -------------------------------------

      User created.


      Grant succeeded.

      grant all on DBMS_CRYPTO to MW
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available


      grant all on DBMS_PIPE to MW
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available


      grant xdbadmin to MW
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available


      alter user MW default role dba,xdbadmin,connect
      *
      ERROR at line 1:
      ORA-01034: ORACLE not available


      Importing Maintenance Wizard Tool schema (MW)...Done.
      Compiling Maintenance Wizard schema objects (MW)...Done.

      check_anonymous_account
      -------------------------
      ANONYMOUS has status OPEN . No action needed

      config_eof_node
      -------------------------
      Creating configuration files...Done.

      config_anonymous_ftp
      -------------------------
      Setting up /home/oracle/oracle/product/10.2.0/db_1/eof/config/.netrc...Done.

      ------- config_EPG ------
      -------------------------

      save_xdb_config
      -------------------------
      Saving current xdbconfig.xml to /home/oracle/oracle/product/10.2.0/db_1/eof/config/backup...Done.

      create_epg_dad
      -------------------------
      Creating Embedded PL/SQL gateway DAD...Done.

      set_xdb_http
      -------------------------
      MW_HTTP_PORT : 8080
      Setting up HTTP port...Done.

      config_xdb
      -------------------------
      Setting up element allow-repository-anonymous-access...Done.
      Setting up element session-timeout for HTTP/S protocol...Done.
      Setting up element session-timeout for FTP protocol...Done.

      create_xdb_dirs
      -------------------------
      Creating XML DB Dir /images...Done.
      Creating XML DB Dir /EOF...Done.

      replace_xdb_homepage
      -------------------------
      Replacing XDB Homepage...Done.

      ------- config_DB -------
      -------------------------

      config_DB_parameters
      -------------------------

      LSN_PROTOCOL is set to : TCP
      ORACLE_HOME is set to : /home/oracle/oracle/product/10.2.0/db_1
      ORACLE_SID is set to : metu
      Saving Original spfile : select value from v$parameter where name='spfile' backup compile_bodies.sql compile_procs.sql compile_triggers.sql compile_views.sql config_xdb13179.log create_epg_dad13179.log create_xdb_dirs13179.log dr_schema13179.log dumpfiles EOF.conf eofconfig.env epg_conversion imp_schema13179.log install13065.log install13179.log load_mw_java.sh PRODUCT_10.env PRODUCT_150.env PRODUCT_160.env PRODUCT_170.env PRODUCT_180.env PRODUCT_50.env PRODUCT_60.env PRODUCT_80.env replace_xdb_homepage13179.log setup.sh sqlnet.ora templates tnsnames.ora uninstall.sh ERROR at line 1: ORA-01034: ORACLE not available to
      /home/oracle/oracle/product/10.2.0/db_1/eof/config/backup

      File /home/oracle/oracle/product/10.2.0/db_1/eof/config/backup/spfilemetu.ora does not exist.


      Installation error:
      Error Unable to successfully backup select value from v$parameter where name='spfile' backup compile_bodies.sql compile_procs.sql compile_triggers.sql compile_views.sql config_xdb13179.log create_epg_dad13179.log create_xdb_dirs13179.log dr_schema13179.log dumpfiles EOF.conf eofconfig.env epg_conversion imp_schema13179.log install13065.log install13179.log load_mw_java.sh PRODUCT_10.env PRODUCT_150.env PRODUCT_160.env PRODUCT_170.env PRODUCT_180.env PRODUCT_50.env PRODUCT_60.env PRODUCT_80.env replace_xdb_homepage13179.log setup.sh sqlnet.ora templates tnsnames.ora uninstall.sh ERROR at line 1: ORA-01034: ORACLE not available file

      You should check the file
      /home/oracle/oracle/product/10.2.0/db_1/eof/config/install13179.log

      for errors.

      # tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1//network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      METU =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.102)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = metu)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )





      # listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1//network/admin/listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_METU =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = metu)
      (GLOBAL_DBNAME = metu)
      (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1/)
      (PROGRAM = extproc)
      )
      )

      LISTENER_METU =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
      )
      )