OraFAQ Forum: RAC & Failsafe » Finding the mode of server.......!

Home » Server Options » RAC & Failsafe » Finding the mode of server.......! (

) 2 Votes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Finding the mode of server.......! [message #117215]

Mon, 25 April 2005 15:53

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

Report message to a moderator

Re: Finding the mode of server.......! [message #117302 is a reply to message #117215]

Tue, 26 April 2005 06:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

If you're on a 9i+ database, check the documentation:

It has been replaced by 'IS_CLUSTER_DATABASE'.

MHE

Report message to a moderator

Re: Finding the mode of server.......! [message #117319 is a reply to message #117215]

Tue, 26 April 2005 08:44

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

Report message to a moderator

Re: Finding the mode of server.......! [message #117441 is a reply to message #117319]

Wed, 27 April 2005 06:28

Maaher
Messages: 7065
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

Report message to a moderator

Re: Finding the mode of server.......! [message #117481 is a reply to message #117441]

Wed, 27 April 2005 08:43

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

Report message to a moderator

Re: Finding the mode of server.......! [message #117624 is a reply to message #117481]

Thu, 28 April 2005 09:56

Frank Naude
Messages: 4581
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

Report message to a moderator

Re: Finding the mode of server.......! [message #117650 is a reply to message #117624]

Thu, 28 April 2005 14:23

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai frank,
still i get that error.what to do ..?

bala

Report message to a moderator

Re: Finding the mode of server.......! [message #117658 is a reply to message #117650]

Thu, 28 April 2005 14:47

Frank Naude
Messages: 4581
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 13:05:21 CST 2024