If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by singh987, 21 Jul 2016 05:38:05 AM

Previous topic - Next topic

singh987

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.

MFGF

Quote from: singh987 on 21 Jul 2016 05:38:05 AM
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.

Hi,

This sounds like a permissions problem with your Oracle instance - nothing really to do with Cognos at all. Have you made sure that your user is a member of the ora_dba group?

Some ideas here:

https://community.oracle.com/thread/3812970?start=0&tstart=0

MF.
Meep!

singh987

Hi Sir,

Thanks for reply.

I have checked ora_dba group under Local Users and Groups in Computer Management in Windows.

SYSTEM user are exist there. but i am not able to import the sample data using SYSTEM user.

Thanks.


MFGF

Quote from: singh987 on 21 Jul 2016 07:17:06 AM
Hi Sir,

Thanks for reply.

I have checked ora_dba group under Local Users and Groups in Computer Management in Windows.

SYSTEM user are exist there. but i am not able to import the sample data using SYSTEM user.

Thanks.

Have you tried adding the user you are logged in as?

MF.
Meep!

singh987

Hi Sir,

when i click to ora_dba (Oracle DBA Group) in Computer Management, it shows two members:

- NT AUTHORITY\SYSTEM
- kumar

kumar is my windows user name


i have also tried to import the data with kumar user and give the admin password (this admin password i gave during installation of Oracle 11g) but same issue exist.

Thanks.

MFGF

Quote from: singh987 on 21 Jul 2016 07:50:30 AM
Hi Sir,

when i click to ora_dba (Oracle DBA Group) in Computer Management, it shows two members:

- NT AUTHORITY\SYSTEM
- kumar

kumar is my windows user name


i have also tried to import the data with kumar user and give the admin password (this admin password i gave during installation of Oracle 11g) but same issue exist.

Thanks.

Hi,

I'm out of ideas, sorry. I'm not very fluent with Oracle to be able to suggest further. I'd suggest you do some internet searches based on the "Access is denied" errors you are getting in Oracle. Maybe you could try an Oracle forum?  As I mentioned earlier, this is nothing to do with Cognos - it's an Oracle issue. You may get lucky and find someone answers on Cognoise based on their Oracle experience, but most people on here specialise in Cognos so it's not guaranteed anyone on this forum will know what your issue is.

Good luck!

MF.
Meep!

Kiran P

I am also not an Oracle guy but below are two things you can try

1) ensure all services (oracle,cognos) are running under local system account with administrator access
2) run the applications (CMd prompt , oracle, FM etc ) as administrator I.e while opening these , right click on the respective exe and choose Run As Administrator

It is really a permission problem and you should look in that direction for any cues.

Thanks
Kiran

singh987

Thanks MFGF and kpassumarthi.

I have give the Full Control permission on sample Oracle data source folder under my user account.

Issue is resolved.