Oracle-xe

atlas95 · 2007-03-03 09:31:20

Please someone can make a pkgbuild for oracle?

thanks

STiAT · 2007-03-05 07:46:44

Oracle XE ships as a RPM / DEB file, as a binary (of course).

Since it's already packed and can be installed using RPM / DEB, i think it's better just to use one of those tools to install oracle xe.

tomk · 2007-03-05 09:24:11

Emm.. "one of those tools"? We don't have those tools in Arch.

We usually handle these kind of situations by using rpmextract or rpmunpack in a PKGBUILD.

Last edited by tomk (2007-03-05 09:24:57)

atlas95 · 2007-03-06 10:08:22

Someone can help me?

aquila_deus · 2007-03-12 19:05:53

atlas95 wrote:

Someone can help me?

you need to extract install scripts from .rpm - mc can do that with rpm tools, and selectively executes some lines of them I already forgot the steps, however there is a rc.d script you may find useful:

#!/bin/bash
. /etc/rc.conf
. /etc/rc.d/functions

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=en_US.UTF-8

PID=`pidof -o %PPID xe_pmon_XE`

CONFIG_NAME=oracle-xe
CONFIGURATION="/etc/sysconfig/$CONFIG_NAME"

case "$1" in
  start)
    stat_busy "Starting Oracle Database \"orcl\""
    if [ -z "$PID" ]; then
      /usr/bin/nice -16 /bin/su oracle -c "lsnrctl start >/var/log/oracle/lsnr-start.log 2>&1; echo -e 'CONNECT sys/sys AS sysdba\\nSTARTUP\\n' | sqlplus /nolog >/var/log/oracle/db-start.log 2>&1"
    fi
    if [ ! -z "$PID" -o $? -gt 0 ]; then
      stat_fail
    else
      add_daemon oracle
      stat_done
    fi
    ;;
  stop)
    stat_busy "Stopping Oracle Database \"orcl\""
    [ ! -z "$PID" ]  && /usr/bin/nice -16 /bin/su oracle -c "echo -e 'CONNECT sys/sys AS sysdba\\nSHUTDOWN\\n' | sqlplus /nolog >/var/log/oracle/db-stop.log 2>&1; lsnrctl stop >/var/log/oracle/lsnr-stop.log 2>&1"
    if [ $? -gt 0 ]; then
      stat_fail
    else
      rm_daemon oracle
      stat_done
    fi
    ;;
  restart)
    $0 stop
    sleep 1
    $0 start
    ;;
  *)
    echo "usage: $0 {start|stop|restart}"
esac

BTW if you don't mind the disk space, just use the real oracle (free for developer). I think XE is not good for coding at all, because it has a complete different setup, management tools, and lack of some advanced functionality.

lordsen · 2007-08-22 20:10:58

Hi atlas95,

it's a little bit late, but I ran into the same problem ;-)

So I decided to create a PKGBUILD on my own (my first PKGBUILD btw.)

http://aur.archlinux.org/packages.php?d … 1&ID=12643

I had to change the original configure script because of missing sga_target and pga_aggregate_target parameters (this was a pain in the ass to find that out)

The most important step is to run the oraconfig.sh script to create the oracle configuration, control files, tablespaces, etc.

After a hopefully successfull installation you should logout and login again because I've placed "oracle_env.sh" into your /etc/profile.d/ directory.

I hope this works.

@aquila_deus:

Thanks for your startscript ;-)

I've added this to my PKGBUILD

Last edited by lordsen (2007-08-22 20:12:04)

dr_te_z · 2007-08-23 05:23:42

Wat is it with me? Is my mindset not "arch" enough? Been using slackware and other distro's too much in the past? Do I think I use arch but too stupid to really understand?

I run arch, and I wanted to install IBM's DB2. So I downloaded and installed using the IBM scripts. Now it runs fine.
Yes guilty-as-charged: it does not install with the 'pacman' command. Why would anyone qualify that as a "problem"? Or am I being selfish? Anyone wanting to install DB2 as well could have benefited from my effords. Is that it?

Thralas · 2007-08-23 12:27:33

dr_te_z wrote:

Wat is it with me? Is my mindset not "arch" enough? Been using slackware and other distro's too much in the past? Do I think I use arch but too stupid to really understand?
I run arch, and I wanted to install IBM's DB2. So I downloaded and installed using the IBM scripts. Now it runs fine.
Yes guilty-as-charged: it does not install with the 'pacman' command. Why would anyone qualify that as a "problem"? Or am I being selfish? Anyone wanting to install DB2 as well could have benefited from my effords. Is that it?

You will need to manually keep track of updates, and removing is more difficult than pacman -R db2. Etcetera. But use whatever you feel comfortable with

STiAT · 2007-08-23 14:26:11

Well, i'd say that's not just a arch way. In every distribution there should be packages made if you're installing something, since that's why distributions have a package manager, also to keep track of installed packages and dependencies.

Of course, you could do it like on a lfs box, keeping all install sources etc. to make a uninstall. Still, it's by far "uncleaner" than using a real package manager.

And now, let's come down to pacman. Pacman is very easy to use, not just to use but also to create packages. Therefore a majority CAN make working packages, even though, they rarely are clean.

Yours,
STi

Paranoia · 2007-09-26 10:34:47

Sorry to revive this thread, but how do you start oracle once you install oracle-xe?

Paranoia · 2007-09-26 16:53:51

Okay, I got this partially working...If I intall oracle-xe and then oracle-instantclient everything works fine and I can connect to the DB through sqlplus, but if I restart my computer and then start oracle through /etc/rc.d/oracle-xe start it doesn't work...It says it started but I can't connect to the DB...

Any ideas?

lordsen · 2007-09-28 18:55:34

Is your user in the "dba" group?

What's the error message?

Do you log in with "sqlplus username/password@XE" ?

Did oraconfig.sh run without errors?

Is the listener "tnslsnr" active?

Are your environmental vars set? (env|grep ORACLE)?

LeandroTiger · 2008-07-29 21:43:49

lordsen wrote:

Hi atlas95,
it's a little bit late, but I ran into the same problem ;-)
So I decided to create a PKGBUILD on my own (my first PKGBUILD btw.)
http://aur.archlinux.org/packages.php?d … 1&ID=12643
I had to change the original configure script because of missing sga_target and pga_aggregate_target parameters (this was a pain in the ass to find that out)
The most important step is to run the oraconfig.sh script to create the oracle configuration, control files, tablespaces, etc.
After a hopefully successfull installation you should logout and login again because I've placed "oracle_env.sh" into your /etc/profile.d/ directory.
I hope this works.

Hi,
I follow this package and I receive this error output:

bash-3.2# ./oraconfig.sh 

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]:8080

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


Specify your sga size [128M]:128M

Specify your pga size [96M]:98M
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:
Starting Oracle Net Listener...
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-JUL-2008 18:22:37

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
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

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                29-JUL-2008 18:22:37
Uptime                    0 days 0 hr. 0 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=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
Done
Configuring Database...
ORACLE instance started.

Total System Global Area  134217728 bytes
Fixed Size            1257596 bytes
Variable Size           58724228 bytes
Database Buffers       71303168 bytes
Redo Buffers            2932736 bytes

TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH:MI:SS')
---------------------------------------------------
20080729 06:22:43

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error reading backup piece
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb
ORA-19502: write error on file "/usr/lib/oracle/xe/oradata/XE/sysaux.dbf",
blockno 41729 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 28: No space left on device
Additional information: 4
Additional information: 41729
Additional information: -1
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5149
ORA-06512: at line 16



TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH:MI:SS')
---------------------------------------------------
20080729 06:23:47

ERROR:
ORA-19502: write error on file "/usr/lib/oracle/xe/oradata/XE/system.dbf",
blockno 41601 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 41601
Additional information: 122880


ERROR:
ORA-24313: user already authenticated


Warning: You are no longer connected to ORACLE.
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-24313: user already authenticated


SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
ERROR:
ORA-24313: user already authenticated


SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SP2-0640: Not connected
ERROR:
ORA-24313: user already authenticated


ERROR:
ORA-24313: user already authenticated


SP2-0640: Not connected
SP2-0640: Not connected
ORA-01012: not logged on
ERROR:
ORA-24313: user already authenticated


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
alter user sys identified by "master"
                             *
ERROR at line 1:
ORA-01109: database not open


alter user system identified by "master"
                                *
ERROR at line 1:
ORA-01109: database not open


Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"

Any Idea ?

unregistered · 2009-10-23 11:04:58

hey I have this error after installing and running the oraconfig script, can anyone help?

Configuring Database...
ORA-00821: Specified value of sga_target 4M is too small, needs to be at least 24M
ORA-01078: failure in processing system parameters
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


declare
*
ERROR at line 1:
ORA-01034: ORACLE not available


select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN dbms_backup_restore.zerodbid(0); END;


*
ERROR at line 1:
ORA-01034: ORACLE not available


ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
ORA-00821: Specified value of sga_target 4M is too small, needs to be at least 24M
ORA-01078: failure in processing system parameters
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system enable restricted session
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database rename global_name to "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available



alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database rename global_name to "XE"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system switch logfile
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system checkpoint
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter database drop logfile group 3
*
ERROR at line 1:
ORA-01034: ORACLE not available


ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/lib/oracle/xe/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01034: ORACLE not available


select tablespace_name from dba_tablespaces where tablespace_name='USERS'
*
ERROR at line 1:
ORA-01034: ORACLE not available


select sid, program, serial#, username from v$session
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user sys identified by "oracle"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user system identified by "oracle"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter system disable restricted session
*
ERROR at line 1:
ORA-01034: ORACLE not available


CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libqsmashr.so';
*
ERROR at line 1:
ORA-01034: ORACLE not available


create or replace directory DATA_PUMP_DIR as '/usr/lib/oracle/xe/app/oracle/admin/XE/dpdump/'
*
ERROR at line 1:
ORA-01034: ORACLE not available


commit
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available


commit
*
ERROR at line 1:
ORA-01034: ORACLE not available


begin
*
ERROR at line 1:
ORA-01034: ORACLE not available



File created.ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
ORA-00821: Specified value of sga_target 4M is too small, needs to be at least 24M
select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


BEGIN utl_recomp.recomp_serial(); END;

*
ERROR at line 1:
ORA-01034: ORACLE not available


select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user hr password expire account lock
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user ctxsys password expire account lock
*
ERROR at line 1:
ORA-01034: ORACLE not available
alter user outln password expire account lock
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user mdsys password expire
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user flows_020100 password expire
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user flows_files password expire
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user sys identified by "PASSWORD"
*
ERROR at line 1:
ORA-01034: ORACLE not available


alter user system identified by "PASSWORD"
*
ERROR at line 1:
ORA-01034: ORACLE not available


Done
Starting Oracle Database 10g Express Edition Instance...ORA-00821: Specified value of sga_target 4M is too small, needs to be at least 24M
Done
Installation Completed Successfully.

What should I do?

Last edited by unregistered (2009-10-23 11:18:39)

Snowman · 2009-10-24 05:25:35

Please start a new thread:
http://wiki.archlinux.org/index.php/For … Bumping.27

Closing.

Arch Linux

#1 2007-03-03 09:31:20

Oracle-xe

#2 2007-03-05 07:46:44

Re: Oracle-xe

#3 2007-03-05 09:24:11

Re: Oracle-xe

#4 2007-03-06 10:08:22

Re: Oracle-xe

#5 2007-03-12 19:05:53

Re: Oracle-xe

#6 2007-08-22 20:10:58

Re: Oracle-xe

#7 2007-08-23 05:23:42

Re: Oracle-xe

#8 2007-08-23 12:27:33

Re: Oracle-xe

#9 2007-08-23 14:26:11

Re: Oracle-xe

#10 2007-09-26 10:34:47

Re: Oracle-xe

#11 2007-09-26 16:53:51

Re: Oracle-xe

#12 2007-09-28 18:55:34

Re: Oracle-xe

#13 2008-07-29 21:43:49

Re: Oracle-xe

#14 2009-10-23 11:04:58

Re: Oracle-xe

#15 2009-10-24 05:25:35

Re: Oracle-xe

Board footer