|
-
i have installed oracle 8.1.6 on windows2000. though it was working fine but recently whenever i try to start the oracle service thru services panel of windows 2000 it is unable to start the service and is throwing the following error
-------------------------------
Could not start the OracleServiceANDY2 service
Error 1053:the service did not respond to the start or control request in a timely fashion
---------------------------------------
kindly give a way out.
thanx
Aniruddha Gupta
-
solution
Hi, 28th May 2001 18:28 hrs chennai
I also had the simillar problem.
The real problem is with o/s win2000.I had several times this problem on many win2000+oracle systems.
There is also no use of removing and adding new service also.
Try this first
check or ensure it in control panel==>services==>oracleservice==>properties==>log on(property page)==>local system account==> It is Uncheked.==>apply(save).
Try this else
The only solution is you have to do a clean reinstallation of o/s and oracle on that.
Again it is not 100% guranteed soon you may have a problem ||rly.The best to install Oracle on NT.
Installing win2000 Patches
or installing oracle for win2000.
Look in to this links for the problems i had on win2000.
http://www.dbasupport.com/forums/sho...?threadid=9950
http://www.dbasupport.com/forums/sho...8&pagenumber=2
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
Re: solution
Hi, 28th May 2001 18:53 hrs chennai
Try this out.
Go to SVRMGRL try to startup in normal or force it will work but once shutdown again startup the same problem will persist.
Cheers
padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
hi padmam,
thanks for your reply but again i am having some problems .....
whenever i am executing a PL/SQL for which i am using dbms_output.put_line('some message') for which i have to use SET SERVEROUTPUT ON. after setting when i try to execute the PL/SQL block it returns the error given below ,
this error persists till i issue
SET SERVEROUTPUT OFF
it returns same error while performing any DML operation
however please note select runs perfectly
the error is given below
--------------------------------------------
SQL> insert into emp(empno,ename,deptno)
2 values(1,'q',10);
ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
1 row created.
-----------------------------------------------------
regds
Aniruddha Gupta
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|