ubuntu - Problems installing Oracle Database Express Edition 11g -
i'm trying install oracle database in (x)ubuntu 13.04 64-bit using this guide. goed until following step:
$ sudo /etc/init.d/oracle-xe configure oracle database 11g express edition configuration ------------------------------------------------- configure on-boot properties of oracle database 11g express edition. following questions determine whether database should starting upon system boot, ports use, , passwords used database accounts. press <enter> accept defaults. ctrl-c abort. specify http port used oracle application express [8080]: specify port used database listener [1521]: specify password used database accounts. note same password used sys , system. oracle recommends use of different passwords each database account. can done after initial configuration: confirm password: want oracle database 11g express edition started on boot (y/n) [y]: starting oracle net listener...done configuring database... database configuration failed. /u01/app/oracle/product/11.2.0/xe/config/log details the log files show following output:
:/u01/app/oracle/product/11.2.0/xe/config/log$ l in *.log > > echo $l > cat $l > done clonedbcreation.log create controlfile reuse set database "xe" * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 begin dbms_backup_restore.zerodbid(0); end; * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 ora-01034: oracle not available ora-27101: shared memory realm not exist linux-x86_64 error: 2: no such file or directory ora-00845: memory_target not supported on system create controlfile reuse set database "xe" * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter system enable restricted session * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter database "xe" open resetlogs * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter database rename global_name "xe" * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter system switch logfile * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter system checkpoint * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter database drop logfile group 3 * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter tablespace temp add tempfile '/u01/app/oracle/oradata/xe/temp.dbf' size 20480k reuse autoextend on next 640k maxsize unlimited * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 select tablespace_name dba_tablespaces tablespace_name='users' * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 select sid, program, serial#, username v$session * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter user sys identified "oracle" * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter user system identified "oracle" * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 alter system disable restricted session * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 clonermanrestore.log ora-00845: memory_target not supported on system select to_char(systimestamp,'yyyymmdd hh:mi:ss') dual * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 declare * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 select to_char(systimestamp,'yyyymmdd hh:mi:ss') dual * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 postdbcreation.log begin * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 file created. ora-01034: oracle not available ora-27101: shared memory realm not exist linux-x86_64 error: 2: no such file or directory ora-00845: memory_target not supported on system select 'utl_recomp_begin: ' || to_char(sysdate, 'hh:mi:ss') dual * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 begin utl_recomp.recomp_serial(); end; * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 select 'utl_recomp_end: ' || to_char(sysdate, 'hh:mi:ss') dual * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 postscripts.log create or replace library dbms_sumadv_lib '/u01/app/oracle/product/11.2.0/xe/lib/libqsmashr.so'; * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 begin dbms_datapump_utl.replace_default_dir; end; * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 commit * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 create or replace directory xmldir '/u01/app/oracle/product/11.2.0/xe/rdbms/xml' * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 drop directory oracle_ocm_config_dir * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 drop directory admin_dir * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 drop directory work_dir * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 begin dbms_swrf_internal.cleanup_database(cleanup_local => false); end; * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 commit * error @ line 1: ora-01034: oracle not available process id: 0 session id: 0 serial number: 0 what doing wrong?
i in same boat, trying configure xe on virtual machine (opensuse 13.01 64bit).
the solution in case missing hostname in /etc/hosts. can examine errors in /u01/app/oracle/product/11.2.0/xe/config/log/clonermanrestore.log @ beginning (the path depends on xe version).
search info similar to: ora-00119: invalid specification system parameter local_listener ora-00130: invalid listener address '(address=(protocol=tcp)(host=linux-cn65.site)(port=1521))
so linux-cn65.site (the vm host) missing. add host in /etc/hosts (as root):
127.0.0.1 linux-cn65.site <-- host here
and run configuration again (as root): sh /etc/init.d/oracle-xe configure
additional trickery
if not have error files in log folder, may re-install xe without h flag, this:
- to find package:
sudo rpm -qa | grep -i oracle - to remove it:
sudo rpm -e oracle-xe-11.2.0-1.0.x86_64<-- package here
- to find package:
install again without h flag:
sudo rpm -iv oracle-xe-11.2.0-1.0.x86_64.rpm
oh, replace version (oracle-xe-11.2.0-1.0.x86_64.rpm) yours. cheers ;)
Comments
Post a Comment