This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Mar 3, 2013 11:11 PM by user8167598 RSS

11g XE on Linux 64

user8167598 Newbie
Currently Being Moderated
Hello,

I am trying to install 11g (11.2.0) express edition onto openSuse Linux 12.2.

When I try to run the, '/etc/inti.d/oracle-xe', with the configure option, it prompts for port numbers and passwords, and then fails and suggest I review the log files, under, 'u01/app/oracle/product/11.2.0/xe/config/log'.

-rw-r--r-- 1 oracle dba 589 Mar 2 15:34 CloneRmanRestore.log
-rw-r--r-- 1 oracle dba 2517 Mar 2 15:34 cloneDBCreation.log
-rw-r--r-- 1 oracle dba 1317 Mar 2 15:34 postScripts.log
-rw-r--r-- 1 oracle dba 891 Mar 2 15:34 postDBCreation.log

They all indicate, ORA-01034 ORACLE not available. Running the command, '/u01/app/oracle/product/11.2.0/xe/config/scripts/startdb.sh' does not show any errror messages, nor doe s it start any oracle processes either.

Can someone please guide me on this ?

Thanks

Russell
  • 1. Re: 11g XE on Linux 64
    sb92075 Guru
    Currently Being Moderated
    user8167598 wrote:
    Hello,

    I am trying to install 11g (11.2.0) express edition onto openSuse Linux 12.2.

    When I try to run the, '/etc/inti.d/oracle-xe', with the configure option, it prompts for port numbers and passwords, and then fails and suggest I review the log files, under, 'u01/app/oracle/product/11.2.0/xe/config/log'.

    -rw-r--r-- 1 oracle dba 589 Mar 2 15:34 CloneRmanRestore.log
    -rw-r--r-- 1 oracle dba 2517 Mar 2 15:34 cloneDBCreation.log
    -rw-r--r-- 1 oracle dba 1317 Mar 2 15:34 postScripts.log
    -rw-r--r-- 1 oracle dba 891 Mar 2 15:34 postDBCreation.log

    They all indicate, ORA-01034 ORACLE not available. Running the command, '/u01/app/oracle/product/11.2.0/xe/config/scripts/startdb.sh' does not show any errror messages, nor doe s it start any oracle processes either.

    Can someone please guide me on this ?

    Thanks

    Russell
    be logged onto the OS as OS user oracle, then type line for line as below from inside a Terminal window

    sqlplus
    / as sysdba
    startup

    COPY the results from above, then PASTE all back here
  • 2. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    linux-hthu:~ # su - oracle
    oracle@linux-hthu:~> sqlplus
    If 'sqlplus' is not a typo you can use command-not-found to lookup the package that contains it, like this:
    cnf sqlplus
    oracle@linux-hthu:~> env | grep ORACLE
  • 3. Re: 11g XE on Linux 64
    yoonas Expert
    Currently Being Moderated
    Hi,


    Set environment variables properly(ORACLE_HOME, ORACLE_SID, PATH)

    see how to set it with oraenv (http://www.orafaq.com/wiki/Oraenv)

    . oraenv


    or

    set it manually

    export ORACLE_SID=XE
    export ORACLE_HOME=/u02/app/oracle/product/11.2.0/db_home1
    export PATH=$PATH:/u02/app/oracle/product/11.2.0/db_home1/bin
    
    Note : Set SID,Home,Path for your installation
    Do echo and make sure variables are set propertly
    [oracle@vmtest bin]$ echo $ORACLE_SID
    XE
    [oracle@vmtest bin]$ echo $ORACLE_HOME
    /u02/app/oracle/product/11.2.0/db_home1
    
    [oracle@vmtest bin]$echo $PATH
    /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/u02/app/oracle/product/11.2.0/db_home1/bin
    Now run sqlplus and startup the database

    Regards
    Yoonas
  • 4. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    oracle@linux-hthu:~> echo $ORACLE_SID
    XE
    oracle@linux-hthu:~> echo $ORACLE_HOME
    /u01/app/oracle/product/11.2.0/xe
    oracle@linux-hthu:~> echo $PATH
    /usr/lib64/mpi/gcc/openmpi/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/u01/app/oracle/product/11.2.0/xe/bin
    oracle@linux-hthu:~> sqlplus

    SQL*Plus: Release 11.2.0.2.0 Production on Sun Mar 3 03:23:23 2013

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

    Enter user-name: / as sysdba
    Connected to an idle instance.

    SQL> startup
    ORA-00119: invalid specification for system parameter LOCAL_LISTENER
    ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=linux-hthu)(PORT=1521))'
    SQL>

    The Suse host is running without a firewall, but is running under VM-fusion._

    changing the ORACLE_SID variable to lower case 'xe', I got the following:

    oracle@linux-hthu:~> excho $ORACLE_SID
    If 'excho' is not a typo you can use command-not-found to lookup the package that contains it, like this:
    cnf excho
    oracle@linux-hthu:~> echo $ORACLE_SID
    xe
    oracle@linux-hthu:~> sqlplus

    SQL*Plus: Release 11.2.0.2.0 Production on Sun Mar 3 03:37:28 2013

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

    Enter user-name: / as sysdba
    Connected to an idle instance.

    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initxe.ora'

    Directory structure (from xe / XE perspective)
    /u01/app/oracle/fast_recovery_area/XE
    /u01/app/oracle/oradata/XE
    /u01/app/oracle/diag/rdbms/xe
    /u01/app/oracle/diag/rdbms/xe/XE
    /u01/app/oracle/diag/rdbms/xe/XE/incident
    /u01/app/oracle/diag/rdbms/xe/XE/cdump
    /u01/app/oracle/diag/rdbms/xe/XE/lck
    /u01/app/oracle/diag/rdbms/xe/XE/hm
    /u01/app/oracle/diag/rdbms/xe/XE/stage
    /u01/app/oracle/diag/rdbms/xe/XE/ir
    /u01/app/oracle/diag/rdbms/xe/XE/incpkg
    /u01/app/oracle/diag/rdbms/xe/XE/metadata_pv
    /u01/app/oracle/diag/rdbms/xe/XE/sweep
    /u01/app/oracle/diag/rdbms/xe/XE/trace
    /u01/app/oracle/diag/rdbms/xe/XE/metadata
    /u01/app/oracle/diag/rdbms/xe/XE/metadata_dgif
    /u01/app/oracle/diag/rdbms/xe/XE/alert
    /u01/app/oracle/product/11.2.0/xe
    /u01/app/oracle/product/11.2.0/xe/sqlplus
    /u01/app/oracle/product/11.2.0/xe/sqlplus/mesg
    /u01/app/oracle/product/11.2.0/xe/sqlplus/admin
    /u01/app/oracle/product/11.2.0/xe/sqlplus/admin/help
    /u01/app/oracle/product/11.2.0/xe/dbs
    /u01/app/oracle/product/11.2.0/xe/demo
    /u01/app/oracle/product/11.2.0/xe/demo/schema
    /u01/app/oracle/product/11.2.0/xe/demo/schema/human_resources
    /u01/app/oracle/product/11.2.0/xe/jlib
    /u01/app/oracle/product/11.2.0/xe/ldap
    /u01/app/oracle/product/11.2.0/xe/ldap/mesg
    /u01/app/oracle/product/11.2.0/xe/ctx
    /u01/app/oracle/product/11.2.0/xe/ctx/mesg
    /u01/app/oracle/product/11.2.0/xe/ctx/data
    /u01/app/oracle/product/11.2.0/xe/ctx/data/jalx
    /u01/app/oracle/product/11.2.0/xe/ctx/data/enlx
    /u01/app/oracle/product/11.2.0/xe/ctx/data/template
    /u01/app/oracle/product/11.2.0/xe/ctx/migrate
    /u01/app/oracle/product/11.2.0/xe/ctx/config
    /u01/app/oracle/product/11.2.0/xe/ctx/bin
    /u01/app/oracle/product/11.2.0/xe/ctx/admin
    /u01/app/oracle/product/11.2.0/xe/ctx/admin/defaults
    /u01/app/oracle/product/11.2.0/xe/ctx/lib
    /u01/app/oracle/product/11.2.0/xe/oracore
    /u01/app/oracle/product/11.2.0/xe/oracore/mesg
    /u01/app/oracle/product/11.2.0/xe/oracore/zoneinfo
    /u01/app/oracle/product/11.2.0/xe/plsql
    /u01/app/oracle/product/11.2.0/xe/plsql/mesg
    /u01/app/oracle/product/11.2.0/xe/plsql/include
    /u01/app/oracle/product/11.2.0/xe/opmn
    /u01/app/oracle/product/11.2.0/xe/opmn/bin
    /u01/app/oracle/product/11.2.0/xe/opmn/lib
    /u01/app/oracle/product/11.2.0/xe/network
    /u01/app/oracle/product/11.2.0/xe/network/log
    /u01/app/oracle/product/11.2.0/xe/network/mesg
    /u01/app/oracle/product/11.2.0/xe/network/install
    /u01/app/oracle/product/11.2.0/xe/network/install/sqlnet
    /u01/app/oracle/product/11.2.0/xe/network/admin
    /u01/app/oracle/product/11.2.0/xe/network/admin/samples
    /u01/app/oracle/product/11.2.0/xe/network/lib
    /u01/app/oracle/product/11.2.0/xe/network/trace
    /u01/app/oracle/product/11.2.0/xe/xdk
    /u01/app/oracle/product/11.2.0/xe/xdk/doc
    /u01/app/oracle/product/11.2.0/xe/xdk/doc/cpp
    /u01/app/oracle/product/11.2.0/xe/xdk/doc/cpp/classgen
    /u01/app/oracle/product/11.2.0/xe/xdk/mesg
    /u01/app/oracle/product/11.2.0/xe/xdk/include
    /u01/app/oracle/product/11.2.0/xe/xdk/admin
    /u01/app/oracle/product/11.2.0/xe/hs
    /u01/app/oracle/product/11.2.0/xe/hs/admin
    /u01/app/oracle/product/11.2.0/xe/hs/lib
    /u01/app/oracle/product/11.2.0/xe/config
    /u01/app/oracle/product/11.2.0/xe/config/log
    /u01/app/oracle/product/11.2.0/xe/config/scripts
    /u01/app/oracle/product/11.2.0/xe/config/seeddb
    /u01/app/oracle/product/11.2.0/xe/bin
    /u01/app/oracle/product/11.2.0/xe/md
    /u01/app/oracle/product/11.2.0/xe/md/admin
    /u01/app/oracle/product/11.2.0/xe/apex
    /u01/app/oracle/product/11.2.0/xe/slax
    /u01/app/oracle/product/11.2.0/xe/slax/mesg
    /u01/app/oracle/product/11.2.0/xe/lib
    /u01/app/oracle/product/11.2.0/xe/precomp
    /u01/app/oracle/product/11.2.0/xe/precomp/admin
    /u01/app/oracle/product/11.2.0/xe/precomp/lib
    /u01/app/oracle/product/11.2.0/xe/jdbc
    /u01/app/oracle/product/11.2.0/xe/jdbc/lib
    /u01/app/oracle/product/11.2.0/xe/nls
    /u01/app/oracle/product/11.2.0/xe/nls/demo
    /u01/app/oracle/product/11.2.0/xe/nls/mesg
    /u01/app/oracle/product/11.2.0/xe/nls/data
    /u01/app/oracle/product/11.2.0/xe/rdbms
    /u01/app/oracle/product/11.2.0/xe/rdbms/demo
    /u01/app/oracle/product/11.2.0/xe/rdbms/jlib
    /u01/app/oracle/product/11.2.0/xe/rdbms/log
    /u01/app/oracle/product/11.2.0/xe/rdbms/mesg
    /u01/app/oracle/product/11.2.0/xe/rdbms/install
    /u01/app/oracle/product/11.2.0/xe/rdbms/install/rdbms
    /u01/app/oracle/product/11.2.0/xe/rdbms/xml
    /u01/app/oracle/product/11.2.0/xe/rdbms/xml/schema
    /u01/app/oracle/product/11.2.0/xe/rdbms/admin
    /u01/app/oracle/product/11.2.0/xe/rdbms/lib
    /u01/app/oracle/product/11.2.0/xe/rdbms/audit
    /u01/app/oracle/product/11.2.0/xe/rdbms/public
    /u01/app/oracle/product/11.2.0/xe/odbc
    /u01/app/oracle/product/11.2.0/xe/odbc/demo
    /u01/app/oracle/product/11.2.0/xe/odbc/demo/cdemo
    /u01/app/oracle/product/11.2.0/xe/odbc/mesg
    /u01/app/oracle/product/11.2.0/xe/odbc/html
    /u01/app/oracle/product/11.2.0/xe/odbc/lib
    /u01/app/oracle/product/11.2.0/xe/odbc/utl
    /u01/app/oracle/admin/cfgtoollogs/dbca/XE
    /u01/app/oracle/admin/XE
    /u01/app/oracle/admin/XE/dbs
    /u01/app/oracle/admin/XE/adump
    /u01/app/oracle/admin/XE/pfile
    /u01/app/oracle/admin/XE/dpdump

    Edited by: user8167598 on Mar 3, 2013 12:38 AM
  • 5. Re: 11g XE on Linux 64
    yoonas Expert
    Currently Being Moderated
    Keep it as it is

    Check if /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora has any parameter with LOCAL_LISTENER
    post the initXE

    If you have listener file (/u01/app/oracle/product/11.2.0/xe/network/admin) post that also

    Did you make any changes to the system like changin (hostname,ip)
  • 6. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    racle@linux-hthu:~/product/11.2.0/xe/dbs> pwd
    /u01/app/oracle/product/11.2.0/xe/dbs
    oracle@linux-hthu:~/product/11.2.0/xe/dbs> ls -ltr
    total 16
    -rwxr-xr-x 1 oracle dba 2851 Aug 29 2011 init.ora
    -rw-r----- 1 oracle dba 1536 Mar 2 15:34 orapwXE
    -rw-r----- 1 oracle dba 2560 Mar 2 15:34 spfileXE.ora
    -rw-rw---- 1 oracle dba 1544 Mar 3 03:23 hc_XE.dat

    No changes have been made to the hostname / ip address.

    oracle@linux-hthu:~/product/11.2.0/xe/dbs> cat init.ora
    #
    # $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $
    #
    # Copyright (c) 1991, 1997, 1998 by Oracle Corporation
    # NAME
    # init.ora
    # FUNCTION
    # NOTES
    # MODIFIED
    # ysarig 05/14/09 - Updating compatible to 11.2
    # ysarig 08/13/07 - Fixing the sample for 11g
    # atsukerm 08/06/98 - fix for 8.1.
    # hpiao 06/05/97 - fix for 803
    # glavash 05/12/97 - add oracle_trace_enable comment
    # hpiao 04/22/97 - remove ifile=, events=, etc.
    # alingelb 09/19/94 - remove vms-specific stuff
    # dpawson 07/07/93 - add more comments regarded archive start
    # maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE
    # jloaiza 03/07/92 - change ALPHA to BETA
    # danderso 02/26/92 - change db_block_cache_protect to dbblock_cache_p
    # ghallmar 02/03/92 - db_directory -> db_domain
    # maporter 01/12/92 - merge changes from branch 1.8.308.1
    # maporter 12/21/91 - bug 76493: Add control_files parameter
    # wbridge 12/03/91 - use of %c in archive format is discouraged
    # ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com
    # thayes 11/27/91 - Change default for cache_clone
    # jloaiza 08/13/91 - merge changes from branch 1.7.100.1
    # jloaiza 07/31/91 - add debug stuff
    # rlim 04/29/91 - removal of char_is_varchar2
    # Bridge 03/12/91 - log_allocation no longer exists
    # Wijaya 02/05/91 - remove obsolete parameters
    #
    ##############################################################################
    # Example INIT.ORA file
    #
    # This file is provided by Oracle Corporation to help you start by providing
    # a starting point to customize your RDBMS installation for your site.
    #
    # NOTE: The values that are used in this file are only intended to be used
    # as a starting point. You may want to adjust/tune those values to your
    # specific hardware and needs. You may also consider using Database
    # Configuration Assistant tool (DBCA) to create INIT file and to size your
    # initial set of tablespaces based on the user input.
    ###############################################################################

    # Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
    # install time)

    db_name='ORCL'
    memory_target=1G
    processes = 150
    audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
    audit_trail ='db'
    db_block_size=8192
    db_domain=''
    db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
    db_recovery_file_dest_size=2G
    diagnostic_dest='<ORACLE_BASE>'
    dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
    open_cursors=300
    remote_login_passwordfile='EXCLUSIVE'
    undo_tablespace='UNDOTBS1'
    # You may want to ensure that control files are created on separate physical
    # devices
    control_files = (ora_control1, ora_control2)
    compatible ='11.2.0'
  • 7. Re: 11g XE on Linux 64
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    According to the Install Guide - http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABGGAJA - openSUSE is not a certified distro, so things may or may not work as expected. Is there a reason you cannot use a certified OS ?

    HTH
    Srini
  • 8. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    Only that Suse / Red Hat charge expensive subscriptions for the OS.
    OpenSuse should be a forerunner of the enterprise version. Even in an unsupported configuration, I would expect error messages when I fail to start a service. The lack of error messages is a concern.

    Looking at the scripts they tend to be more gnome orientated rather than KDE, so will try using Gnome / Suse 12.2 and Centos 6.3 / KDE / Gnome which uses the same codebase as RHEL6.3
  • 9. Re: 11g XE on Linux 64
    yoonas Expert
    Currently Being Moderated
    you dont have init for XE yet

    create one
    sqlplus
    / as sysdba
    create pfile from spfile;
    post the initXE.ora

    What about listener file?

    whats the output of hostname?
  • 10. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    oracle@linux-hthu:~> hostname
    linux-hthu

    oracle@linux-hthu:~> cat /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora
    *.audit_file_dest='/u01/app/oracle/admin/XE/adump'
    *.compatible='11.2.0.0.0'
    *.control_files='/u01/app/oracle/oradata/XE/control.dbf'
    *.db_name='XE'
    *.DB_RECOVERY_FILE_DEST='/u01/app/oracle/fast_recovery_area'
    *.DB_RECOVERY_FILE_DEST_SIZE=10G
    *.diagnostic_dest='/u01/app/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
    *.job_queue_processes=4
    *.memory_target=1073741824
    *.open_cursors=300
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sessions=20
    *.shared_servers=4
    *.undo_management='AUTO'
    *.undo_tablespace='UNDOTBS1'
    oracle@linux-hthu:~> env | grep ORACLE
    ORACLE_SID=XE
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe


    linux-hthu:/u01 # cat app/oracle/product/11.2.0/xe/network/log/listener.log_

    TNSLSNR for Linux: Version 11.2.0.2.0 - Production on 03-MAR-2013 09:24:03

    Copyright (c) 1991, 2011, Oracle. All rights reserved.

    System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/11.2.0/xe/network/log/listener.log
    Trace information written to /u01/app/oracle/product/11.2.0/xe/network/trace/listener.trc
    Trace level is currently 0

    NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
    No valid ADR Base to use

    NL-08013: Invalid ADR Base directory
    Started with pid=12503
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux-hthu)(PORT=1521)))
    TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNS:protocol adapter error
    TNS-00515: Connect failed because target host or object does not exist

    NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging
    No valid ADR Base to use

    NL-08013: Invalid ADR Base directory
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

    Edited by: user8167598 on Mar 3, 2013 6:33 AM
  • 11. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    linux-hthu:/u01/app/oracle/product/11.2.0/xe/network/admin # cat listener.ora
    # listener.ora Network Configuration File:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-hthu)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)
  • 12. Re: 11g XE on Linux 64
    yoonas Expert
    Currently Being Moderated
    check at this loc /u01/app/oracle/product/11.2.0/xe/network/admin

    see if you have listener.ora and tnsnames.ora and post

    and also post output of

    ping linux-hthu

    lsnrctl start
    lsnrctl status
  • 13. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> id
    uid=1001(oracle) gid=1000(dba) groups=1000(dba),33(video)
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> env | grep ORACLE
    ORACLE_SID=XE
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> cat listener.ora
    # listener.ora Network Configuration File:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-hthu)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin>
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> cat tnsnames.ora
    # tnsnames.ora Network Configuration File:

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-hthu)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> hostname
    linux-hthu
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> ping linux-hthu
    ping: unknown host linux-hthu
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> ifconfig -a
    Absolute path to 'ifconfig' is '/sbin/ifconfig', so running it may require superuser privileges (eg. root).
    oracle@linux-hthu:~/product/11.2.0/xe/network/admin> logout
    linux-hthu:~ # ifconfig -a
    eth0 Link encap:Ethernet HWaddr 00:0C:29:D1:1E:F6
    inet addr:172.16.4.128 Bcast:172.16.4.255 Mask:255.255.255.0
    inet6 addr: fe80::20c:29ff:fed1:1ef6/64 Scope:Link
    UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
    RX packets:711 errors:0 dropped:0 overruns:0 frame:0
    TX packets:648 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:1000
    RX bytes:504165 (492.3 Kb) TX bytes:127369 (124.3 Kb)

    lo Link encap:Local Loopback
    inet addr:127.0.0.1 Mask:255.0.0.0
    inet6 addr: ::1/128 Scope:Host
    UP LOOPBACK RUNNING MTU:16436 Metric:1
    RX packets:88 errors:0 dropped:0 overruns:0 frame:0
    TX packets:88 errors:0 dropped:0 overruns:0 carrier:0
    collisions:0 txqueuelen:0
    RX bytes:15916 (15.5 Kb) TX bytes:15916 (15.5 Kb)
    l*inux-hthu:/etc/sysconfig/network # cat ifcfg-eth0*
    BOOTPROTO='dhcp'
    STARTMODE='auto'
    linux-hthu:/etc/sysconfig/network # cat /etc/hosts
    #
    # hosts This file describes a number of hostname-to-address
    # mappings for the TCP/IP subsystem. It is mostly
    # used at boot time, when no name servers are running.
    # On small systems, this file can be used instead of a
    # "named" name server.
    # Syntax:
    #
    # IP-Address Full-Qualified-Hostname Short-Hostname
    #

    127.0.0.1 localhost

    # special IPv6 addresses
    ::1 localhost ipv6-localhost ipv6-loopback

    fe00::0 ipv6-localnet

    ff00::0 ipv6-mcastprefix
    ff02::1 ipv6-allnodes
    ff02::2 ipv6-allrouters
    ff02::3 ipv6-allhosts
  • 14. Re: 11g XE on Linux 64
    user8167598 Newbie
    Currently Being Moderated
    after adding ip / hostname to /etc/hosts file, I get the following:

    sqlplus
    / as sysdba

    select tname from tab;
    *
    ERROR at line 1:
    ORA-01219: database not open: queries allowed on fixed tables/views only


    Almost there ! I really appreciate your help
1 2 Previous Next

Legend

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