Home » RDBMS Server » Server Administration » Install issues with Oracle XE setup (Oracle 10g XE, Centos 5.2)
Install issues with Oracle XE setup [message #399534] Wed, 22 April 2009 15:54 Go to next message
amcguire
Messages: 4
Registered: April 2009
Location: Elkhart, IN
Junior Member
I am new to the Oracle and slowly maturing in Linux and thought that I would try getting Oracle 10g XE up and going to use a project management server on. I am running Centos 5.2 in VMWare Server.

From the many sets of instructions I have found and the instructions with the project management (PPM) server, I should be able to simply install and "bang" I can start running the scripts to install the PPM server.

Here is the install:

    Upload "oracle-xe-univ-10.2.0.1-1.0.i386.rpm" to /home/amcguire/ on server
    Using VMWare Server Console, log on as root
    Quote:
    rpm -ivh /home/amcguire/oracle-xe-10.2.0.1-1.0.i386.rpm
    /etc/init.d/oracle-xe configure

    Accept defaults and set my password

Now still as root I issue the following:
Quote:
sqlplus system/{password}@XE

I am told this should work out of the box like this but I get the following error:
Quote:
ORA-12541: TNS:no listener

and then it asks for user-name again.
From assorted articles here and elsewhere, I then changed HOST from "projectvm.vps.local" to "127.0.0.1" in listener.ora:
Quote:
# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

and tnsnames.ora
Quote:
# tnsnames.ora Network Configuration File:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(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)
)
)


for good measure I then:
Quote:
lsnrctl stop
lsnrctl start

From the way that Oracle is installed, there is an error:
Quote:
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
NL-00270: cannot open log file
SNL-00016:snlfohd: error opening file
Linux Error: 13: Permissions denied

So I logged in as user:oracle (the user that seems to have permissions for this file) and entered:
Quote:
lsnrctl start

Different errors this time:
Quote:
Started with pid=3890
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

Now from other notes I went in and:
Quote:
chown /var/tmp/.oracle

This seemed to fix the above error when starting the listener. However, now when I issue this command:
Quote:
sqlplus system/{password}@XE

I get this error when logged in as "root" or "oracle":
Quote:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

I have been battling this error for some time and not finding any issues with the suggested files. Any errors in the work that I have done so far and any suggestions for next steps.

Thanks,
Allan

Report message to a moderator

Re: Install issues with Oracle XE setup [message #399535 is a reply to message #399534] Wed, 22 April 2009 16:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The only thing that the root user should do involving Oracle is a single invocation of root.sh as part of the installation process!

All other administration operations, starting or stopping the listener or the database, should be done as the owner of the Oracl s/w tree; usually "oracle".

Log onto the system as the Oracle s/w owner & do the following:
env | sort -o /tmp/oracle.env
lsnrctl status
lsnrctl start
lsnrctl status
sqlplus
/ as sysdba
startup
select * from v$version;
exit
cat /tmp/oracle.env

Now using CUT & PASTE show the session doing all the commands & the results

Report message to a moderator

Re: Install issues with Oracle XE setup [message #399659 is a reply to message #399535] Thu, 23 April 2009 05:57 Go to previous messageGo to next message
amcguire
Messages: 4
Registered: April 2009
Location: Elkhart, IN
Junior Member
Thank for the help. Here is the information:
Quote:
-bash-3.2$ env | sort -o /tmp/oracle.env
-bash-3.2$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 02:45:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-APR-2009 02:37:24
Uptime 0 days 0 hr. 8 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 02:45:53

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

TNS-01106: Listener using listener name LISTENER has already been started
-bash-3.2$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 02:46:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-APR-2009 02:37:24
Uptime 0 days 0 hr. 9 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 02:46:31 2009

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

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

SQL> startup
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
SQL> select * from v$version;
ERROR:
ORA-03114: not connected to ORACLE


SQL> exit
Disconnected
-bash-3.2$ cat /tmp/oracle.env
_=/bin/env
G_BROKEN_FILENAMES=1
HISTFILESIZE=0
HISTSIZE=200
HOME=/usr/lib/oracle/xe
HOSTNAME=projectvm.vps.local
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_SID=XE
PATH=/usr/local/bin:/bin:/usr/bin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
PWD=/usr/lib/oracle/xe
SHELL=/bin/bash
SHLVL=1
SSH_AUTH_SOCK=/tmp/ssh-rOzAkX3308/agent.3308
SSH_CLIENT=96.230.124.67 14442 12360
SSH_CONNECTION=96.230.124.67 14442 10.1.1.10 12360
SSH_TTY=/dev/pts/0
TERM=xterm
TMOUT=1800
TOMCAT_HOME=/opt/tomcat-6.0
USER=oracle
-bash-3.2$

Report message to a moderator

Re: Install issues with Oracle XE setup [message #399696 is a reply to message #399534] Thu, 23 April 2009 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I see 2 problem areas.
1) (HOST=127.0.0.1)
I do not believe SQL*Net works against this IP#
2) SQL> startup
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
You need to find & fix the underlying cause of this ORA-00600
which is typically a Service Request to Oracle

Report message to a moderator

Re: Install issues with Oracle XE setup [message #399704 is a reply to message #399696] Thu, 23 April 2009 09:54 Go to previous messageGo to next message
amcguire
Messages: 4
Registered: April 2009
Location: Elkhart, IN
Junior Member
Thank you so much. While troubleshooting some other problems, someone's notes said to use 127.0.0.1. Changed that to the computer name in the listener and tnsnames files and it looks like it is working!

I do not see any errors but for:
"PLSExtProc", status UNKNOWN


Thanks again. I might start enjoying Oracle Cool

-bash-3.2$ env | sort -o /tmp/oracle.env
-bash-3.2$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 06:42:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                23-APR-2009 06:36:47
Uptime                    0 days 0 hr. 5 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=projectvm.vps.local)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 06:42:17

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

TNS-01106: Listener using listener name LISTENER has already been started
-bash-3.2$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2009 06:42:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                23-APR-2009 06:36:47
Uptime                    0 days 0 hr. 5 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=projectvm.vps.local)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 06:42:40 2009

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

Enter user-name: / as sysdba

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

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE	10.2.0.1.0	Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL> exit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
-bash-3.2$ cat /tmp/oracle.env
_=/bin/env
G_BROKEN_FILENAMES=1
HISTFILESIZE=0
HISTSIZE=200
HOME=/usr/lib/oracle/xe
HOSTNAME=projectvm.vps.local
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_SID=XE
PATH=/usr/local/bin:/bin:/usr/bin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
PWD=/usr/lib/oracle/xe
SHELL=/bin/bash
SHLVL=1
SSH_AUTH_SOCK=/tmp/ssh-jPJfGH3273/agent.3273
SSH_CLIENT=96.230.124.67 16457 12360
SSH_CONNECTION=96.230.124.67 16457 10.1.1.10 12360
SSH_TTY=/dev/pts/0
TERM=xterm
TMOUT=1800
TOMCAT_HOME=/opt/tomcat-6.0
USER=oracle
-bash-3.2$

[Updated on: Thu, 23 April 2009 09:58]

Report message to a moderator

Re: Install issues with Oracle XE setup [message #400562 is a reply to message #399696] Tue, 28 April 2009 14:39 Go to previous messageGo to next message
amcguire
Messages: 4
Registered: April 2009
Location: Elkhart, IN
Junior Member
Thanks for the help. The project server is up and running.

Report message to a moderator

Re: Install issues with Oracle XE setup [message #400568 is a reply to message #400562] Tue, 28 April 2009 18:17 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks for the feedback.

Babu

Report message to a moderator

Previous Topic: ORA 12519
Next Topic: installing oracle with old datafiles
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 05:09:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.