Thanks for the reply,you have shown me the link is helpful to me

Hi Christian Berg, You are correct,i tried in my local system by adding BI Adminstrator role all the users getting the previleges in that group ,but here i noticed one thing is when i login with Admin username and password he lost analysis previleges,what is the correct procedure,please let me know. Thanks, Sateesh

Thank you Michael that blog is helped me a lot,but i am facing some issues while implementing security I have created role for my testing purpose :Role :BI MANAGER Group:BI MANAGER_WL Users: Ravi,viswa,sateesh (3 users) i assigned 3 users to group and i added group to role .upto here is perfect. i have one subject area--SH…

i installed 11 g version,where can we check log file.please let me know

Hi Andrew Fomin, Issue is resolved,i configured new TNS Listener. We can find the solution here as per ASKTOM: https://asktom.oracle.com/pls/apex/f?p=100:12:110624418312814::NO::: Thanks for your support and guidance and support. Thanks, Sateesh

Hi Andres Fomin, Problem got solved,I have configured new TNS Listener and started that listener in windows services. Thanks for your support and guidence to all. Thanks, Sateesh

When i am starting oracleoradb11g_home1 tns listener it is throwing up an error please find above i had already attached.

Yes correct. oracleoradb11g_home1 listener

please help me experts,how to solve this please.

Thanks for the quick reply,i tried to start the listener in services but it is throwing error ,please find the screen short

Yes.please find the tnsnames. ORCL123 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL123) )

I logging on to DB via SQL*PLUS the following are the credentials. supervisor :sys as sysdba password: Sysdba123

Thanks for the quick reply. even i put username: 'SYS' throwing the same error

Hi Gianni Ceresa, Please find the attached screen short.

Hi Christian Berg, Thanks for your guidence,let me start to learn obia. Thanks, Ksbabu

Hi Christian Berg, I asked for my ETL. Thanks, ksbabu