Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2006
    Posts
    17

    Unanswered: Oracle XE ubuntu sqlplus help

    I am wondering if anyone can gelp as I am pulling my hair out at the moment.

    I recently installed oracle xe onto my ubuntu box using the .deb installer package from the oracle site, I have a 64 bit architecture and forced installed the i386 program.

    Everything has seemed to go fine, the oracle service is running on my machine and i encoutered no errors during installation. I dont have a gui on my ubuntu box so am attempting to connect to the database using sqlplus.

    however everytime i try to kick off sqlplus i get the following error:

    Code:
    snijjar@ubuntu:~$ sqlplus system
    
    SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 27 10:06:16 2007
    
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    Enter password: 
    oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
    ERROR:
    ORA-12547: TNS:lost contact

    I have the libraries installed (libaio) so am totally confused as to what is happening, under advice from another kind forum member i ran an strace and isolated the following output

    Code:
    open("/lib32/libnss_files.so.2", O_RDONLY) = 7
    read(7, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0000\33\0"..., 512) = 512
    fstat64(0x7, 0xffff39c0)                = 0
    mmap2(NULL, 40716, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 7, 0) = 0x56822000
    mmap2(0x5682b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 7, 0x8) = 0x5682b000
    close(7)                                = 0
    munmap(0x56807000, 36110)               = 0
    open("/etc/passwd", O_RDONLY)           = 7
    fcntl64(7, F_GETFD)                     = 0
    fcntl64(7, F_SETFD, FD_CLOEXEC)         = 0
    _llseek(7, 0, [0], SEEK_CUR)            = 0
    fstat64(0x7, 0xffff417c)                = 0
    mmap2(NULL, 1387, PROT_READ, MAP_SHARED, 7, 0x56b) = 0x565db000
    _llseek(7, 1387, [1387], SEEK_SET)      = 0
    munmap(0x565db000, 1387)                = 0
    close(7)                                = 0
    getrlimit(RLIMIT_NOFILE, {rlim_cur=4294967297*1024, rlim_max=579584294485971012}) = 0
    brk(0x80d5000)                          = 0x80d5000
    socket(PF_INET, 0 /* SOCK_??? */, 6230100443694385024) = 7
    setsockopt(4294967303, 0x2 /* SOL_?? */, 4, ptrace: umoven: Input/output error
    0x5675c35855684780, 577955057325047818) = 0
    bind(579721130697293831, ptrace: umoven: Input/output error
    {...}, 6230100443694385024) = 0
    getsockname(-185095910588409, ptrace: umoven: Input/output error
    {...}, ptrace: umoven: Input/output error
    0x5675c35855684780) = 0
    getpeername(-185095910588409, 0x556b9c90ffff57cc, ptrace: umoven: Input/output error
    0x5675c35855684780) = -1 ENOTCONN (Transport endpoint is not connected)
    getsockopt(4294967303, 0x7 /* SOL_??? */, 582141654006192240ptrace: umoven: Input/output error
    , 0x5556e090ffff58b0, 0x64ce9bb00000000) = 0
    getsockopt(4294967303, 0x8 /* SOL_??? */, 582141654006192240ptrace: umoven: Input/output error
    , 0x5556e090ffff58b0, 0x64ce9bb00000000) = 0
    fcntl64(7, F_SETFD, FD_CLOEXEC)         = 0
    fcntl64(7, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
    gettimeofday({2222517896526333, 1446727748}, NULL) = 0
    rt_sigaction(SIGCHLD, NULL, {SIG_DFL}, 8) = 0
    rt_sigprocmask(SIG_BLOCK, [CHLD], NULL, 8) = 0
    rt_sigaction(SIGCHLD, {0x10000004560e7f08, ~[], SA_RESTORER|SA_STACK|SA_RESTART|SA_INTERRUPT|SA_NOMASK|SA_ONESHOT|0x3ff4250, 0xfffffffffffffffe}, {SIG_DFL}, 8) = 0
    rt_sigprocmask(SIG_UNBLOCK, [CHLD], NULL, 8) = 0
    pipe([8, 9])                            = 0
    pipe([10, 11])                          = 0
    clone(oracleXE: error while loading shared libraries: libaio.so.1: cannot open s
    from what I can gather there is some sort of input output error but i dont really understand what, i have scowered the internet and still cant find what could be the problem. Can anyone help?

  2. #2
    Join Date
    Jan 2006
    Posts
    17
    Ive managed to get a little further, I had the 64-bit version of libaio installed so downloaded the 32-bit version installed it and restarted oracle. The previous error message has gone now bu i know get

    Code:
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    Enter user-name: SYSTEM
    Enter password: 
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    anyone know what thats about?

  3. #3
    Join Date
    Jan 2006
    Posts
    17
    Ive managed to get a little further, I had the 64-bit version of libaio installed so downloaded the 32-bit version installed it and restarted oracle. The previous error message has gone now bu i know get

    Code:
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    
    Enter user-name: SYSTEM
    Enter password: 
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    anyone know what thats about?

  4. #4
    Join Date
    Jan 2006
    Posts
    17
    right i figured....
    I installed and configured the database using the sudo command, oracle requires root to do all installation, so i removed it created a root user and everything went smoothly......


    after staying up all night..im going to bed!!

  5. #5
    Join Date
    Mar 2010
    Posts
    2
    Problem ruuning sqlplus in ubuntu 64 bit I have a different problem running sqlplus. I recently installed oracle xe onto my ubuntu box 64 bit too. Everything seemed okay except

    df@ubuntu:~$
    df@ubuntu:~$ sqlplus hr/hr

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 2 17:59:37 2010

    Copyright (c) 1982, 2005, Oracle. All rights reserved.


    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

    SQL> desc employees
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    EMPLOYEE_ID NOT NULL NUMBER(6)
    FIRST_NAME VARCHAR2(20)
    LAST_NAME NOT NULL VARCHAR2(25)
    EMAIL NOT NULL VARCHAR2(25)
    PHONE_NUMBER VARCHAR2(20)
    HIRE_DATE NOT NULL DATE
    JOB_ID NOT NULL VARCHAR2(10)
    SALARY NUMBER(8,2)
    COMMISSION_PCT NUMBER(2,2)
    MANAGER_ID NUMBER(6)
    DEPARTMENT_ID NUMBER(4)

    SQL> select * from employees
    2

    under SQL>, I could use "desc employees" to show the structure of employees table in hr database. But when I tried a select command "select * from employees" I got nothing but an error code "2".

    Could anybody tell me what was wrong or did I miss something? Any help is appreciated, Thanks.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >But when I tried a select command "select * from employees" I got nothing but an error code "2".
    No, you misunderstand what you did & what you see/saw.

    in sqlplus a SQL statement is terminated with a semicolon.

    SQL> select * from employees;

    The number 2 indicates you hit "Enter" so sqlplus displayed "2" to show you it was ready for the second (line #2) line of input.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2010
    Posts
    2
    Thanks a lot.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •