on 05-31-2008 11:29 AM
hi frnds,
i made parameter settings in the spfile as,
ALTER SYSTEM SET parallel_threads_per_cpu=2 SCOPE=SPFILE;
commit;
ALTER SYSTEM SET parallel_max_servers=10 SCOPE=SPFILE;
commit;
ALTER SYSTEM SET replication_dependency_tracking=TRUE SCOPE=SPFILE;
commit;
now from the next second the ides server dispatcher is stopped.
the server is not getting up.
i want to delete these parameters completely from the database.
which command is used to delete these parameters from the database so that i can make the server up.
it's really urgent...................
thanks markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
"Urgent" is a word that is not wanted here, check the forum rules. Urgent calls should be handled via OSS.
i made parameter settings in the spfile as,
ALTER SYSTEM SET parallel_threads_per_cpu=2 SCOPE=SPFILE;
commit;
ALTER SYSTEM SET parallel_max_servers=10 SCOPE=SPFILE;
commit;
ALTER SYSTEM SET replication_dependency_tracking=TRUE SCOPE=SPFILE;
commit;
now from the next second the ides server dispatcher is stopped.
the server is not getting up.
The server or the database? What do you see in your Oracle alert.log?
i want to delete these parameters completely from the database.
_which command is used to delete these parameters from the database so that i can make the server up.
you can´t "delete" them -you can just reset them to the values they have been before.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.