This discussion is archived
1 Reply Latest reply: Mar 16, 2012 9:19 AM by mybro62 RSS

mw installation error

user12046143 Newbie
Currently Being Moderated
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))
)
)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points