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

  • 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

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

since using iframes house external pages are, accounts "not preferred method" , disallowed sites (flickr, one), want dynamically generate browser tabs. e.g., when user submits form, want dynamically generate tab on browser in response submitted. e.g., might want add new tab url like: http://www.bigsurgarrapata.com/contact how in jquery? you want form target attribute action attribute. http://www.w3schools.com/tags/att_form_target.asp browsers have ultimate control on result of target attribute open new tab value of _blank. <form action="contact_submit.php" target="_blank" method="post">
Read more

keyboard - C++ GetAsyncKeyState alternative -

i using windows.h library's getasynckeystate function define key pushed on keyboard . here program returns int value of pushed key example. #include <iostream> #include <windows.h> using namespace std; int main (){ char i; for(i=8;i<190;i++){ if(getasynckeystate(i)== -32767){ cout<<int (i)<<endl; } } return 0; } but trying make opengl simple game , function appeared slow . there function not need cycle 180 times , if statement . thanks you're trying make opengl game, you're going use glfw. if that's case can away using glfwgetkey() such: if (glfwgetkey(glfw_key_up) == glfw_press) {...} if (glfwgetkey(glfw_key_down) == glfw_press) {...} that method nicely explained in tutorial 6 opengl-tutorial.org . should start first tutorial of beginners tutorials , later intermediate tutorials . if you're going make win32 window can listen wm_keydown or wm_keyup messages , virtua...
Read more

android - java.net.UnknownHostException(Unable to resolve host “URL”: No address associated with hostname) -

i developing app testing asp.net webservice in android.for simple webservice adding 2 numbers used.where numbers passed parameters.the result in dialogue.the webserver works in local. when application runs following result exception.i provided internet permission in manifest. java.net.unknownhostexception(unable resolve host “ http://url.com/ ”: no address associated hostname) my code given below main activity public static string rslt=""; /** called when activity first created. */ @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); button b1=(button)findviewbyid(r.id.button1); final alertdialog ad=new alertdialog.builder(this).create(); b1.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { // todo auto-generated method stub try { ...
Read more