[es] - Oracle XE 10g + Debian 3.1

ZeRo8
Wien

Član broj: 168
Poruke: 235
*.13.14.vie.surfer.at.

Profil

Oracle XE 10g + Debian 3.1

^{04.07.2007. u 23:40 - pre 204 meseci}

Imam Debian Server (3.1 sarge) i na njemu sam instalirao oracle.
Pokrecem sledece:

Code:

# lsnrctl start

# /etc/init.d/oracle-xe start

# sqlplus /nolog
# connect sys as sysdba
# startup

----> dobijam sledecu gresku:

Code:

ORA-27102: out of memory
Linux Error: 28: No space left on device

----> onda sam probao sledece

Code:

# connect sys as sysdba
# startup mount pfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/init.ora'

-----> dobio sledece

Code:

ORACLE instance started.

Total System Global Area  121634816 bytes
Fixed Size                  1257356 bytes
Variable Size              91226228 bytes
Database Buffers           26214400 bytes
Redo Buffers                2936832 bytes
ORA-00205: error in identifying control file, check alert log for more info

-----> u log fajlu stoji sledece:

Code:

Thu Jul  5 00:38:02 2007
Starting ORACLE instance (normal)
Thu Jul  5 00:38:02 2007
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /usr/lib/oracle/xe/app/oracle/product/10
.2.0/server/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 50
  shared_pool_size         = 62914560
  control_files            = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/control
.dbf
  db_block_buffers         = 3200
  log_buffer               = 2891264
  log_checkpoint_interval  = 10000
  db_files                 = 80
  db_file_multiblock_read_count= 8

global_names             = TRUE
  parallel_max_servers     = 0
  max_dump_file_size       = 10240
  db_name                  = XE
Obsolete system parameters with specified values:
  oracle_trace_enable
End of obsolete system parameter listing
PMON started with pid=2, OS id=1881
PSP0 started with pid=3, OS id=1885
MMAN started with pid=4, OS id=1887
DBW0 started with pid=5, OS id=1889
LGWR started with pid=6, OS id=1892
CKPT started with pid=7, OS id=1899
SMON started with pid=8, OS id=1901
RECO started with pid=9, OS id=1908
MMON started with pid=10, OS id=1910
MMNL started with pid=11, OS id=1912
Thu Jul  5 00:38:03 2007
Oracle Data Guard is not available in this edition of Oracle.
Thu Jul  5 00:38:03 2007
ALTER DATABASE   MOUNT
Thu Jul  5 00:38:03 2007
ORA-00202: control file: '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/control.db
f'
ORA-27047: unable to read the header block of file
Linux Error: 17: File exists
Additional information: 1
Thu Jul  5 00:38:03 2007
ORA-205 signalled during: ALTER DATABASE   MOUNT...

U cemu je problem?

ps. kontrolni fajl je prazan (control.dbf)

Odgovor na temu

ZeRo8
Wien

Član broj: 168
Poruke: 235
*.13.14.vie.surfer.at.

Profil

Re: Oracle XE 10g + Debian 3.1

^{04.07.2007. u 23:45 - pre 204 meseci}

Jos da prilozim ovo:

# lsnrctl status

Code:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUL-2007 00:44:27

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                04-JUL-2007 19:28:17
Uptime                    0 days 5 hr. 16 min. 9 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/li               stener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lvps87-230-21-248.dedicated.hosteurope.de)(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 BLOCKED, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

Odgovor na temu

sasa_vu
Beograd

Član broj: 62061
Poruke: 200

Sajt: www.fuckoffimbusy.com

+53 Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 00:44 - pre 204 meseci}

Kapiram da ti je ovo prva instalacija Oracle-a na sistemu, i da je posla naopako.
E sad, ovde ima dosta razlicitih gresaka, mada meni najvise lici da ti nisu dobra kernel podesavanja za Oracle instalaciju(pretpostavljam da imas dovoljno prostora na diskovima, dovoljnu velicinu swap i ram memorije za instalaciju).

I've seen things you people wouldn't believe. Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the dark near the Tannhauser gate. All those moments will be lost in time, like tears in rain. Time to die.

Odgovor na temu

ZeRo8
Wien

Član broj: 168
Poruke: 235
*.goethe-wien.at.

Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 11:18 - pre 204 meseci}

sysctl.conf

Code:

#
# /etc/sysctl.conf - Configuration file for setting system variables
# See sysctl.conf (5) for information.
#
#kernel.domainname = example.com
#net/ipv4/icmp_echo_ignore_broadcasts=1
###########
# Oracle XE Recommended Values
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
########

sysctl -p

Code:

sysctl -p
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
error: unknown error 1 setting key 'net.ipv4.ip_local_port_range'

Odgovor na temu

ZeRo8
Wien

Član broj: 168
Poruke: 235
*.goethe-wien.at.

Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 12:53 - pre 204 meseci}

Kad ukucam samo

Code:
startup

dobijem

Code:

ORA-27102: out of memory
Linux Error: 28: No space left on device

Odgovor na temu

sasa_vu
Beograd

Član broj: 62061
Poruke: 200

Sajt: www.fuckoffimbusy.com

+53 Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 20:26 - pre 204 meseci}

Kernel parametri izgledaju ok. Problem je verovatno u SGA podesavanjima.
Probaj da smanjis SGA parametre ili large_pool_size i vidi da li ce onda da se pokrene.

Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at.

Sajt: www.baze-podataka.net

+2 Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 21:18 - pre 204 meseci}

@ZeRo8:
1. 116 MB RAM-a za SGA u verziji 10g je isuvise malo. Preporucujem minimalno 512 MB RAM-a.

2. Obrisi socket fajlove u direktoriju /var/tmp/.oracle

3. Pokusaj da stavis vrijednost shmall na 4194304 .

4. Zatim, zasto si kreirao samo jedan control file? Cak i u test okruzenjima je uobicajeno da se kreiraju minimalno 2 control file-a. Ako ti jedan control file bude skrsen (corrupted), onda ga jednostavno obrises i kopiras drugi ispravni na njegovo mjesto.

5. Usput baci pogled na Tuning Linux for Oracle .

_{[Ovu poruku je menjao Dejan Topalovic dana 05.07.2007. u 22:31 GMT+1]}

Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA

Odgovor na temu

sasa_vu
Beograd

Član broj: 62061
Poruke: 200

Sajt: www.fuckoffimbusy.com

+53 Profil

Re: Oracle XE 10g + Debian 3.1

^{05.07.2007. u 22:10 - pre 204 meseci}

Citat:

smanjis

:-) Greska u pisanju, sad videh.
@Dejan
Pretpostavljam da imas dosta iskustva sa bazama u Linux okruzenju, pa da ne otvaram posebnu temu, ako mozes da preporucis neki dobar alat za rad sa Oracle-om(tipa Toad-a)?
Tora u Debianu ne vidi Oracle po defaultu(vidi Postgre i MySQL), pa koristim Sql Developer trenutno.

Odgovor na temu