1 2 Previous Next 17 Replies Latest reply: Mar 4, 2013 1:11 AM by user8167598 RSS

    11g XE on Linux 64

    user8167598
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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