on 02-13-2008 9:21 AM
Hi guru,
Im doing R3SETUP -f DBMIG.R3S to oracle 10g but i hit error at this phase DBCREATEDB_IND_ORA
the error is -->
INFO 2008-02-13 15:46:53
Creating the Database
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SyPermissionSet:100
Changing the permission of file orascr.sql to 666 ...
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA InternalInstallationDo:0
Create Database.
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SyCoprocessCreateAsUser:300
Creating coprocess /oracle/PRD/102_64/bin/sqlplus /NOLOG
@orascr.sql as user oraprd and group dba ...
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SyGroupIDGet:100
Group id for group dba is 108.
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SyUserIDGet:300
User id for user oraprd is 110.
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
Return from DB: 25138.
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 13 15:46:53
2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> SET TERMOUT ON;
SQL> SHUTDOWN ABORT;
ORACLE instance shut down.
SQL> STARTUP NOMOUNT PFILE=init.ora;
ORA-25138: ENQUEUE_RESOURCES initialization parameter has been
made obsolete
ORA-32006: LOG_ARCHIVE_START initialization parameter has been
deprecated
ORA-25138: TRANSACTION_AUDITING initialization parameter has been
made obsolete
ORA-25138: HASH_JOIN_ENABLED initialization parameter has been
made obsolete
ORA-00381: cannot use both new and old parameters for buffer
cache size specification
SQL> CREATE DATABASE PRD
2 CONTROLFILE REUSE
3 MAXDATAFILES 254
4 MAXLOGFILES 255
5 MAXLOGHISTORY 1000
6 MAXLOGMEMBERS 3
7 MAXINSTANCES 50
8 NOARCHIVELOG
9 CHARACTER SET "WE8DEC"
10 DATAFILE
11 '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 200M REUSE
12 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT
LOCAL
13 DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE
14 '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 300M REUSE
15 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
16 UNDO TABLESPACE PSAPUNDO DATAFILE
INFO 2008-02-13 15:46:53 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
17 '/oracle/PRD/sapdata1/roll_1/roll.data1' SIZE 650M REUSE
18 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
19 SYSAUX DATAFILE
20 '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 100M REUSE
21 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
22 LOGFILE
23 GROUP 11 (
24 '/oracle/PRD/origlogA/log_g11m1.dbf',
25 '/oracle/PRD/mirrlogA/log_g11m2.dbf'
26 ) SIZE 20M REUSE
27 ,GROUP 13 (
28 '/oracle/PRD/origlogA/log_g13m1.dbf',
29 '/oracle/PRD/mirrlogA/log_g13m2.dbf'
30 ) SIZE 20M REUSE
31 ,GROUP 12 (
32 '/oracle/PRD/origlogB/log_g12m1.dbf',
33 '/oracle/PRD/mirrlogB/log_g12m2.dbf'
34 ) SIZE 20M REUSE
35 ,GROUP 14 (
36 '/oracle/PRD/origlogB/log_g14m1.dbf',
37 '/oracle/PRD/mirrlogB/log_g14m2.dbf'
38 ) SIZE 20M REUSE
39 ;
CREATE DATABASE PRD
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> EXIT
Disconnected
ERROR 2008-02-13 15:46:53 DBCREATEDB_IND_ORA InternalInstallationDo:0
Create Database failed errorcode = 25138.
ERROR 2008-02-13 15:46:53 DBCREATEDB_IND_ORA InstallationDo:0
Phase failed.
ERROR 2008-02-13 15:46:53 InstController Action:0
Step DBCREATEDB_IND_ORA could not be performed.
ERROR 2008-02-13 15:46:54 Main
Installation failed.
ERROR 2008-02-13 15:46:54 Main
Installation aborted.
Hope can assistme..im running out time to do upgrade ECC6
zakie
chek note 491174 obout ORA-01034.
The ORA-25138 :
When you upgrade the Oracle Server, the DBUA displays the following error messages:
ORA-25138: initialization parameter has been made obsolete
or
ORA-32006: initialization parameter has been deprecated
This error occurs because the DBUA did not remove obsolete parameters from the new 10g parameter file. If, for example, the symptom described in Note 905279 occurs and the database is reconfigured accordingly, this problem can occur later during the upgrade, if you did not end the DBUA during the change.
Oracle bug: 4959323
Workaround/recommendation:
If, during the preparation phase for the upgrade, the DBUA still reports errors that require you to make a change or adjustment to the database configuration, you must restart the DBUA after the change.
(IM 317753 2006)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ERROR 2008-02-13 18:04:36 DBCREATEDB_IND_ORA InternalInstallationDo:0
Create Database failed errorcode = 25138.
ERROR 2008-02-13 18:04:36 DBCREATEDB_IND_ORA InstallationDo:0
Phase failed.
ERROR 2008-02-13 18:04:36 InstController Action:0
Step DBCREATEDB_IND_ORA could not be performed.
ERROR 2008-02-13 18:04:37 Main
Installation failed.
ERROR 2008-02-13 18:04:37 Main
Installation aborted.
still not solves yet...i try to use initPRD.ora but still cant solve it pleaseeeeeee need helppppp
Still face that error after implement note Note 372205 - ERROR 1078 in phase DBCREATEDB_IND_ORA
hmm why this happen???
INFO 2008-02-13 18:42:01 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
Return from DB: 25138.
INFO 2008-02-13 18:42:01 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 13 18:42:01
2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> SET TERMOUT ON;
SQL> SHUTDOWN ABORT;
ORACLE instance shut down.
SQL> STARTUP NOMOUNT PFILE=init.ora;
ORA-25138: ENQUEUE_RESOURCES initialization parameter has been
made obsolete
ORA-32006: LOG_ARCHIVE_START initialization parameter has been
deprecated
ORA-25138: TRANSACTION_AUDITING initialization parameter has been
made obsolete
ORA-00381: cannot use both new and old parameters for buffer
cache size specification
SQL> CREATE DATABASE PRD
2 CONTROLFILE REUSE
3 MAXDATAFILES 254
4 MAXLOGFILES 255
5 MAXLOGHISTORY 1000
6 MAXLOGMEMBERS 3
7 MAXINSTANCES 50
8 NOARCHIVELOG
9 CHARACTER SET "WE8DEC"
10 DATAFILE
11 '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 200M REUSE
12 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT
LOCAL
13 DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE
14 '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 300M REUSE
15 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
16 UNDO TABLESPACE PSAPUNDO DATAFILE
17 '/oracle/PRD/sapdata1/roll_1/roll.data1' SIZE 650M REUSE
INFO 2008-02-13 18:42:01 DBCREATEDB_IND_ORA SvrmgrDoDummy:0
18 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
19 SYSAUX DATAFILE
20 '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 100M REUSE
21 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
22 LOGFILE
23 GROUP 11 (
24 '/oracle/PRD/origlogA/log_g11m1.dbf',
25 '/oracle/PRD/mirrlogA/log_g11m2.dbf'
26 ) SIZE 20M REUSE
27 ,GROUP 13 (
28 '/oracle/PRD/origlogA/log_g13m1.dbf',
29 '/oracle/PRD/mirrlogA/log_g13m2.dbf'
30 ) SIZE 20M REUSE
31 ,GROUP 12 (
32 '/oracle/PRD/origlogB/log_g12m1.dbf',
33 '/oracle/PRD/mirrlogB/log_g12m2.dbf'
34 ) SIZE 20M REUSE
35 ,GROUP 14 (
36 '/oracle/PRD/origlogB/log_g14m1.dbf',
37 '/oracle/PRD/mirrlogB/log_g14m2.dbf'
38 ) SIZE 20M REUSE
39 ;
CREATE DATABASE PRD
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> EXIT
Disconnected
ERROR 2008-02-13 18:42:01 DBCREATEDB_IND_ORA InternalInstallationDo:0
Create Database failed errorcode = 25138.
ERROR 2008-02-13 18:42:01 DBCREATEDB_IND_ORA InstallationDo:0
Phase failed.
ERROR 2008-02-13 18:42:01 InstController Action:0
Step DBCREATEDB_IND_ORA could not be performed.
ERROR 2008-02-13 18:42:02 Main
Installation failed.
ERROR 2008-02-13 18:42:02 Main
Installation aborted.
the listener already up
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
Start Date 13-FEB-2008 19:21:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/PRD/102_64/network/admin/listener.ora
Listener Log File /oracle/PRD/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ECCPRD)(PORT=1527)))
Services Summary...
Service "PRD" has 1 instance(s).
Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Look "R3trans -d", that with a database. Also check the init.ora and spfile. For example the .LOG_ARCHIVE_START parameter is no longer required to be set in order to run the database in ARCHIVELOG mode. This parameter is deprecated in Oracle 10g.
And check the error
ORA-00381: cannot use both new and old parameters for buffer
cache size specification. May be you still use old database parametrs from old oracle versions
check note 579540 (Though there it is spoken about 9 and 8 versions)
Edited by: Sergo Beradze on Feb 13, 2008 1:40 PM
Edited by: Sergo Beradze on Feb 13, 2008 1:48 PM
Hi markus,
Glad u help me out
this is the alert_PRD.log
Wed Feb 13 14:35:07 2008
Starting ORACLE instance (normal)
Wed Feb 13 14:39:57 2008
Starting ORACLE instance (normal)
Wed Feb 13 15:46:53 2008
Starting ORACLE instance (normal)
Wed Feb 13 16:48:10 2008
Starting ORACLE instance (normal)
Wed Feb 13 17:25:45 2008
Starting ORACLE instance (normal)
Wed Feb 13 17:31:41 2008
Starting ORACLE instance (normal)
Wed Feb 13 17:57:48 2008
Starting ORACLE instance (normal)
Wed Feb 13 17:59:15 2008
Starting ORACLE instance (normal)
Wed Feb 13 18:04:36 2008
Starting ORACLE instance (normal)
Wed Feb 13 18:15:30 2008
Starting ORACLE instance (normal)
Wed Feb 13 18:18:19 2008
Starting ORACLE instance (normal)
Wed Feb 13 18:42:01 2008
Starting ORACLE instance (normal)
Wed Feb 13 18:54:50 2008
Starting ORACLE instance (normal)
Wed Feb 13 19:22:05 2008
Starting ORACLE instance (normal)
Wed Feb 13 19:28:59 2008
Starting ORACLE instance (normal)
Wed Feb 13 19:55:48 2008
Starting ORACLE instance (normal)
#
is it crashed??cause im doing import DBMIG.R3S ....
Here my init .ora
please guy..
replace DEFAULT with your database name
db_name=DEFAULT
db_files = 80 # SMALL
db_files = 400 # MEDIUM
db_files = 1500 # LARGE
db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE
#db_block_buffers = 550 # MEDIUM
db_block_buffers = 3200 # LARGE
#shared_pool_size = 3500000
shared_pool_size = 123232153 # SMALL
shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
processes = 100 # MEDIUM
processes = 200 # LARGE
parallel_max_servers = 5 # SMALL
parallel_max_servers = 4 x (number of CPUs) # MEDIUM
parallel_max_servers = 4 x (number of CPUs) # LARGE
log_buffer = 32768 # SMALL
log_buffer = 32768 # MEDIUM
log_buffer = 163840 # LARGE
audit_trail = true # if you want auditing
timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
Uncommenting the line below will cause automatic archiving if archiving has
been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_start = true
log_archive_dest = disk$rdbms:[oracle.archive]
log_archive_format = "T%TS%S.ARC"
If using private rollback segments, place lines of the following
form in each of your instance-specific init.ora files:
rollback_segments = (name1, name2)
If using public rollback segments, define how many
rollback segments each instance will pick up, using the formula
# of rollback segments = transactions / transactions_per_rollback_segment
In this example each instance will grab 40/5 = 8:
transactions = 40
transactions_per_rollback_segment = 5
Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = TRUE
Edit and uncomment the following line to provide the suffix that will be
appended to the db_name parameter (separated with a dot) and stored as the
global database name when a database is created. If your site uses
Internet Domain names for e-mail, then the part of your e-mail address after
the '@' is a good candidate for this parameter value.
db_domain = us.acme.com # global database name is db_name.db_domain
FOR DEVELOPMENT ONLY, ALWAYS TRY TO USE SYSTEM BACKING STORE
vms_sga_use_gblpagfil = TRUE
FOR BETA RELEASE ONLY. Enable debugging modes. Note that these can
adversely affect performance. On some non-VMS ports the db_block_cache_*
debugging modes have a severe effect on performance.
#_db_block_cache_protect = true # memory protect buffers
#event = "10210 trace name context forever, level 2" # data block checking
#event = "10211 trace name context forever, level 2" # index block checking
#event = "10235 trace name context forever, level 1" # memory heap checking
#event = "10049 trace name context forever, level 2" # memory protect cursors
define parallel server (multi-instance) parameters
#ifile = ora_system:initps.ora
define two control files by default
control_files = (ora_control1, ora_control2)
Uncomment the following line if you wish to enable the Oracle Trace product
to trace server activity. This enables scheduling of server collections
from the Oracle Enterprise Manager Console.
Also, if the oracle_trace_collection_name parameter is non-null,
every session will write to the named collection, as well as enabling you
to schedule future collections from the console.
oracle_trace_enable = TRUE
Uncomment the following line, if you want to use some of the new 8.1
features. Please remember that using them may require some downgrade
actions if you later decide to move back to 8.0.
#compatible = 8.1.0
SQL> connect / as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-00381: cannot use both new and old parameters for buffer cache size specific
ation
im doing DBMIG.R3S and it using
STARTUP NOMOUNT PFILE=init.ora;
this init.ora i use-->
#db_block_buffers= 9000
log_buffer = 1048576
sort_area_retained_size = 0
sort_area_size = 2097152
open_cursors = 800
dml_locks = 2500
enqueue_resources = 8000
#control_files =( /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf, /oracle/PRD/sapdata2/cntrl/cntrlPRD.dbf, /oracle/PRD/sapdata3/cntrl/cntrlPRD.dbf)
log_checkpoint_interval = 300000
log_checkpoint_timeout = 0
#PROCESS-PARAMETERS
processes = 80
sessions = 96
#DB-NAME
db_name = PRD
#DB-BLOCKSIZE
db_block_size = 8192
#DB-FILES
db_files = 254
#OPTIMIZER MODE
optimizer_mode = choose
background_dump_dest = /oracle/PRD/saptrace/background
user_dump_dest = /oracle/PRD/saptrace/usertrace
core_dump_dest = /oracle/PRD/saptrace/background
remote_os_authent = true
#transaction_auditing = FALSE
#retention time for RMAN backup information in control file
control_file_record_keep_time = 30
#include additional parameters
IFILE = /oracle/PRD/102_64/dbs/init_1020.ora
IFILE = /oracle/PRD/102_64/dbs/initora.addon
shared_pool_size = 796917760
shared_pool_reserved_size = 79691776
pga_aggregate_target = 796917760
sga_max_size = 1195376640
db_cache_size = 597688320
control_files = ( /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf,/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf,/oracle/PRD/saparch/cntrl/cntrlPRD.dbf )
Edited by: Mohd Zaki Ahmad Zaini on Feb 14, 2008 1:57 PM
Edited by: Mohd Zaki Ahmad Zaini on Feb 14, 2008 2:45 PM
Before this i use this init.ora
replace DEFAULT with your database name
db_name=DEFAULT
db_files = 80 # SMALL
db_files = 400 # MEDIUM
db_files = 1500 # LARGE
#db_file_multiblock_read_count = 8 # SMALL
db_file_multiblock_read_count = 16 # MEDIUM
db_file_multiblock_read_count = 32 # LARGE
db_block_buffers = 100 # SMALL
#db_block_buffers = 550 # MEDIUM
db_block_buffers = 3200 # LARGE
#shared_pool_size = 3500000
shared_pool_size = 123232153 # SMALL
shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 9000000 # LARGE
log_checkpoint_interval = 10000
processes = 50 # SMALL
processes = 100 # MEDIUM
processes = 200 # LARGE
parallel_max_servers = 5 # SMALL
parallel_max_servers = 4 x (number of CPUs) # MEDIUM
parallel_max_servers = 4 x (number of CPUs) # LARGE
log_buffer = 32768 # SMALL
log_buffer = 32768 # MEDIUM
log_buffer = 163840 # LARGE
audit_trail = true # if you want auditing
timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = TRUE
define two control files by default
control_files = (ora_control1, ora_control2)
Which one is usefull to solve this issues??
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.