32 to 64 bit Oracle.

[Former Member]

Hello Colleagues. I'm have a problem and can't understand that's wrong ...

I'm trying Homogeneous System copy win 32 to 64 , ERP SR3 Central system ABAP+JAVA with Backup/Reastore ... The Source system are installed by Consultant team and i can't change any settings in any component on system in this time ...

I'm generate the control.sql on source system, load the JAVA part.

On Target system i'm install the Oracle 10.2.0.2 Bundle patches. Start sapins with requred system copy

paths, after sapinst ask's the restore database and all files (per SYS COPY GUIDE), i'm copy oll files with same drives and names, copy the control.sql and init_TARGET.ora to required destinations.

After i will see error :

CJS-00084  SQL statement or script failed. DIAGNOSIS: Error message: ORA-02778: Name given for the log directory is invalid
CREATE CONTROLFILE REUSE
*
ERROR at line 1:
ORA-01034: ORACLE not available


ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01034: ORACLE not available


ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'D:\ORACLE\SID\SAPDATA2\TEMP_1\TEMP.DATA1'
*
ERROR at line 1:
ORA-01034: ORACLE not available


ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
ORA-02778: Name given for the log directory is invalid.

I'm checking all paths and directories on initSID.ora , all are correct,

*._OPTIM_PEEK_USER_BINDS=FALSE
*.background_dump_dest='D:\oracle\SID\saptrace\background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='D:\oracle\SID\sapdata1\cntrl\cntlrSID.dbf','D:\oracle\SID\sapdata2\cntrl\cntrlSID.dbf','D:\oracle\SID\sapdata3\cntrl\cntrlSID.dbf'
*.core_dump_dest='D:\oracle\SID\saptrace\background'
*.db_block_size=8192
*.db_cache_size=314572800
*.db_files=254
*.db_name='SID'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
*.log_archive_dest='D:\oracle\SID\oraarch\SIDarch'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.optimizer_features_enable='10.2.0.1'
*.pga_aggregate_target=419430400
*.processes=80
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.sessions=96
*.sga_max_size=629145600
*.shared_pool_reserved_size=31457280
*.shared_pool_size=314572800
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.statistics_level='typical'
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='D:\oracle\SID\saptrace\usertrace'
*.workarea_size_policy='AUTO'

In alert_SID.log from (D:\oracle\SID\102\RDBMS\trace ) lines only like

Starting ORACLE instance (normal)
Thu Feb 05 20:21:58 2009
Adjusting the default value of parameter parallel_max_servers
from 160 to 65 due to the value of parameter processes (80)
Thu Feb 05 20:21:59 2009
Starting ORACLE instance (normal)
Thu Feb 05 20:57:22 2009
Adjusting the default value of parameter parallel_max_servers
from 160 to 65 due to the value of parameter processes (80)
Thu Feb 05 20:57:22 2009
Starting ORACLE instance (restrict)

Tnslistener are up and running :

Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.2.0 - Production
Start Date                05-FEB-2009 19:50:51
Uptime                    0 days 0 hr. 0 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\SID\102\network\admin\listener.ora
Listener Log File         D:\oracle\SID\102\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SID.WORLDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SIDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server.local)(PORT=1527)))
Services Summary...
Service "SID" has 1 instance(s).
  Instance "SID", status UNKNOWN, has 2 handler(s) for this service...

OracleServiceSID are started to .....

What could be the problem ? Thanks for all answers. Regards.

[Former Member · Accepted solution]

Hello,

the key problem seems to be this error:

ORA-02778: Name given for the log directory is invalid

I suppose you already checked that directory D:\oracle\SID\oraarch is there, and is writeable.

What's a bit strange is this short statement:

CREATE CONTROLFILE REUSE

Is this really all you have?

Usually this line will be followed by other lines, describing log files and data files.

So what is your whole CREATE CONTROLFILE statement?

And by the way, did you call STARTUP NOMOUNT first?

regards

[Former Member · Accepted solution]

Hello Joe Bo the Control.sql starts :

CONNECT / AS SYSDBA

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE
SET DATABASE "SID"
RESETLOGS
ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 1022
MAXINSTANCES 50
MAXLOGHISTORY 11680
LOGFILE
GROUP

e.t.c.

The log

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Feb 5 20:16:39 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

Connected to an idle instance.

ORACLE instance shut down.

Connected to an idle instance.

ORA-02778: Name given for the log directory is invalid

CREATE CONTROLFILE REUSE

*

ERROR at line 1:

ORA-01034: ORACLE not available

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

ORA-01034: ORACLE not available

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'D:\ORACLE\SID\SAPDATA2\TEMP_1\TEMP.DATA1'

*

ERROR at line 1:

ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

ORA-02778: Name given for the log directory is invalid

Yes the D:\oracle\SID\oraarch is there, and is writeable.

Thanks for your time. Regards.

[Former Member · Accepted solution]

Hello Sergo,

so I misunderstood your first post. The ORA-02778 is not caused by the CREATE CONTROLFILE, but already by the STARTUP NOMOUNT.

So I am wondering where there could by a wrong directory.

Another idea about it:

from the '*' at the beginning of the lines in your initSID.ora I gather that this was created from an spfile, and your database actually is using not initSID.ora, but spfileSID.ora. Maybe there is a wrong spfile still there?

regards

[Former Member · Accepted solution]

from the '*' at the beginning of the lines in your initSID.ora I gather that this was created from an spfile

This pfile are created on source system using ora_br_copy.bat per system copy guide, no spfile are here.

I'm trying for testing move this pfile to over directory and SAPINST says correct (your ORACLE_HOME are not correct, ore othe errors like this) i'm trying for example REM by # all lines in initSID.ora , absolutli same error, or for example stop the listener, but the same error ... Strange ...

Fanks for help, Regards.

[Former Member · Accepted solution]

On file system the core_dump_dest='D:\oracle\SID\saptrace\background'

but the folder name by mistacke are D:\oracle\SID\ saptarce

Thanks for time ) Regards