ITPub博客

First make sure the TNS listener and other database services are started in the services control panel, then choose one of the following methods.C:>set ORACLE_SID = S01 before connectingEdit registration. Type regedit in command line, to HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0, change the variance ORACLE_SID to your database sid (From sap forums)Right click ‘my computer’, propertiesà advancedà environmental variancesàsystem variancesà new name=oracle_sid, value=your database sid (From sa

First make sure the profile includes the parameter: login/no_automatic_user_sapstar = 0, which means in a client, user sap* will be created automatically if there is no user sap* in this client.Then delete the user sap* from the user table in sqlplus in command environment, the commands are as following:C:>set ORACLE_SID = S01C:>sqlplus /nologSQL*Plus: Release 9.0.1.0.1 - Production on 星期三 1月 12 19:42:08 2005(c) Copyright 2001 Oracle Corporation. All rights reserved.SQL> connect / a

The Oracle TNS Listener should be started New domain installation and uninstalling make the users and the system name differentUpgrade the kernel to be latest (From sap forums)Virtual memory should be large enough (From sap forums)Many other reasons, the most frequent result is reinstalling the system, %&^%$%$^[@more@]