Sul sito è presente la vers. western europe in formato rpm e deb, le ho scaricate entrambe(nei vari tentativi), convertito in tgz e installato.
Ho creato l'utente "oracle" e lo ho associato al gruppo "dba".
Ho modificato proprietario e gruppo delle directory di installazione di oracle con:
Codice: Seleziona tutto
chown -R oracle:dba /usr/lib/oracleQuesto script va eseguito da root e tramite il comando seguente esegue le operazioni come se fosse l'utente oracle.
Codice: Seleziona tutto
su -s oracle -c "comando da eseguire"Ho reso eseguibile lo script e poi l'ho modificato eliminando il parametro -s da ogni riga contenente il comando "su" perchè altrimenti non funziona.
Ho commentato tutte le occorrenze di > /dev/null 2>&1 in modo da poter vedere tutto l'output.
Solo una volta sono riuscito a vederlo funzionante sul mio broswer 127.0.0.1:8080/apex (perchè ora oracle include un server http), poi come ho riavviato il pc ho ricevuto solo errori, in qualche sito ho letto che è a causa del pfile e della chiusura errata del DB quando ho spento il pc.
Qui l'output di:
Codice: Seleziona tutto
./oracle-xe configure
Codice: Seleziona tutto
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]:
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]:y
Starting Oracle Net Listener...
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-MAR-2008 12:41:43
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=Kimberly.k.org)(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 09-MAR-2008 12:41:45
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=Kimberly.k.org)(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 801112064 bytes
Fixed Size 1261420 bytes
Variable Size 205521044 bytes
Database Buffers 591396864 bytes
Redo Buffers 2932736 bytes
TO_CHAR(SYSTIMEST
-----------------
20080309 12:41:51
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
-----------------
20080309 12:41:51
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.
LRM-00104: '%sga_target%' is not a legal integer for 'sga_target'
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 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
ORACLE instance started.
Total System Global Area 801112064 bytes
Fixed Size 1261420 bytes
Variable Size 205521044 bytes
Database Buffers 591396864 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: 12:41:56
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: 12:41:56
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 sys identified by "123"
*
ERROR at line 1:
ORA-01109: database not open
alter user system identified by "123"
*
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"
Se qualcuno sa qualcosa, anche solo per sentito dire scriva qui qualcosa... ogni suggerimento sarà utile. [-o< [-o<
Grazie anticipatamente.
