oracle 10 to 11g

[Former Member]

Dear Experts,

                 I am upgrading oracle 10 to 11 on windows 2008 server .I am facing following error during upgrade .I m not able to start sqlplus too,

[REDACTED BY MODERATOR]

Regards,

Sahil

[Former Member]

Hi Sahil,

Please do following step.

1. select property_value from database_properties where property_name like '%DEFAULT_TEMP_TABLESPACE%';

Say the default tablespace name is TEMP

2. Select name from v$tempfile;

If output is "no row selected" then ;

3. Alter tablespace TEMP add tempfile 'LOCATION\NAME.DBF' size 1024m autoextend on;

Thanks,

Manas

[Former Member]

This message was moderated.

[Former Member]

Hi Sahil,

The first error show that the database does not have a temporary database. Please add a temp tablespace by the procudure, below;

Header 1
CREATE TEMPORARY TABLESPACE "PSAPTEMP1" TEMPFILE '/oracle/<DBSID>\sapdata<x>\temp_<y>\TEMP.DATA<y>' SIZE <size>M reuse autoextend off;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP1;
DROP TABLESPACE PSAPTEMP INCLUDING CONTENTS;
CREATE TEMPORARY TABLESPACE "PSAPTEMP" TEMPFILE '/oracle/<DBSID>\sapdata<a>\temp_<b>\TEMP.DATA<b>' SIZE <size>M reuse autoextend off;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;
DROP TABLESPACE PSAPTEMP1 INCLUDING CONTENTS;

For the further information, check Note 600513 - ORA-25153 after recovery due to missing tempfiles

For the second error, check the further logs to identify the problem.

Best regards,

Orkun Gedik

[Former Member]

Thanks a lot sir,

      I am not able to logon from sqlplus.

Microsoft Windows [Version 6.0.6001]

Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 19 11:41:02 2013

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

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1336176640 bytes

Fixed Size                  2254984 bytes

Variable Size             671090552 bytes

Database Buffers          637534208 bytes

Redo Buffers               25296896 bytes

Database mounted.

ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> startup

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL> startup

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

SQL>

Pls do needful.

[former_member184473]

Hello Sahil.

The error ORA-01041 is usually generated after termination of the communications connection between a client process and the database.

Check if you have SQLNET.AUTHENTICATION_SERVICES= (NTS) in sqlnet.ora and comment out.

Did you notice another Oracle errors on sqlnet.log and Alert.log?

Regards,

Eduardo

[former_member188883]

Hi Sahil,

Could you please upgrade the SAP kernel and take reboot of the Windows server.

There are cases of such ora errors due to semaphore errors.

Post this check the results .

Regards,

Deepak Kori

[former_member184473]

Hello Sahil,

Have you checked and performed all the steps from the following note?

1431793 - Oracle 11.2.0: Upgrade Scripts

Regards,

Eduardo Rezende