Capacity Manager - Initial troubles

Toad for Oracle & DevOps Toolkit
1

I have installed Capacity Manager trial v1.3.3.52 but I am not able to run it. Let me explain.

1.) When I try to start CM I get some error messages:

but by pressing I am able to continue and Repository Wizard shows up,

asking me for database and the owner of the repository. I wpuld like that the user

TOAD be the owner, so I enter user TOAD and . But whatewe i do I get the same error message:

User TOAD has all possible privileges, including DBA. I granted DBA, ALL and ALL PRIVILEGES to user TOAD via TOAD Shema

Browser, via TOAD Editor and via SQL*Plus, but no results.

I get the same error message about DBA privileges if I try to run Space Manager

Any idea ??

Thank you and best regards!

2

Sorry, I have included some screen shots, but they are not there. The main error message id that user TOAD has no DBA privileges.

By the way, how can include screen shots to the post ??

Also, my environment is CM on Windows 7 and ORACLE 11gR2 on Linux 5

Regards!

3

I don’t think we have an Oracle product by that name and version (at least not still current). Your images did not post so I cannot see what you’re talking about.

4

email your screen snapshots offline at bert.scalzo@quest.com

5

Hello Bert

The official is Quest Capacity Manager for Oracle v1.3.3.52. I would like to send you some screen shots but do not know how.

Regards!

6

email me offline - and tell me where you got this product. I know we had a capacity manager for oracle years ago (different than our space manager product - which is 8.01 release).

7

Thank you Bert, I will compose an e-mail shortly.

8

I found capacity manager - it’s part of space manager - which you did not mention. I will try that now and see if I have the same problems as you.

9

Bert, my environment is CM and Space Manager on Win 7 46bit and 32bit Ora Client 11g, Oracle is 11gR2 on Linux 5.

10

I am setting up an identical set of system. I tried it once and it worked no problem. But I am going to repeat the experiment to be sure - Linux VM unzipping as I type. For me the CM installed into Toad schema without problem - so I will try again with clean setup just to make sure. Here was how I created my toad user:

SQL> create user toad identified by toad default tablespace users temporary tablespace temp;

User created.

SQL> grant connect, resource, dba to toad;

Grant succeeded.

SQL> grant unlimited tablespace to toad;

Grant succeeded.

11

OK - I emailed you screen snapshots. It works fine for me. Same setup exactly - including 11g R2 on Linux 5. It ran without problem. Three things to check. Did you:

  • grant connect, resource, dba to toad;

  • grant unlimited tablespace to toad;

  • did you review toad user DDL to verify these items

here is the toad schema browser script tab for my toad user:

DROP USER TOAD CASCADE;

CREATE USER TOAD

IDENTIFIED BY

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

– 3 Roles for TOAD

GRANT CONNECT TO TOAD;

GRANT DBA TO TOAD;

GRANT RESOURCE TO TOAD;

ALTER USER TOAD DEFAULT ROLE ALL;

– 11 System Privileges for TOAD

GRANT CREATE DATABASE LINK TO TOAD;

GRANT CREATE JOB TO TOAD;

GRANT CREATE PROCEDURE TO TOAD;

GRANT CREATE SEQUENCE TO TOAD;

GRANT CREATE SESSION TO TOAD;

GRANT CREATE TABLE TO TOAD;

GRANT CREATE TRIGGER TO TOAD;

GRANT CREATE TYPE TO TOAD;

GRANT CREATE VIEW TO TOAD;

GRANT SELECT ANY DICTIONARY TO TOAD;

GRANT UNLIMITED TABLESPACE TO TOAD;

– 1 Tablespace Quota for TOAD

ALTER USER TOAD QUOTA UNLIMITED ON USERS;

Bert

12

Thank you Bert. It is already very late in my time zone, so I will check this untill tomorow and let you know. Thank you and best regards!

13

Let me know - I’ll check back tomorrow :slight_smile: