Friday, August 8, 2008

ORA-09275

 Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

===================================================================


ORA-09275 : Connect internal is not a valid DBA connection
Cause: CONNECT INTERNAL is no longer supported for DBA connections.
Action: If NTS is enabled, you can connect to the database as CONNECT / AS SYSDBA or CONNECT / AS SYSOPER. If NTS is not enabled, you can connect as CONNECT SYS AS SYSDBA. You can also connect as an existing user with the appropriate password.
Note:
CONNECT INTERNAL and CONNECT INTERNAL/PASSWORD are not supported in Oracle9i. Instead, the following are the exact equivalents:
CONNECT/ as SYSDBA
CONNECT username/password AS SYSDBA
% sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 8 10:02:13 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect internal
Enter password:
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
SQL> conn / as sysdba
Connected.
SQL>
Last updated: August 24, 2009
All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors