ORA-01031: insufficient privileges getting After upg. oracle from 8i to 9i

[Former Member]

Hi,

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\s47adm>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.7.0 - Production on Thu Apr 9 19:20:10 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name: system

Enter password:

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Enter user-name:

*The above happened after successfully upgraded oracle from 8i to 9i. After upgrade assistant successfully completed then its giving above error. Please help ASAP.

[Former Member · Accepted solution]

Hello

Try this notes 175636 and 480266,they will be useful

Rohit

[Former Member]

Rohit,

Thanks for your reply.

Its solved.....I just changed NTS in place of NONE in the below line of sqlnet.ora file.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

With Regards,

Krishna.