Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

Access is denied when importing data from Oracle 11g for configuring Data source


#1

Hi,

I am trying to install Cognos 10 on my windows 7 machine for learning purpose.

it is running on localhost. (http://localhost/cognos). and i have installed Oracle 11g.

now i am configuring Data source and sample configuration.

when i run a windows batch file named setupGSDB which is in under package of sample Oracle data source in Cognos.

this open a cmd prompt. it asks for oracle instance, login as sysdba to import the data for GoSales sample data.

i gave oracle instance: orcl, admin user name & password: system as sysdba

it shows:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Importing data
Access is denied.

Granting cross schema privileges
Access is denied.
Access is denied.
Access is denied.
Creating primary keys
Access is denied.
Creating indexes
Access is denied.
Creating constraints
Access is denied.
Creating views
Access is denied.
Creating stored procedures
Access is denied.
Granting permissions
Access is denied.
Updating statistics
Access is denied.
Verifying row counts
Access is denied.
Press any key to continue . . .

please advice how i import the data.

Thanks.