Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
32bit chroot help needed
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64
View previous topic :: View next topic  
Author Message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Tue Nov 06, 2007 1:29 pm    Post subject: 32bit chroot help needed Reply with quote

i've set the 32bit chroot on my multilib install and i'd like to start using some 32bit apps only:
1. oracle-xe - doesn't work on 64 bit and the installation from the ebuild on the bugzilla doesn't let me run the configurator. the sabayon ebuild works but when i try to configure with the script it gives a lot of errors of some nls thing and doesn't work when i try to connect.
2. i wish to install firefox but it needs a lot of stuff, including the xorg and kde. is there a way to install it without installing the whole system?!
3. i need to install sun-jdk but also it pushes:
[ebuild N ] dev-util/pkgconfig-0.22 USE="-hardened" 983 kB
[ebuild NS ] sys-devel/gcc-3.3.6-r1 USE="fortran nls (-altivec) -bootstrap -boundschecking -build -doc -gcj -gtk (-hardened) -ip28 -ip32r10k (-multilib) -multislot (-n32) (-n64) -nocxx -nopie -nossp -objc -test -vanilla" 23,534 kB
[ebuild N ] app-portage/portage-utils-0.1.28 78 kB
[ebuild N ] dev-perl/Locale-gettext-1.05 8 kB
[ebuild N ] media-sound/alsa-headers-1.0.15 2,615 kB
[ebuild N ] x11-misc/util-macros-1.1.5 USE="-debug" 47 kB
[ebuild N ] dev-java/java-config-wrapper-0.14 8 kB
[ebuild N ] virtual/libstdc++-3.3 0 kB
[ebuild N ] sys-apps/help2man-1.36.4 USE="nls" 84 kB
[ebuild N ] x11-proto/xproto-7.0.10 USE="-debug" 140 kB
[ebuild N ] x11-proto/inputproto-1.4.2.1 USE="-debug" 47 kB
[ebuild N ] x11-proto/xextproto-7.0.2 USE="-debug" 67 kB
[ebuild N ] dev-java/java-config-2.1.2-r1 21 kB
[ebuild N ] x11-proto/kbproto-1.0.3 USE="-debug" 57 kB
[ebuild N ] x11-proto/xf86bigfontproto-1.1.2 USE="-debug" 37 kB
[ebuild N ] x11-libs/xtrans-1.0.4 USE="-debug" 102 kB
[ebuild N ] x11-proto/bigreqsproto-1.0.2 USE="-debug" 36 kB
[ebuild N ] x11-proto/xcmiscproto-1.1.2 USE="-debug" 36 kB
[ebuild N ] x11-proto/printproto-1.0.3 USE="-debug" 43 kB
[ebuild N ] dev-java/java-config-1.3.7 15 kB
[ebuild NS ] sys-devel/automake-1.9.6-r2 748 kB
[ebuild N ] x11-proto/recordproto-1.13.2 USE="-debug" 39 kB
[ebuild N ] x11-libs/libXau-1.0.3 USE="-debug" 225 kB
[ebuild N ] x11-libs/libXdmcp-1.0.2 USE="-debug" 216 kB
[ebuild N ] media-libs/alsa-lib-1.0.15 USE="midi -alisp -debug -doc" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" 776 kB
[ebuild N ] x11-libs/libX11-1.1.3 USE="ipv6 -debug -xcb" 1,492 kB
[ebuild N ] x11-libs/libXext-1.0.3 USE="-debug" 256 kB
[ebuild N ] x11-libs/libXp-1.0.0 USE="-debug" 239 kB
[ebuild N ] x11-libs/libXi-1.1.3 USE="-debug" 243 kB
[ebuild N ] x11-libs/libXtst-1.0.3 USE="-debug" 220 kB
[ebuild N ] dev-java/sun-jdk-1.6.0.03 USE="X alsa nsplugin -doc -examples -jce" 67,006 kB

i do not want all this stuff inserted into a 32bit chroot if it is not needed.
Back to top
View user's profile Send private message
Sadako
Advocate
Advocate


Joined: 05 Aug 2004
Posts: 3792
Location: sleeping in the bathtub

PostPosted: Tue Nov 06, 2007 2:51 pm    Post subject: Reply with quote

I have firefox installed in a 32-bit chroot without any xorg-server, but I haven't bothered with java.

It's all a matter of USE flags really, but you will need quite a few X libraries.

I wanted an absolutely minimal chroot, so I actually strarted by setting USE="-*" in make.conf, and only added what I absolutely needed (and made good use of /etc/portage/package.use).

This is my entire USE section in that make.conf;
Code:
USE="-* mmx sse sse2 minimal nocxx nptl nptlonly xcb caps ithreads glibc-omitfp"
And here are the contents for my package.use;
Code:
sys-libs/ncurses -minimal
app-editors/nano ncurses -minimal
sys-apps/module-init-tools no-old-linux
sys-devel/gcc -nocxx
www-client/mozilla-firefox moznopango restrict-javascript
x11-libs/gtk+ jpeg
media-libs/freetype X zlib
x11-libs/cairo X svg
media-video/mplayer 3dnow 3dnowext mmxext alsa X xv xanim live win32codecs quicktime truetype a52 aac mp2 mp3 rar vorbis
media-libs/win32codecs quicktime
net-www/mplayerplug-in gtk divx quicktime wmp realmedia gmedia
dev-libs/openssl zlib
net-misc/curl ssl

Also, emergeing "sys-libs/libstdc++-v3" will save you from having to install gcc 3.3.
_________________
"You have to invite me in"
Back to top
View user's profile Send private message
Cyker
Veteran
Veteran


Joined: 15 Jun 2006
Posts: 1746

PostPosted: Tue Nov 06, 2007 6:30 pm    Post subject: Reply with quote

They are all dependencies which are needed, and you will HAVE to compile most of them at some point.

This is why I think 64-bits is a bad idea if you need to do any significant 32-bit stuff - You will effectively end up having two copies of Gentoo installed; a 32-bit one and a 64-bit one because of all the compile-time and run-time dependencies.

64-bit Gentoo has very good 32-bit support ONLY because the devs work so hard to make the 32-bit emul library dependencies link correctly; As soon as you leave that environment you're in the same 32/64-bit hell that the other distros have to deal with.

If you could make a 32-bit binpackage of that software on another machine, it may be possible to make an overlay ebuild and use that to install it on your system to run under the emul libraries, but that's waaay out of my depth.
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Tue Nov 06, 2007 6:42 pm    Post subject: Reply with quote

so, correct me if i'm wrong: if i make a packaged version of sun-jdk and of the 32bit packages that i need and then install them on my 64bit arch i could get them to work?!
as for java: why the h*** isn't there a way to compile it for 64bit?! now java is opensource and i don't really see why there isn't the possibility to compile it natively for 64bit arch.
the javac doesn't come for amd64 and this is really annoying since i need it to compile things!!!!
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Tue Nov 06, 2007 9:47 pm    Post subject: Reply with quote

beso_1717 wrote:
so, correct me if i'm wrong: if i make a packaged version of sun-jdk and of the 32bit packages that i need and then install them on my 64bit arch i could get them to work?!
as for java: why the h*** isn't there a way to compile it for 64bit?! now java is opensource and i don't really see why there isn't the possibility to compile it natively for 64bit arch.
the javac doesn't come for amd64 and this is really annoying since i need it to compile things!!!!

Do I maybe misunderstand the question re javac?
Code:
tom@sirius ~ $ java-config-2 -L
The following VMs are available for generation-2:
1)      Blackdown JDK 1.4.2.03 [blackdown-jdk-1.4.2]
2)      Sun 32bit JRE 1.6.0.03 [emul-linux-x86-java-1.6]
3)      Sun JDK 1.5.0.13 [sun-jdk-1.5]
*)      Sun JDK 1.6.0.03 [sun-jdk-1.6]
tom@sirius ~ $ javac -version
javac 1.6.0_03
tom@sirius ~ $ epm -qf /opt/sun-jdk-1.6.0.03/bin/javac
sun-jdk-1.6.0.03


No 32bit chroot needed for javac here. It comes with the 64bit sun-jdk o.O
jdk-6u3-dlj-linux-amd64.bin

Gentoo anyway has by far the best java setup on this planet. On both 64 and 32bit.
At work I have a openSUSE10.3 box with this update-alternatives stuff, it simply doesn't work out correctly.
Thank god for SSH, proxytunnel and my Gentoo box at home ;)
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Tue Nov 06, 2007 10:26 pm    Post subject: Reply with quote

Quote:
No 32bit chroot needed for javac here.

it seems that the default javavm was the jre-bin which is 32bit... :-P i've managed to see that after looking on sun's site and finding out that the jdk contains a javac also for 64bit.
i've taken a look at the eselect java-vm and have seen that issue. i've fixed it and now it works well.
the fact that remains is how to make work oracle-xe... i still get a lot of nls errors when configuring. i'll try tomorrow...
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Wed Nov 07, 2007 10:34 pm    Post subject: Reply with quote

beso_1717 wrote:
Quote:
No 32bit chroot needed for javac here.

it seems that the default javavm was the jre-bin which is 32bit... :-P i've managed to see that after looking on sun's site and finding out that the jdk contains a javac also for 64bit.
i've taken a look at the eselect java-vm and have seen that issue. i've fixed it and now it works well.

;)
Quote:
the fact that remains is how to make work oracle-xe... i still get a lot of nls errors when configuring. i'll try tomorrow...

Does it complain about missing nls support somehow? If so, check your kernel config for the native language support (nls) settings.
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Thu Nov 08, 2007 9:57 am    Post subject: Reply with quote

Did you mange it?
I got oracle-xe working nicely on amd64 using a modified ebuild found in sabayon overlay, and a 32bit compiled libaio.
I tested basic db creation and the apex.

svn co http://gimpel.ath.cx/svn/gimpel/dev-db/oracle-xe/
svn co http://gimpel.ath.cx/svn/gimpel/app-emulation/emul-linux-x86-libaio/

The emul is compiled with -march=i686 -O2, that should work on both amd/intel I hope
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Thu Nov 08, 2007 11:24 am    Post subject: Reply with quote

Quote:
Did you mange it?

not yet.
now i'll try out your method and see if i can make it work. i'll let you know if it works.
i've tried your method but i still get this when i configure the db:

Quote:
Confirm the password:
Configuring Database...

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


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-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


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-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


ERROR:
ORA-03114: not connected to ORACLE


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


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


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


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


alter user anonymous identified by "system"
*
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
Done.

To start oracle-xe, run:
/etc/init.d/oracle-xe start
and point your Browser to:
http://localhost:8000/apex/

Log in using username system and the password you supplied...


and when i try sqlplus:

Quote:
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


i've used this to configure oracle-xe:

Quote:
fujitsu oracle-xe # ebuild /var/db/pkg/dev-db/oracle-xe-10.2.0.1_p1-r1/oracle-xe-10.2.0.1_p1-r1.ebuild config
* Checking kernel parameters...
*
* Kernel parameters set, configure oracle-xe using
* /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_configure.sh
* Make sure to run "env-update && source /etc/profile" if you want
* to run the config script from the current shell.
fujitsu oracle-xe # /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_configure.sh
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Thu Nov 08, 2007 1:22 pm    Post subject: Reply with quote

beso_1717 wrote:
Quote:
Did you mange it?

not yet.
[..]
Quote:

* Kernel parameters set, configure oracle-xe using
* /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_configure.sh
* Make sure to run "env-update && source /etc/profile" if you want
* to run the config script from the current shell.


Did you check if
Code:
echo $ORACLE_HOME

returns something from the shell you started the configure.sh?
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Thu Nov 08, 2007 7:03 pm    Post subject: Reply with quote

echo $oracle_home:
Quote:

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server


yes, i've done the env-update && source /etc/profile after installing, i've also tried to open a new shell but no luck.
now i've removed the /etc/conf.d/oracle* and restarted the script and i've got this:

Quote:
Confirm the password:
Configuring Database...

ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes

TO_CHAR(SYSTIMEST
-----------------
20071108 07:40:39

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-19505: failed to identify file
"/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5149
ORA-06512: at line 16



TO_CHAR(SYSTIMEST
-----------------
20071108 07:40:39

Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4168
ORA-06512: at line 1


ORA-01507: database not mounted


ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



System altered.

alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted


alter database rename global_name to "XE"
*
ERROR at line 1:
ORA-01109: database not open


alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open


alter system checkpoint
*
ERROR at line 1:
ORA-01109: database not open


alter database drop logfile group 3
*
ERROR at line 1:
ORA-01507: database not mounted


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-01109: database not open


select tablespace_name from dba_tablespaces where tablespace_name='USERS'
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
49 oracle@fujitsu (PMON) 1


41 oracle@fujitsu (MMON) 3


42 oracle@fujitsu (RECO) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
40 oracle@fujitsu (MMNL) 3


44 oracle@fujitsu (CKPT) 1


48 oracle@fujitsu (PSP0) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
45 oracle@fujitsu (LGWR) 1


46 oracle@fujitsu (DBW0) 1


47 oracle@fujitsu (MMAN) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
43 oracle@fujitsu (SMON) 1


39 sqlplus@fujitsu (TNS V1-V3) 3
SYS


11 rows selected.

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


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



System altered.

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-01109: database not open


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


commit
*
ERROR at line 1:
ORA-01109: database not open


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

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SWRF_INTERNAL.CLEANUP_DATABASE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


commit
*
ERROR at line 1:
ORA-01109: database not open


dbms_xdb.sethttpport('8000');
*
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_XDB.SETHTTPPORT' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored
ORA-06550: line 3, column 4:
PLS-00201: identifier 'DBMS_XDB.SETFTPPORT' must be declared
ORA-06550: line 3, column 4:
PL/SQL: Statement ignored



File created.

ORA-01507: database not mounted


ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes
ORA-00205: error in identifying control file, check alert log for more info



'UTL_RECOMP_BEGIN:'||TO_CH
--------------------------
utl_recomp_begin: 07:41:11

BEGIN utl_recomp.recomp_serial(); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



'UTL_RECOMP_END:'||TO_CH
------------------------
utl_recomp_end: 07:41:11

alter user hr password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user ctxsys password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user outln password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user mdsys password expire
*
ERROR at line 1:
ORA-01109: database not open


alter user flows_020100 password expire
*
ERROR at line 1:
ORA-01109: database not open


alter user flows_files password expire
*
ERROR at line 1:
ORA-01109: database not open


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


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


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


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


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


ORA-01507: database not mounted


ORACLE instance shut down.
Done.

To start oracle-xe, run:
/etc/init.d/oracle-xe start
and point your Browser to:
http://localhost:8080/apex/

Log in using username system and the password you supplied...


for what i've seen it seems that it cannot create the db... i also cannot connect to it.
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Thu Nov 08, 2007 8:19 pm    Post subject: Reply with quote

Quote:
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory

Strange! I had that error too on the first run of the script. I re-emerged oracle-xe and after that the file was there too. In my case the whole seeddb/ folder was missing

No idea, looking at the ebuild it seems to do everything correctly. It simply moves the complete /usr/lib/oracle folder over.
Anyways, try a re-emerge.
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Thu Nov 08, 2007 10:01 pm    Post subject: Reply with quote

i've managed somehow to install the oracle-xe on the chroot and copy the files from there, since after 3 (r)emerges i wan't able to have the files installed.
then i've run the configure and i got this:
Quote:
Confirm the password:
Configuring Database...

ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes

TO_CHAR(SYSTIMEST
-----------------
20071108 10:50:46

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
Restore done.

PL/SQL procedure successfully completed.


TO_CHAR(SYSTIMEST
-----------------
20071108 10:52:45


Control file created.


PL/SQL procedure successfully completed.

ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes

Control file created.


System altered.


Database altered.


Database altered.


System altered.


System altered.


Database altered.


Tablespace altered.


TABLESPACE_NAME
------------------------------
USERS


SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
35 oracle@fujitsu (QMNC) 4


38 oracle@fujitsu (MMNL) 3


39 sqlplus@fujitsu (TNS V1-V3) 3
SYS


SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
41 oracle@fujitsu (MMON) 3


42 oracle@fujitsu (RECO) 1


43 oracle@fujitsu (SMON) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
44 oracle@fujitsu (CKPT) 1


45 oracle@fujitsu (LGWR) 1


46 oracle@fujitsu (DBW0) 1



SID PROGRAM SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
47 oracle@fujitsu (MMAN) 1


48 oracle@fujitsu (PSP0) 1


49 oracle@fujitsu (PMON) 1



12 rows selected.


User altered.


User altered.


System altered.


Library created.


Directory created.


Commit complete.


PL/SQL procedure successfully completed.


Commit complete.


PL/SQL procedure successfully completed.


File created.

Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 247463936 bytes
Fixed Size 1258244 bytes
Variable Size 79695100 bytes
Database Buffers 163577856 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.

'UTL_RECOMP_BEGIN:'||TO_CH
--------------------------
utl_recomp_begin: 10:54:11


PL/SQL procedure successfully completed.


'UTL_RECOMP_END:'||TO_CH
------------------------
utl_recomp_end: 10:54:15


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.


User altered.

Database closed.
Database dismounted.
ORACLE instance shut down.
Done.

To start oracle-xe, run:
/etc/init.d/oracle-xe start
and point your Browser to:
http://localhost:8000/apex/

Log in using username system and the password you supplied...

and it seems that it has successfully configured oracle, but when i try to login to apex i get a not available error from firefox and konqueror, and when i try to login from sqlplus to system or sys i get this error:

Quote:
ERROR:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied

is there some other thing to do except from running the service?!
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Thu Nov 08, 2007 10:11 pm    Post subject: Reply with quote

beso_1717 wrote:
i've managed somehow to install the oracle-xe on the chroot and copy the files from there, since after 3 (r)emerges i wan't able to have the files installed.
then i've run the configure and i got this:
Quote:
Database closed.
Database dismounted.
ORACLE instance shut down.
Done.

To start oracle-xe, run:
/etc/init.d/oracle-xe start

and point your Browser to:
http://localhost:8000/apex/

and it seems that it has successfully configured oracle, but when i try to login to apex i get a not available error from firefox and konqueror, and when i try to login from sqlplus to system or sys i get this error:

It's configured successfully, but not startet yet. Run the init script. :)

Still no idea what's wrong with that ebuild, but at least it did the hard work of checking/setting kernel parameters and creating user & group :D
Maybe I'll look into it if i get the time.
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Fri Nov 09, 2007 9:16 am    Post subject: Reply with quote

i think that i've found the problem, but i don't know how to fix it.
i've cat the init script (since after starting i wasn't getting listener or db) and executed the commands inside step by step and on the listener start i get this:

Quote:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-NOV-2007 09:52:27

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)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fujitsu)(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


Listener failed to start. See the error message(s) above...


the log file says:
Quote:

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 09-NOV-2007 09:52:30

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

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
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=8786
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fujitsu)(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

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))


edited:

i've managed to correct the entry in the names setting fujitsu to 127.0.0.1 and the listener starts, but i still cannot get this:
Quote:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

when i try to connect to the db. :-(
Back to top
View user's profile Send private message
gimpel
Advocate
Advocate


Joined: 15 Oct 2004
Posts: 2720
Location: Munich, Bavaria

PostPosted: Fri Nov 09, 2007 3:56 pm    Post subject: Reply with quote

That looks like
a) a permission problem - try to su to oraclexe user if you haven't already.
b) ORACLE_SID might be incorrect

Now these are oracle configuration problems, so we are getting really off forum topics here. :)
_________________
http://proaudio.tuxfamily.org/wiki - pro-audio software overlay
Back to top
View user's profile Send private message
beso_1717
Apprentice
Apprentice


Joined: 19 Jul 2007
Posts: 263

PostPosted: Sat Nov 10, 2007 7:13 pm    Post subject: Reply with quote

i've tried it in the 32bit chroot, on an i586 and on a i686 and the only way to have it work was on opensuse 10.3 i586. :-(
that's a really annoying issue!!!! now i've understood why that package never got into portage.
i'll try the full 11 or 10g version and see if i can make it work.
the bas thing is that i only need some minor features, as the db and sqlplus for some training but it seems that i have to install the full 1.6GB package for that....
at least it has a native x64 arch. i'll let you know if i can make it work and in a positive case i'll post an ebuild in the bugzilla.
anyway, returning to the point this thread started from:
i'd like to remove the multilib from my amd64 system, since i've seen some minor issues with some package compilation and have 32bit chroot for those 32bit packages. i was wondering if it really is a good idea doing it. i'd have a lot of duplicated packages and should recompile the entire system. does it really worths?! and what 32bit apps are there to use that don't have a 64bit counterparts or don't work for 64bit?!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64 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