on 04-20-2007 7:33 AM
I have a XI SAP system installed in Windows-NT with Oracle. Now after a power failure this SAP system is not able to start anymore. Oracle is running in the system properly, but SAP system can't able to connect to the database.
SQL> conn /as sysdba
ERROR:
ORA-01031: insufficient privileges
And when giving R3trans -d it gives O/P as :
This is r3trans version 6.14
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o
ra_tnsname = <SID>
r3trans finished (0012).
But from SAPMMC it can be seen that Message service and IGS Watchdog service is running properly but Dispatcher is not running. From syslog it is showing "DB connect failed ".
Can anybody help me in this regard, how to get back the system working properly......
thanks.
Hi Arunava,
As fas the error is seen it something to deal with the priviledges.
Please Logon to the system with the admininstrator right and to oracle as dbadmin.
Hope this will give you a direction!!!!
Regards,
Prashil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have fixed it. The problem was in the SQLNET.ORA file. The parameter value was SQLNET.AUTHENTICATION_SERVICE = (NONE). As I set it to NONE, it started to work. I am now able to connect to database as sysdba form <sid>adm. Thanks for your answers, it shows some way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I got the problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure your self database is up & Opened .
login as <SID>adm
sqlplus " / as sysdba"
shutdown immediate;
startup;
if it is started & opened - no issues from database.Confirm is your startup is succesfully opened the database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
check your dev_wxxxx log,
if it shows like "system can't find the database "XYZ", if MSSQL is running, either the DB instance do not exist or is not configure properly, to check if the instance exist in SQL simple open the Enterprise manager and check that the XYZ instance is on the list, if the DB exist
.. You can check it in the SERVICES window in your Windows Control Panel --> Administration --> Services also
reward points if it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.