cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-25138

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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)

Former Member
0 Kudos

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

Former Member
0 Kudos

What version install? Describe more precisely. The old problems DBCREATEDB_IND_ORA check in note 372205

Former Member
0 Kudos

Im doing DBMIG.R3S to 4.6c SR2 10g oracle....

if u need file i will post it here....

Former Member
0 Kudos

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.

Former Member
0 Kudos

Check the listner may be it not active.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

markus_doehr2
Active Contributor
0 Kudos

The database seems to have crashed.

Check your alert<SID>.log.

Markus

Former Member
0 Kudos

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 ....

markus_doehr2
Active Contributor
0 Kudos

Your logfile says:

ERROR at line 1:

ORA-01034: ORACLE not available

Do you use the procedure described in Note 946141 - Inst. SAP Systems on UX/Oracle 10.2 with R3SETUP

Markus

Former Member
0 Kudos

Here my init .ora

please guy..

  1. replace DEFAULT with your database name

db_name=DEFAULT

db_files = 80 # SMALL

  1. db_files = 400 # MEDIUM

  2. db_files = 1500 # LARGE

  1. db_file_multiblock_read_count = 16 # MEDIUM

  2. db_file_multiblock_read_count = 32 # LARGE

#db_block_buffers = 550 # MEDIUM

  1. db_block_buffers = 3200 # LARGE

#shared_pool_size = 3500000

shared_pool_size = 123232153 # SMALL

  1. shared_pool_size = 5000000 # MEDIUM

  2. shared_pool_size = 9000000 # LARGE

log_checkpoint_interval = 10000

processes = 50 # SMALL

  1. processes = 100 # MEDIUM

  2. processes = 200 # LARGE

parallel_max_servers = 5 # SMALL

  1. parallel_max_servers = 4 x (number of CPUs) # MEDIUM

  2. parallel_max_servers = 4 x (number of CPUs) # LARGE

log_buffer = 32768 # SMALL

  1. log_buffer = 32768 # MEDIUM

  2. log_buffer = 163840 # LARGE

  1. audit_trail = true # if you want auditing

  2. timed_statistics = true # if you want timed statistics

max_dump_file_size = 10240 # limit trace file size to 5 Meg each

  1. Uncommenting the line below will cause automatic archiving if archiving has

  2. been enabled using ALTER DATABASE ARCHIVELOG.

  3. log_archive_start = true

  4. log_archive_dest = disk$rdbms:[oracle.archive]

  5. log_archive_format = "T%TS%S.ARC"

  1. If using private rollback segments, place lines of the following

  2. form in each of your instance-specific init.ora files:

  3. rollback_segments = (name1, name2)

  1. If using public rollback segments, define how many

  2. rollback segments each instance will pick up, using the formula

  3. # of rollback segments = transactions / transactions_per_rollback_segment

  4. In this example each instance will grab 40/5 = 8:

  5. transactions = 40

  6. transactions_per_rollback_segment = 5

  1. Global Naming -- enforce that a dblink has same name as the db it connects to

global_names = TRUE

  1. Edit and uncomment the following line to provide the suffix that will be

  2. appended to the db_name parameter (separated with a dot) and stored as the

  3. global database name when a database is created. If your site uses

  4. Internet Domain names for e-mail, then the part of your e-mail address after

  5. the '@' is a good candidate for this parameter value.

  1. db_domain = us.acme.com # global database name is db_name.db_domain

  1. FOR DEVELOPMENT ONLY, ALWAYS TRY TO USE SYSTEM BACKING STORE

  2. vms_sga_use_gblpagfil = TRUE

  1. FOR BETA RELEASE ONLY. Enable debugging modes. Note that these can

  2. adversely affect performance. On some non-VMS ports the db_block_cache_*

  3. 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

  1. define parallel server (multi-instance) parameters

#ifile = ora_system:initps.ora

  1. define two control files by default

control_files = (ora_control1, ora_control2)

  1. Uncomment the following line if you wish to enable the Oracle Trace product

  2. to trace server activity. This enables scheduling of server collections

  3. from the Oracle Enterprise Manager Console.

  4. Also, if the oracle_trace_collection_name parameter is non-null,

  5. every session will write to the named collection, as well as enabling you

  6. to schedule future collections from the console.

  1. oracle_trace_enable = TRUE

  1. Uncomment the following line, if you want to use some of the new 8.1

  2. features. Please remember that using them may require some downgrade

  3. actions if you later decide to move back to 8.0.

#compatible = 8.1.0

markus_doehr2
Active Contributor
0 Kudos

And check also note 980981 - SysCopy: SAP Systems with EXT Kernel & Oracle 10.2 (R3SETUP)

(which uses a different CD).

Markus

Former Member
0 Kudos

yeah markus im using this note to run the R3SETUP

946141 (Inst. SAP Systems on UX/Oracle 10.2 with R3SETUP) and

when the DBCREATE phase i encounter error...might be the inti.ora but still don't know which cause that error come...please...

former_member204746
Active Contributor
0 Kudos

try this:

sqlplus "/ as sysdba"

shutdown abort

startup nomount

then, try again

Former Member
0 Kudos

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;

former_member204746
Active Contributor
0 Kudos

in file init.ora, comment out this line (put a # before it):

db_block_buffers = 3200 # LARGE

then, shutdown abort.... then try again.

Former Member
0 Kudos

I'm say about this db_block_buffers check note 579540 , Probably inattentively read..

Thanks and regards.

Former Member
0 Kudos

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

Former Member
0 Kudos

Before this i use this init.ora

  1. replace DEFAULT with your database name

db_name=DEFAULT

db_files = 80 # SMALL

  1. db_files = 400 # MEDIUM

  2. db_files = 1500 # LARGE

#db_file_multiblock_read_count = 8 # SMALL

  1. db_file_multiblock_read_count = 16 # MEDIUM

  2. db_file_multiblock_read_count = 32 # LARGE

db_block_buffers = 100 # SMALL

#db_block_buffers = 550 # MEDIUM

  1. db_block_buffers = 3200 # LARGE

#shared_pool_size = 3500000

shared_pool_size = 123232153 # SMALL

  1. shared_pool_size = 5000000 # MEDIUM

  2. shared_pool_size = 9000000 # LARGE

log_checkpoint_interval = 10000

processes = 50 # SMALL

  1. processes = 100 # MEDIUM

  2. processes = 200 # LARGE

parallel_max_servers = 5 # SMALL

  1. parallel_max_servers = 4 x (number of CPUs) # MEDIUM

  2. parallel_max_servers = 4 x (number of CPUs) # LARGE

log_buffer = 32768 # SMALL

  1. log_buffer = 32768 # MEDIUM

  2. log_buffer = 163840 # LARGE

  1. audit_trail = true # if you want auditing

  2. timed_statistics = true # if you want timed statistics

max_dump_file_size = 10240 # limit trace file size to 5 Meg each

  1. Global Naming -- enforce that a dblink has same name as the db it connects to

global_names = TRUE

  1. define two control files by default

control_files = (ora_control1, ora_control2)

Which one is usefull to solve this issues??

Former Member
0 Kudos

The second init.ora contains at least one serious error --> db_name=DEFAULT , And in general this ini the file is not similar on working.....

Former Member
0 Kudos

so which init i must use???i alreday use the second init which i edit DEFAULT to PRD but still encounter the same error.Please...guru assist me guide to solve this...

Former Member
0 Kudos

This problem solve already....

Cause the DBMIG.R3S read the init.ora file from /usr/sap/R3SETUP folder not read from /oracle/SID/102_64/dbs and i comment the parameter not related...

Thanks guy...