This discussion is archived
7 Replies Latest reply: Aug 8, 2013 5:59 PM by FSBComputers RSS

Oracle 11g R2 Express on Linux x64 - User/Password question

FSBComputers Newbie
Currently Being Moderated

Hey guys,

 

I just installed Oracle 11g R2 Express on a Linux x64 box using the RPM (no installation wizard) from the oracle website, I'm trying to connect, but I can't find anywhere what is the first time username and password I should use to login to it.

 

Does anybody know where I can find this, or if somebody can tell me what they are?

 

Thanks.

  • 1. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    Please try logins:

    Username: system

    Password: manager

     

    otherwise simple connect as sysdba as:

    sqlplus / as sysdba

     

    Once connected you may change as other users login.

     

    Hope this helps!

    Best Regards,

  • 2. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    FSBComputers Newbie
    Currently Being Moderated

    I tried connect system/manager@localhost from SQL *Plus but it said TNS: no listener

     

    I checked the oracle-xe daemon and it's running, I have no firewall or selinux enabled on that box, so it's not blockage.

     

    Any ideas what can be causing that?

     

    Thanks

  • 3. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    FSBComputers Newbie
    Currently Being Moderated

    I also tried from SQL *Plus connect as sysdba using system/manager and it said insufficient privileges

  • 4. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    SQL *Plus but it said TNS: no listener

     

    Go to Services, and ensure you start the listener service ( It must be something like OracleListenerXE -please check as I cant exactly remember the wording)

    and in the command prompt also issue command:

    lsnrctl start

     

    After that please try to connect as:

    sqlplus / as sysdba

     

    Hope this answers.

    Best Regards,

  • 5. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    EdStevens Guru
    Currently Being Moderated

    FSBComputers wrote:

     

    I also tried from SQL *Plus connect as sysdba using system/manager and it said insufficient privileges

    What os user were you when you did that?  Is that user a member of the 'dba' group?

    Show us the results of:

     

    id

    env | egrep 'ORA|PATH' | sort

    sqlplus / as sysdba

  • 6. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    FSBComputers Newbie
    Currently Being Moderated

    I was doing that as root, but I just tried something else and got a different error.

     

    I uninstalled it, deleted the /u01 folder, re installed it, ran /etc/init.d/oracle-xe configure as root and when configuring the database it fails, so I'm stuck on this one now.

     

    Oh and by the way it fails, when I run connect as sysdba in SQL *Plus it now says connected to an idle instance, but I cannot connect using SQL Developer.

     

    Any ideas?

  • 7. Re: Oracle 11g R2 Express on Linux x64 - User/Password question
    FSBComputers Newbie
    Currently Being Moderated

    I tried it on Oracle Enterprise Linux 6.4 too and got the same error as CentOS 6.4

     

    When running /etc/init.d/oracle-xe configure as root it fails,

     

    This is what the log files say:

     

    postDBCreation.log

    ==============

    begin

    *

    ERROR at 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 does not exist

    Linux-x86_64 Error: 2: No such file or directory

    ORA-00119: invalid specification for system parameter LOCAL_LISTENER

    ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oracle64.fsbc$

    select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    BEGIN utl_recomp.recomp_serial(); END;

     

    *

    ERROR at 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 AS '/u01/app/oracle/product/11.2.0/xe/lib/libqsmashr.so';

    *

    ERROR at 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 at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    commit

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    create or replace directory XMLDIR as '/u01/app/oracle/product/11.2.0/xe/rdbms/xml'

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    DROP DIRECTORY ORACLE_OCM_CONFIG_DIR

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    DROP DIRECTORY ADMIN_DIR

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    DROP DIRECTORY WORK_DIR

    *

    ERROR at 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 at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

     

    commit

    *

    ERROR at line 1:

    ORA-01034: ORACLE not available

    Process ID: 0

    Session ID: 0 Serial number: 0

     

    Any ideas?

     

    Thanks

Legend

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