Home » Server Options » RAC & Failsafe » Finding the mode of server.......!  () 2 Votes
Finding the mode of server.......! [message #117215] Mon, 25 April 2005 15:53 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai,
i want to find the mode of the server either shared/exclusive by executing the procedure below

begin
2 if dbms_utility.is_parallel_server then
3 dbms_output.put_line('Running in parallel mode.');
4 else
5 dbms_output.put_line('Running in exclusive mode.');
6 end if;
7 end;
8 /
if dbms_utility.is_parallel_server then
*
ERROR at line 2:
ORA-06550: line 2, column 17:
PLS-00302: component 'IS_PARALLEL_SERVER' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

but still i am getting the errors in this regard.
plz help me out.

regards
bala
Re: Finding the mode of server.......! [message #117302 is a reply to message #117215] Tue, 26 April 2005 06:38 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
If you're on a 9i+ database, check the documentation:

It has been replaced by 'IS_CLUSTER_DATABASE'.

MHE
Re: Finding the mode of server.......! [message #117319 is a reply to message #117215] Tue, 26 April 2005 08:44 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai ,
thanks for ur response.but the problem is we could n't execute the procedure starting with dbms like dbms_utility , dbms_stats in the sql prompt which blows the error that the procedure is not declared which had been given in the previous mail.help out in this issue.

regards
bala
Re: Finding the mode of server.......! [message #117441 is a reply to message #117319] Wed, 27 April 2005 06:28 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Did you check the user's privileges on the given objects?

And are the privileges (if any) granted through a role?

MHE
Re: Finding the mode of server.......! [message #117481 is a reply to message #117441] Wed, 27 April 2005 08:43 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai,

i did n't check up the user's privileges on an user. could u tell how to do so..?

regards
bala
Re: Finding the mode of server.......! [message #117624 is a reply to message #117481] Thu, 28 April 2005 09:56 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

Not sure if this would be helpful, but the code is working fine on my DB:

SQL> CONNECT / AS SYSDBA
Connected.
SQL>
SQL> SET SERVEROUTPUT ON
SQL>
SQL> BEGIN
  2    IF dbms_utility.is_cluster_database THEN
  3       dbms_output.put_line('Running in parallel mode.');
  4    ELSE
  5       dbms_output.put_line('Running in exclusive mode.');
  6    END IF;
  7  END;
  8  /
Running in parallel mode.

PL/SQL procedure successfully completed.


Best regards.

Frank
Re: Finding the mode of server.......! [message #117650 is a reply to message #117624] Thu, 28 April 2005 14:23 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai frank,
still i get that error.what to do ..?

bala
Re: Finding the mode of server.......! [message #117658 is a reply to message #117650] Thu, 28 April 2005 14:47 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
What error? Did you change the script as Maaher suggested? Maybe it's time for you to call in a consultant to assist you with this problem.

Best regards.

Frank
Previous Topic: Post Installation Step RAC on OCFS
Next Topic: Veritas SFRAC 4.0 MP1 and Oracle 10.1.0.4 on Solaris
Goto Forum:
  


Current Time: Sat Dec 04 20:07:37 CST 2021