Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Oracle 10g Express Edition won't run
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
capira
Tux's lil' helper
Tux's lil' helper


Joined: 02 May 2005
Posts: 147
Location: Spain

PostPosted: Mon Sep 11, 2006 10:00 pm    Post subject: Oracle 10g Express Edition won't run Reply with quote

Hi all!

I already know that Oracle 10g Express Edition is not supported by the gentoo community, but I need to have it running onto a gentoo machine (x86) because of work.

I have tried a HOWTO posted in the Gentoo Wiki (which I already know it is not supported by the gentoo dev community) in this link without any success.

Everything seems to work fine untill a few errors appears:
Code:
# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm --nodeps
Preparing...                ########################################### [100%]
   1:oracle-xe-univ         ########################################### [100%]
Executing Post-install steps...
Usage: useradd [options] LOGIN

Options:
  -b, --base-dir BASE_DIR       base directory for the new user account
                                home directory
  -c, --comment COMMENT         set the GECOS field for the new user account
  -d, --home-dir HOME_DIR       home directory for the new user account
  -D, --defaults                print or save modified default useradd
                                configuration
  -e, --expiredate EXPIRE_DATE  set account expiration date to EXPIRE_DATE
  -f, --inactive INACTIVE       set password inactive after expiration
                                to INACTIVE
  -g, --gid GROUP               force use GROUP for the new user account
  -G, --groups GROUPS           list of supplementary groups for the new
                                user account
  -h, --help                    display this help message and exit
  -k, --skel SKEL_DIR           specify an alternative skel directory
  -K, --key KEY=VALUE           overrides /etc/login.defs defaults
  -m, --create-home             create home directory for the new user
                                account
  -o, --non-unique              allow create user with duplicate
                                (non-unique) UID
  -p, --password PASSWORD       use encrypted password for the new user
                                account
  -s, --shell SHELL             the login shell for the new user account
  -u, --uid UID                 force use the UID for the new user account
/bin/chown: `oracle:dba': invalid user
/bin/chown: `oracle:dba': invalid user
/var/tmp/rpm-tmp.18995: line 29: /sbin/chkconfig: No such file or directory# /etc/init.d/oracle-xe configure
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.
I can guessed that the problem is the oracle account has not been created. So i have run this command instead:
Code:
# useradd -G dba,wheel oracle

I follow the other steps, configure Oracle but it is not running
Code:
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:7070

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:n

Starting Oracle Net Listener...Done
Configuring Database...grep: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/*.log: No such file or directory
Done
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:7070/apex"
# netstat -an|grep 1521
# ps -ef | grep ora
root      2847 23736  0 23:28 pts/2    00:00:00 grep ora

I have tried to see the oracle daemon status:
Code:
# /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-SEP-2006 23:29:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=churro)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

And I start the daemon I get no output, no log file ...

Can anyone help?
Back to top
View user's profile Send private message
ChrisWhite
Retired Dev
Retired Dev


Joined: 08 Jul 2004
Posts: 399
Location: Stockton, CA

PostPosted: Tue Sep 12, 2006 2:03 am    Post subject: Reply with quote

http://www.gen2net.net/articles/oracle-startup-guide

try this :P
Back to top
View user's profile Send private message
blu3bird
Retired Dev
Retired Dev


Joined: 04 Oct 2003
Posts: 612
Location: Munich, Germany

PostPosted: Tue Sep 12, 2006 6:07 am    Post subject: Reply with quote

/etc/init.d/oracle-xe doesn't work on gentoo(at least not for me)

after rpm 'unpacking' you'll have to execute /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/XE.sh manually(step by step, not all at once to see if an error occurs)

After you completed installing this script migth be usefull to start and stop it
(/etc/init.d/oracle)
Code:
#!/sbin/runscript
# Copyright 1999-2005 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_OWNER=oracle
ORACLE_SID=XE
LSNR=$ORACLE_HOME/bin/lsnrctl
SQLPLUS=$ORACLE_HOME/bin/sqlplus
SU=/bin/su
export ORACLE_HOME
export ORACLE_SID
export PATH=$ORACLE_HOME/bin:$PATH
LOG="$ORACLE_HOME_LISTNER/listener.log"
export LC_ALL=C

start() {
        ebegin "Starting Oracle Net Listener"
                $SU $ORACLE_OWNER -l -c "$LSNR  start" > /dev/null 2>&1
        eend $?
        ebegin "Starting Oracle Database 10g Express Edition Instance"
                $SU $ORACLE_OWNER -l -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" > /dev/null 2>&1
        eend $?
}

stop() {
        ebegin "Shutting down Oracle Database 10g Express Edition Instance"
                $SU $ORACLE_OWNER -l -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/stopdb.sql" > /dev/null 2>&1
        eend $?
        ebegin "Stopping Oracle Net Listener"
                $SU $ORACLE_OWNER -l -c "$LSNR stop" > /dev/null 2>&1
        eend $?
}


stuff you should put in your /etc/sysctl.conf:
Code:
#needed for oracle 10g XE
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

_________________
Black Holes are created when God divides by zero!
Back to top
View user's profile Send private message
capira
Tux's lil' helper
Tux's lil' helper


Joined: 02 May 2005
Posts: 147
Location: Spain

PostPosted: Tue Sep 12, 2006 10:29 am    Post subject: Reply with quote

Thanks for both answer!

I still have a problem. When I try to run '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/XE.sh' I get an error:
Code:
# /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus -s /nolog @/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/XE.sql

ERROR:
ORA-01031: insufficient privileges


ORA-01031: insufficient privileges
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-01031: insufficient privileges


SP2-0640: Not connected
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
ORA-01012: not logged on
ORA-01031: insufficient privileges
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-01031: insufficient privileges


SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-01031: insufficient privileges


SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected
ERROR:
ORA-01031: insufficient privileges


ERROR:
ORA-01031: insufficient privileges


SP2-0640: Not connected
SP2-0640: Not connected
ORA-01012: not logged on
ERROR:
ORA-01031: insufficient privileges


ORA-01031: insufficient privileges
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
I have no clue what is the problem now!
Back to top
View user's profile Send private message
tence_g
n00b
n00b


Joined: 11 Sep 2006
Posts: 3

PostPosted: Wed Sep 13, 2006 7:49 pm    Post subject: Reply with quote

ChrisWhite wrote:
http://www.gen2net.net/articles/oracle-startup-guide

try this :P


=/ your link is down..
Back to top
View user's profile Send private message
ChrisWhite
Retired Dev
Retired Dev


Joined: 08 Jul 2004
Posts: 399
Location: Stockton, CA

PostPosted: Wed Sep 13, 2006 9:38 pm    Post subject: Reply with quote

Fixed, goddady was being lame.
Back to top
View user's profile Send private message
tence_g
n00b
n00b


Joined: 11 Sep 2006
Posts: 3

PostPosted: Thu Sep 14, 2006 3:32 am    Post subject: Reply with quote

Okay i followed your guide on the source based distros but im kinda stuck on the netstat part. Apparantly the web services aren't up.

Code:

localhost admin # netstat -ln | egrep "(8080|1521)"
tcp        0      0 0.0.0.0:1521            0.0.0.0:*               LISTEN


Here's my oracle status

Code:
localhost admin # /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-SEP-2006 19:35:58

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                13-SEP-2006 19:30:34
Uptime                    0 days 0 hr. 5 min. 23 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=tcp)(HOST=localhost.localdomain)(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
Back to top
View user's profile Send private message
dertobi123
Retired Dev
Retired Dev


Joined: 19 Nov 2002
Posts: 2679
Location: Oberhausen, Germany

PostPosted: Mon Sep 18, 2006 4:33 pm    Post subject: Reply with quote

You might want to try the Ebuild attached at to Bug: https://bugs.gentoo.org/show_bug.cgi?id=123663
Back to top
View user's profile Send private message
kenjiru
n00b
n00b


Joined: 07 Feb 2006
Posts: 41
Location: Romania

PostPosted: Thu Sep 21, 2006 2:36 pm    Post subject: Reply with quote

Hello, I have the same problem as capira. The problem is the server doesn't start... Any idea how can I debug this thing?

I also got some errors when on the configure stage:
Code:

Starting Oracle Net Listener...Done
Configuring Database...grep: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/*.log: No such file or directory
Done
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8088/apex"


And indeed, /usr/lib/oracle/xe/oradata/XE doesn't exist...

Also, I get the following error:
Code:

kenjiru init.d # lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 21-SEP-2006 21:12:25

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

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
 NL-00278: cannot open log file
  SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...
Back to top
View user's profile Send private message
aztrix
n00b
n00b


Joined: 18 Aug 2010
Posts: 1

PostPosted: Wed Aug 18, 2010 2:22 pm    Post subject: Reply with quote

Howzit folks?

I've found the solution at http://forums.opensuse.org/english/get-help-here/applications/427267-still-unable-unstall-oracle-xe.html

Cheers
Bruce
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum