Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

OracleWarehouseBuilder
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Members
  • Calendar
  • Promote

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 537
  • Category: Oracle
  • Founded: Aug 16, 2003
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages
Message #
Search:
Advanced
 Messages Help
Messages
Topics
Hot Topics
Messages 505 - 562 of 23952   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Show Message Summaries Sort by Date ^  
#505 From: "Krishna V K" <vkkrishna@...>
Date: Fri Jan 13, 2006 7:11 am
Subject: Oracle WareHouse builder -Permanent Position Singapore 		vkkrishna
Send Email Send Email
  
We have permanent opening for the LEAD/SENIOR SYSTEMS DEVELOPER
(DATA WAREHOUSING) in Singapore.

Job Scope :
You will be responsible for business requirement analysis, data
warehouse architectural design, development and maintenance of the
Operational Data Store and Data Warehouse. This includes designing
end-to-end Business Intelligence Systems for business activity
monitoring, customer analytics, campaign tracking, site metrics and
developing complex reporting models to meet overall requirements.
This position will work with the BI team, system integrators, DBA's
and Development Engineers to understand data sources, design and
implement new requirements along with maintaining existing DW
system. This person is technically responsible for the quality of
the deliverables, reporting performance and scalability.

Requirements:
The candidate is expected to have at least 5+ years of solid hands-
on experience in:

•Architecting and building large scalable data warehouses
•Logical & physical DW data modeling to satisfy business objectives
•Good knowledge of Hyperion Intelligence, Essbase & Oracle Warehouse
Builder,
•Ability to work independently with minimal supervision
•Proactive attitude, capable of thinking in and out of the box,
generating ideas and solutions
•Team Player with Strong ability to manage multiple priorities,
projects & goals
•Excellent written & oral communication skills, as well as
consultative and presentation skills
•Comfortable in interacting with all levels in the organization, as
well as management and staff from different nationalities

Email to
Krishna V.K
Hastraa Consulting Services Pte Ltd.,
Penthouse Level
Suntec Tower Three
8 Temasek Boulevard
Singapore – 038988
Email :vk.krishna@...
Main : +65 6474 7643
Fax : +65 6866 3636
http://www.hastraa.com

Reply | Messages in this Topic (1)
#506 From: "d_swaroop1" <d_swaroop1@...>
Date: Mon Jan 16, 2006 8:57 am
Subject: Oracle Warehouse Builder 		d_swaroop1
Send Email Send Email
  
I ,SWAROOP DESHMUKH, final year BE(IT) is using Oracle Warehouse
Builder 9.2 for my project. The problem is that the tool stops working
when clicked on OWB client.Only the splash screen of OWB is displayed.
I tried it on Windows XP,Windows 2003 Server.
      I want to know what might be the problem. Suggest a suitable OS
for it.
      Can the Oracle Warehouse Builder for 10g work with Oracle 9i? As
it is available for download on Oracle.com.
      Waiting for your reply......
thanks...

Reply | Messages in this Topic (4)
#507 From: Cutolo Angelo <angelo_cutolo@...>
Date: Mon Jan 16, 2006 9:15 am
Subject: Re: Oracle Warehouse Builder 		angelo_cutolo
Send Email Send Email
  
Swaroop,
   yes you can download OWB 10g Release 1 (10.1.0.4) at:
   http://www.oracle.com/technology/software/products/warehouse/index.html
   I've installed it on Oracle DB 9.2 and it works fine...

   K.R.

   Angelo

d_swaroop1 <d_swaroop1@...> ha scritto:
   I ,SWAROOP DESHMUKH, final year BE(IT) is using Oracle Warehouse
Builder 9.2 for my project. The problem is that the tool stops working
when clicked on OWB client.Only the splash screen of OWB is displayed.
I tried it on Windows XP,Windows 2003 Server.
      I want to know what might be the problem. Suggest a suitable OS
for it.
      Can the Oracle Warehouse Builder for 10g work with Oracle 9i? As
it is available for download on Oracle.com.
      Waiting for your reply......
thanks...





Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------






---------------------------------
Yahoo! Mail: gratis 1GB per i messaggi, antispam, antivirus, POP3

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (4)
#508 From: "Nitesh" <niteshkumar_2222@...>
Date: Mon Jan 16, 2006 12:48 pm
Subject: Re: Oracle Warehouse Builder 		niteshkumar_...
Send Email Send Email
  
Hi,


Its a know problem with OWB 9.2.0.2.8. Download and Install the patch 9.2.0.4.
Then go to help -> about, and see if the version has been upgraded to 9.2.0.4


Regards


Nitesh

OracleWarehouseBuilder@yahoogroups.com wrote:

I ,SWAROOP DESHMUKH, final year BE(IT) is using Oracle Warehouse
Builder 9.2 for my project. The problem is that the tool stops working
when clicked on OWB client.Only the splash screen of OWB is displayed.
I tried it on Windows XP,Windows 2003 Server.
      I want to know what might be the problem. Suggest a suitable OS
for it.
      Can the Oracle Warehouse Builder for 10g work with Oracle 9i? As
it is available for download on Oracle.com.
      Waiting for your reply......
thanks...





Join
http://www.smartgroups.com/groups/Datawarehouse




SPONSORED LINKS



Oracle 10g
Oracle database
Oracle 8i database

Oracle database administration
Oracle database administrator
Oracle database software



YAHOO! GROUPS LINKS


  Visit your group "OracleWarehouseBuilder" on the web.

  To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




Indiatimes Email now powered by APIC Advantage. Help!
Help



[Non-text portions of this message have been removed]

Reply | Messages in this Topic (4)
#509 From: "Nitesh" <niteshkumar_2222@...>
Date: Mon Jan 16, 2006 12:55 pm
Subject: Re: Oracle Warehouse Builder 		niteshkumar_...
Send Email Send Email
  
Hi


Its a know problem with OWB 9.2.0.2.8. Download and install the patch 9.2.0.4.
After applying the patch, go to help -> About and check the version, it
should be 9.2.0.4. This will solve your problem.


Regards


Nitesh

OracleWarehouseBuilder@yahoogroups.com wrote:

I ,SWAROOP DESHMUKH, final year BE(IT) is using Oracle Warehouse
Builder 9.2 for my project. The problem is that the tool stops working
when clicked on OWB client.Only the splash screen of OWB is displayed.
I tried it on Windows XP,Windows 2003 Server.
      I want to know what might be the problem. Suggest a suitable OS
for it.
      Can the Oracle Warehouse Builder for 10g work with Oracle 9i? As
it is available for download on Oracle.com.
      Waiting for your reply......
thanks...





Join
http://www.smartgroups.com/groups/Datawarehouse




SPONSORED LINKS



Oracle 10g
Oracle database
Oracle 8i database

Oracle database administration
Oracle database administrator
Oracle database software



YAHOO! GROUPS LINKS


  Visit your group "OracleWarehouseBuilder" on the web.

  To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




Indiatimes Email now powered by APIC Advantage. Help!
Help



[Non-text portions of this message have been removed]

Reply | Messages in this Topic (4)
#511 From: "danorat" <dan_osullivan@...>
Date: Fri Jan 20, 2006 7:24 pm
Subject: Cannot start or stop runtime platform 		danorat
Send Email Send Email
  
I can start and stop the runtime platform using the
run_service_local.bat, but I cannot do it with the provided sql
scripts like start_services.sql or stop_service.sql.

There is no error message, it just won't work.

Can someone explain this and/or suggest a solution.

Any help greatly appreciated,
Thanks

Reply | Messages in this Topic (1)
#512 From: Dan OSullivan <dan_osullivan@...>
Date: Fri Jan 20, 2006 7:39 pm
Subject: Starting/Stopping Runtime Platform 		danorat
Send Email Send Email
  
I have found that I cannot start or stop the runtime platform using the provided
start_service.sql or stop_service.sql scripts.  I can run the scripts without
error, however the runtime platform does not start.

   The only way I can start/stop the platform is with the run_service_local.bat
file that starts the rtp from the desktop via a java program.

   My question(s) are:
   1) Can anyone explain why I can use the start and stop scripts?

   2) How can I configure the rtp to stay up once it has started?

   Any help is greatly appreciated....
   -D


[Non-text portions of this message have been removed]

Reply | Messages in this Topic (1)
#518 From: "azzkirie" <d.buderbach@...>
Date: Wed Feb 8, 2006 8:26 pm
Subject: OWB market share? 		azzkirie
Send Email Send Email
  
Hi!

does anybody have information of the current market share of OWB?

I read about the Magic quadrant for 2005 from Gartner. There it says
that OWB is in the leading quadrant; in another article I read that
Informatica (about 25%), IBM/Ascential (about 20%) and SAS (about 15%)
are the leaders in the ETL-market.

Reply | Messages in this Topic (2)
#519 From: kamarthi Hampaiah Swamy <swamykamarthi@...>
Date: Thu Feb 9, 2006 7:43 am
Subject: Re: OWB market share? 		swamykamarthi
Send Email Send Email
  
Herr Buderbach,

   Guten tag,

   Danke schon for deine informaztion uber OWB. kanst du senden eine screen shot
   fur Garnter Magic Quandrant. Ich suchen  information in gartner.co aber ich
kan nicht finden .

   Vilen danke
   Swamy!


azzkirie <d.buderbach@...> wrote:
   Hi!

does anybody have information of the current market share of OWB?

I read about the Magic quadrant for 2005 from Gartner. There it says
that OWB is in the leading quadrant; in another article I read that
Informatica (about 25%), IBM/Ascential (about 20%) and SAS (about 15%)
are the leaders in the ETL-market.





Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
  Yahoo! Mail - Helps protect you from nasty viruses.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (2)
#525 From: pasupathi ravipati <pravisk2000@...>
Date: Mon Feb 20, 2006 3:46 pm
Subject: Re: Excellenet opening for Oracle Warehouse Builder 		pravisk2000
Send Email Send Email
  
Silu Bhat,
I am going to Canada on permanent residency status.
Please help me if you have any jobs in Toronto.
Thanks
Ravi
9850971562

--- splanet001 <splanet001@...> wrote:

> Hi,
>
> There is an excellent opening for Oracle BI -ETL.
> Requirement is :
> Experience: 4 ti 6yrs
> Primary ( Essential ) Technical Skills :
> Atleast 2 -3 year on ETL tools like Oracle Warehouse
> Builder,
> Informatica, Data Stage with good knowledge of
> Oracle, PL SQL,
> Proc*C and Shell Scripting;
>
> Secondary  ( Desirable ) Technical Skills:Domain
> experience in BFSI
> is preferred
> Responsibilities:Development, Design, Management of
> Small Teams,
> Responsible for adhering to the internal quality
> processes
>
> Job Location :I-Flex ,Bangalore
>
> Pls hurry,send your resume to
> silu@... for faster
> processing.
>
>
> Regards,
> Silu Bhat
> Shiksha Planet(www.shikshaplanet.com )
> 080-25207051/4
> 93425-27390 / 93425-27301
>
>
>
>
>
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Reply | Messages in this Topic (1)
#528 From: "otavio07" <otavio07@...>
Date: Fri Feb 24, 2006 5:06 pm
Subject: Sequence of import new OWB's objects 		otavio07
Send Email Send Email
  
Dear All,

Always, I receive (from another country) some new versions of
mappings, table definitions , flows , transformations, etc... and I
have to import them in my database.

But, everytime after I import these things, and I enter into a
mapping and see that everything is messy. For example, the new field
of the new mapping is not "linked" with another object. I have to re-
link everything again !

Another example also is after successful importation, all the
locations that I have inside in each module (into properties -->
location tab) disapeared. I have to assign the location for each
module again and again.

My question is : To avoid these kind of problems, what I have to
do ? How is the  sequence that I have to apply in each "import"
process  to avoid these re-work problems ?

Best Regards and thanks in advance,
Otavio Tallarico.
(otavio07@...)

Reply | Messages in this Topic (10)
#529 From: "Sachin Garg" <sachin_garg@...>
Date: Mon Feb 27, 2006 6:16 am
Subject: Re: Sequence of import new OWB's objects 		sachin_garg
Send Email Send Email
  
Otavio,

Ideally, the import sequence should not matter. You can try importing
the independent objects first, like tables, views etc followed by
mappings.

Oracle had published a function called restore earlier on OTN (I'm
sorry i don't have the link) that i have used in the past to fix
similar problems where the links had disappeared upon import. I have
seen the second problem but don't think the restore function takes
care of that. I have had to fix it manually too. You could possibly
write an OMB script for the second one as well if OTN doesn't help
you.

Regards
-Sachin

--- In OracleWarehouseBuilder@yahoogroups.com, "otavio07"
<otavio07@...> wrote:
>
> Dear All,
>
> Always, I receive (from another country) some new versions of
> mappings, table definitions , flows , transformations, etc... and I
> have to import them in my database.
>
> But, everytime after I import these things, and I enter into a
> mapping and see that everything is messy. For example, the new
field
> of the new mapping is not "linked" with another object. I have to
re-
> link everything again !
>
> Another example also is after successful importation, all the
> locations that I have inside in each module (into properties -->
> location tab) disapeared. I have to assign the location for each
> module again and again.
>
> My question is : To avoid these kind of problems, what I have to
> do ? How is the  sequence that I have to apply in each "import"
> process  to avoid these re-work problems ?
>
> Best Regards and thanks in advance,
> Otavio Tallarico.
> (otavio07@...)
>

Reply | Messages in this Topic (10)
#531 From: otavio otavio07 <otavio07@...>
Date: Wed Mar 1, 2006 12:33 pm
Subject: Re: Re: Sequence of import new OWB's objects 		otavio07
Send Email Send Email
  
Dear Sachin,

   Thanks for your help. I forgot the OBMPlus program to help me to write a
script that import step-by-step the sequence of objects that I have to import.

   About (missing modules X missing database links) I'll investigate it in OTN.

   Best Regards,
   Otavio.


Sachin Garg <sachin_garg@...> escreveu:
   Otavio,

Ideally, the import sequence should not matter. You can try importing
the independent objects first, like tables, views etc followed by
mappings.

Oracle had published a function called restore earlier on OTN (I'm
sorry i don't have the link) that i have used in the past to fix
similar problems where the links had disappeared upon import. I have
seen the second problem but don't think the restore function takes
care of that. I have had to fix it manually too. You could possibly
write an OMB script for the second one as well if OTN doesn't help
you.

Regards
-Sachin

--- In OracleWarehouseBuilder@yahoogroups.com, "otavio07"
<otavio07@...> wrote:
>
> Dear All,
>
> Always, I receive (from another country) some new versions of
> mappings, table definitions , flows , transformations, etc... and I
> have to import them in my database.
>
> But, everytime after I import these things, and I enter into a
> mapping and see that everything is messy. For example, the new
field
> of the new mapping is not "linked" with another object. I have to
re-
> link everything again !
>
> Another example also is after successful importation, all the
> locations that I have inside in each module (into properties -->
> location tab) disapeared. I have to assign the location for each
> module again and again.
>
> My question is : To avoid these kind of problems, what I have to
> do ? How is the  sequence that I have to apply in each "import"
> process  to avoid these re-work problems ?
>
> Best Regards and thanks in advance,
> Otavio Tallarico.
> (otavio07@...)
>







Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
  Yahoo! Acesso Grátis
Internet rápida e grátis. Instale o discador agora!

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#536 From: nagu_10870
Date: Tue Mar 7, 2006 1:44 pm
Subject: About Oracle WorkFlow for Job Scheduling using OWB 		nagu_10870
  
hi friends,
              I am Nagendra Kumar. I am doing a project On Warehousing
When i am trying to open Oracle Workfloe from OWB tools I am getting
Eroor As shown
      API5039:Command wfbldr.exe cannot be executed.Verify that the
command is an OS executable.The Os executable file must be in
path.Otherwise provide the executable OS command path.
                I want to know what is that path and what is the error.
so if u have the solution then send that to
              nagu_10870@...

Reply | Messages in this Topic (1)
#538 From: Ravikumar Jonnalagadda <jrk_ravi@...>
Date: Thu Mar 9, 2006 6:09 am
Subject: View Problem 		jrk_ravi
Send Email Send Email
  
Hi All


   I am having aproblem with OWB now . please respond ASAP.
   I ahve some VIews in Schema called test_schema
   In order to import those views into OWB i have created a DB link.
   using DB link I am able to import the view to Source Module of OWB.
   i have create a simple map .. that is one to one map that pulls the data from
the view to staging table.
   when i ran the map (Execute) it is showing 0 records are inserted into staging
table .
   i went to OWB repository and checked with the same dblink i have created in
OWB.That is selecting  all the rows of the same view. But when i ran the map it
is showing that 0 records were inserted.
   so am unable to creck it . if u know ,,,please help me as early as possible


   Thanks and regards
   Ravi




REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
  Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#539 From: praveen gowdar <praveen_gowdar@...>
Date: Thu Mar 9, 2006 3:20 pm
Subject: Re: View Problem 		praveen_gowdar
Send Email Send Email
  
You need to tell th emap where to pick the view from.
   In the configuration you need to set the schema and db link information.

   Regards,
   Praveen.

Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi All


   I am having aproblem with OWB now . please respond ASAP.
   I ahve some VIews in Schema called test_schema
   In order to import those views into OWB i have created a DB link.
   using DB link I am able to import the view to Source Module of OWB.
   i have create a simple map .. that is one to one map that pulls the data from
the view to staging table.
   when i ran the map (Execute) it is showing 0 records are inserted into staging
table .
   i went to OWB repository and checked with the same dblink i have created in
OWB.That is selecting  all the rows of the same view. But when i ran the map it
is showing that 0 records were inserted.
   so am unable to creck it . if u know ,,,please help me as early as possible


   Thanks and regards
   Ravi




REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#540 From: Ravikumar Jonnalagadda <jrk_ravi@...>
Date: Fri Mar 10, 2006 4:51 am
Subject: Re: View Problem 		jrk_ravi
Send Email Send Email
  
Hi Praveen,

     map is  picking up the view from test_schema(source) only. Am able to import
the definition of view,  but when i ran the map, no records were inserted into
the target table.

   I am able to select the records from the same view  in OWb repository using
the DBLINK..

    Do i need any previlages or grants ?
   awaiting reply

   Thanks
Ravi Kumar J
praveen gowdar <praveen_gowdar@...> wrote:
   You need to tell th emap where to pick the view from.
   In the configuration you need to set the schema and db link information.

   Regards,
   Praveen.

Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi All


   I am having aproblem with OWB now . please respond ASAP.
   I ahve some VIews in Schema called test_schema
   In order to import those views into OWB i have created a DB link.
   using DB link I am able to import the view to Source Module of OWB.
   i have create a simple map .. that is one to one map that pulls the data from
the view to staging table.
   when i ran the map (Execute) it is showing 0 records are inserted into staging
table .
   i went to OWB repository and checked with the same dblink i have created in
OWB.That is selecting  all the rows of the same view. But when i ran the map it
is showing that 0 records were inserted.
   so am unable to creck it . if u know ,,,please help me as early as possible


   Thanks and regards
   Ravi




REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
  Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#541 From: ROTIMI ADEMOLA <arrufus@...>
Date: Fri Mar 10, 2006 7:34 am
Subject: Re: View Problem 		arrufus
Send Email Send Email
  
Hi Kumar,

Check the following:
1. That the dblink you used when importing the schema structure into
OWB is also what is used during Runtime. I know the configuration for
Design and Runtime are different, so you can check this.
2. That the Table Operation is actually Insert inside the mapping.
3. If you have OWB Runtime Audit Browser set up, it should help you see
if there are any errors during the mapping execution.

Hope this helps.

Cheers,
Rotimi Rufus.

--- Ravikumar Jonnalagadda <jrk_ravi@...> wrote:

> Hi Praveen,
>
>     map is  picking up the view from test_schema(source) only. Am
> able to import the definition of view,  but when i ran the map, no
> records were inserted into the target table.
>
>   I am able to select the records from the same view  in OWb
> repository using the DBLINK..
>
>    Do i need any previlages or grants ?
>   awaiting reply
>
>   Thanks
> Ravi Kumar J
> praveen gowdar <praveen_gowdar@...> wrote:
>   You need to tell th emap where to pick the view from.
>   In the configuration you need to set the schema and db link
> information.
>
>   Regards,
>   Praveen.
>
> Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
>   Hi All
>
>
>   I am having aproblem with OWB now . please respond ASAP.
>   I ahve some VIews in Schema called test_schema
>   In order to import those views into OWB i have created a DB link.
>   using DB link I am able to import the view to Source Module of OWB.
>
>   i have create a simple map .. that is one to one map that pulls the
> data from the view to staging table.
>   when i ran the map (Execute) it is showing 0 records are inserted
> into staging table .
>   i went to OWB repository and checked with the same dblink i have
> created in OWB.That is selecting  all the rows of the same view. But
> when i ran the map it is showing that 0 records were inserted.
>   so am unable to creck it . if u know ,,,please help me as early as
> possible
>
>
>   Thanks and regards
>   Ravi
>
>
>
>
> REGARDS,
> RAVI KUMAR J,
> SOFTWARE ENGINEER,
> BODHTREE CONSULTING LTD,
> HYDERABAD VOICE: +91(40)5526-5570~74
> MOBILE : +91 98485 12408
> EMAIL : rjonnalgadda@...
>
>
> ---------------------------------
> Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
>
> [Non-text portions of this message have been removed]
>
>
>
> Join
> http://www.smartgroups.com/groups/Datawarehouse
>
>
>
>   SPONSORED LINKS
>         Oracle 10g   Oracle database   Oracle 8i database     Oracle
> database administration   Oracle database administrator   Oracle
> database software
>
> ---------------------------------
>   YAHOO! GROUPS LINKS
>
>
>     Visit your group "OracleWarehouseBuilder" on the web.
>
>     To unsubscribe from this group, send an email to:
> OracleWarehouseBuilder-unsubscribe@yahoogroups.com
>
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Yahoo! Mail
> Bring photos to life! New PhotoMail  makes sharing a breeze.
>
> [Non-text portions of this message have been removed]
>
>
>
> Join
> http://www.smartgroups.com/groups/Datawarehouse
>
>
>
>   SPONSORED LINKS
>         Oracle 10g   Oracle database   Oracle 8i database     Oracle
> database administration   Oracle database administrator   Oracle
> database software
>
> ---------------------------------
>   YAHOO! GROUPS LINKS
>
>
>     Visit your group "OracleWarehouseBuilder" on the web.
>
>     To unsubscribe from this group, send an email to:
>  OracleWarehouseBuilder-unsubscribe@yahoogroups.com
>
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ---------------------------------
>
>
>
>
>
> REGARDS,
> RAVI KUMAR J,
> SOFTWARE ENGINEER,
> BODHTREE CONSULTING LTD,
> HYDERABAD VOICE: +91(40)5526-5570~74
> MOBILE : +91 98485 12408
> EMAIL : rjonnalgadda@...
>
>
> ---------------------------------
>  Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
>
> [Non-text portions of this message have been removed]
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Reply | Messages in this Topic (10)
#544 From: praveen gowdar <praveen_gowdar@...>
Date: Fri Mar 10, 2006 1:32 pm
Subject: Re: View Problem 		praveen_gowdar
Send Email Send Email
  
Kumar,

    You need to be little specific.
    1)After you run the map. does it end successfully?
   2) Go to owb runtime schema and check for any runtime errors . OR
   3)Go to Database -->Package (Every mapping generates a package).
   Cut and paste the select code genearted from the package(do not write your
own) , execute it , to see if it fetches any record.

   Regards,
   Praveen

ROTIMI ADEMOLA <arrufus@...> wrote:
   Hi Kumar,

Check the following:
1. That the dblink you used when importing the schema structure into
OWB is also what is used during Runtime. I know the configuration for
Design and Runtime are different, so you can check this.
2. That the Table Operation is actually Insert inside the mapping.
3. If you have OWB Runtime Audit Browser set up, it should help you see
if there are any errors during the mapping execution.

Hope this helps.

Cheers,
Rotimi Rufus.

--- Ravikumar Jonnalagadda <jrk_ravi@...> wrote:

> Hi Praveen,
>
>     map is  picking up the view from test_schema(source) only. Am
> able to import the definition of view,  but when i ran the map, no
> records were inserted into the target table.
>
>   I am able to select the records from the same view  in OWb
> repository using the DBLINK..
>
>    Do i need any previlages or grants ?
>   awaiting reply
>
>   Thanks
> Ravi Kumar J
> praveen gowdar <praveen_gowdar@...> wrote:
>   You need to tell th emap where to pick the view from.
>   In the configuration you need to set the schema and db link
> information.
>
>   Regards,
>   Praveen.
>
> Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
>   Hi All
>
>
>   I am having aproblem with OWB now . please respond ASAP.
>   I ahve some VIews in Schema called test_schema
>   In order to import those views into OWB i have created a DB link.
>   using DB link I am able to import the view to Source Module of OWB.
>
>   i have create a simple map .. that is one to one map that pulls the
> data from the view to staging table.
>   when i ran the map (Execute) it is showing 0 records are inserted
> into staging table .
>   i went to OWB repository and checked with the same dblink i have
> created in OWB.That is selecting  all the rows of the same view. But
> when i ran the map it is showing that 0 records were inserted.
>   so am unable to creck it . if u know ,,,please help me as early as
> possible
>
>
>   Thanks and regards
>   Ravi
>
>
>
>
> REGARDS,
> RAVI KUMAR J,
> SOFTWARE ENGINEER,
> BODHTREE CONSULTING LTD,
> HYDERABAD VOICE: +91(40)5526-5570~74
> MOBILE : +91 98485 12408
> EMAIL : rjonnalgadda@...
>
>
> ---------------------------------
> Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
>
> [Non-text portions of this message have been removed]
>
>
>
> Join
> http://www.smartgroups.com/groups/Datawarehouse
>
>
>
>   SPONSORED LINKS
>         Oracle 10g   Oracle database   Oracle 8i database     Oracle
> database administration   Oracle database administrator   Oracle
> database software
>
> ---------------------------------
>   YAHOO! GROUPS LINKS
>
>
>     Visit your group "OracleWarehouseBuilder" on the web.
>
>     To unsubscribe from this group, send an email to:
> OracleWarehouseBuilder-unsubscribe@yahoogroups.com
>
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Yahoo! Mail
> Bring photos to life! New PhotoMail  makes sharing a breeze.
>
> [Non-text portions of this message have been removed]
>
>
>
> Join
> http://www.smartgroups.com/groups/Datawarehouse
>
>
>
>   SPONSORED LINKS
>         Oracle 10g   Oracle database   Oracle 8i database     Oracle
> database administration   Oracle database administrator   Oracle
> database software
>
> ---------------------------------
>   YAHOO! GROUPS LINKS
>
>
>     Visit your group "OracleWarehouseBuilder" on the web.
>
>     To unsubscribe from this group, send an email to:
>  OracleWarehouseBuilder-unsubscribe@yahoogroups.com
>
>     Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ---------------------------------
>
>
>
>
>
> REGARDS,
> RAVI KUMAR J,
> SOFTWARE ENGINEER,
> BODHTREE CONSULTING LTD,
> HYDERABAD VOICE: +91(40)5526-5570~74
> MOBILE : +91 98485 12408
> EMAIL : rjonnalgadda@...
>
>
> ---------------------------------
>  Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
>
> [Non-text portions of this message have been removed]
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
  Yahoo! Mail
  Use Photomail to share photos without annoying attachments.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#545 From: seshpalli srinivas <coolcnu@...>
Date: Fri Mar 10, 2006 4:49 pm
Subject: Re: View Problem 		coolcnu
Send Email Send Email
  
In your case i think when you run deploy the map u should get some warnings
saying Table or view does not exist. then in that case u need to give the select
permission to the owb runtime repository
    GRANT SELECT permission to THE USER OWB RUNTIME REPOSITORY .





Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi Praveen,

     map is  picking up the view from test_schema(source) only. Am able to import
the definition of view,  but when i ran the map, no records were inserted into
the target table.

   I am able to select the records from the same view  in OWb repository using
the DBLINK..

    Do i need any previlages or grants ?
   awaiting reply

   Thanks
Ravi Kumar J
praveen gowdar <praveen_gowdar@...> wrote:
   You need to tell th emap where to pick the view from.
   In the configuration you need to set the schema and db link information.

   Regards,
   Praveen.

Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi All


   I am having aproblem with OWB now . please respond ASAP.
   I ahve some VIews in Schema called test_schema
   In order to import those views into OWB i have created a DB link.
   using DB link I am able to import the view to Source Module of OWB.
   i have create a simple map .. that is one to one map that pulls the data from
the view to staging table.
   when i ran the map (Execute) it is showing 0 records are inserted into staging
table .
   i went to OWB repository and checked with the same dblink i have created in
OWB.That is selecting  all the rows of the same view. But when i ran the map it
is showing that 0 records were inserted.
   so am unable to creck it . if u know ,,,please help me as early as possible


   Thanks and regards
   Ravi




REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
  Yahoo! Mail
  Use Photomail to share photos without annoying attachments.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#547 From: kamal kamal <minimeu2003@...>
Date: Sat Mar 11, 2006 5:11 pm
Subject: Re: View Problem 		minimeu2003
Send Email Send Email
  
u r saying that u can select the records from the view in the reposotory. butcan
u select of the view in ur target schema??. do both source and target reside in
the same database...? if so then OWB doesnt create a DBlink. and see if u can
select off the view using the schema reference.



seshpalli srinivas <coolcnu@...> wrote:
   In your case i think when you run deploy the map u should get some warnings
saying Table or view does not exist. then in that case u need to give the select
permission to the owb runtime repository
    GRANT SELECT permission to THE USER OWB RUNTIME REPOSITORY .





Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi Praveen,

     map is  picking up the view from test_schema(source) only. Am able to import
the definition of view,  but when i ran the map, no records were inserted into
the target table.

   I am able to select the records from the same view  in OWb repository using
the DBLINK..

    Do i need any previlages or grants ?
   awaiting reply

   Thanks
Ravi Kumar J
praveen gowdar <praveen_gowdar@...> wrote:
   You need to tell th emap where to pick the view from.
   In the configuration you need to set the schema and db link information.

   Regards,
   Praveen.

Ravikumar Jonnalagadda <jrk_ravi@...> wrote:
   Hi All


   I am having aproblem with OWB now . please respond ASAP.
   I ahve some VIews in Schema called test_schema
   In order to import those views into OWB i have created a DB link.
   using DB link I am able to import the view to Source Module of OWB.
   i have create a simple map .. that is one to one map that pulls the data from
the view to staging table.
   when i ran the map (Execute) it is showing 0 records are inserted into staging
table .
   i went to OWB repository and checked with the same dblink i have created in
OWB.That is selecting  all the rows of the same view. But when i ran the map it
is showing that 0 records were inserted.
   so am unable to creck it . if u know ,,,please help me as early as possible


   Thanks and regards
   Ravi




REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





REGARDS,
RAVI KUMAR J,
SOFTWARE ENGINEER,
BODHTREE CONSULTING LTD,
HYDERABAD VOICE: +91(40)5526-5570~74
MOBILE : +91 98485 12408
EMAIL : rjonnalgadda@...


---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Use Photomail to share photos without annoying attachments.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail  makes sharing a breeze.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (10)
#549 From: "softttware2006" <softttware2006@...>
Date: Tue Mar 14, 2006 3:25 am
Subject: Online Network Tutorials(DHCP, Firewall, Prevent Spam, PPPOE,Email Server, 		softttware2006
Send Email Send Email
  
Online Network Tutorials(DHCP, Firewall, Prevent Spam, PPPOE,Email
Server,
Wireless Networking , Webcaching, DSL, Cable Modem )
I have prepared networking tutorials for DHCP, Firewall, Prevent Spam,
PPPOE,Email Server,
Wireless Networking , Webcaching, DSL, Cable Modem , etc.
  in my website
http://www.geocities.com/onlinesoftwaretutorial/
So please have a look and make use of it.

Reply | Messages in this Topic (1)
#554 From: "vijayan_dwh" <vijayan_dwh@...>
Date: Fri Mar 24, 2006 1:21 pm
Subject: How to configure mapping while extracting the source in flatfile 		vijayan_dwh
Send Email Send Email
  
Dear all,

  I am vijayan.

  i imported flatfile .dat and .txt then i created mapping
any body can you tell me the details how to configure the mapping'

flat file

regards
vijayan

Reply | Messages in this Topic (1)
#556 From: "chsudheer4" <chsudheer4@...>
Date: Mon Mar 27, 2006 5:25 am
Subject: How to connect to SQLserver database 		chsudheer4
Send Email Send Email
  
Hi frnds,

            I have my source tables in SQL server database...I want to
create source module for SQL server.Can Any1 please provide steps for
my requirement....Thanks in advance

Reply | Messages in this Topic (1)
#557 From: "chsudheer4" <chsudheer4@...>
Date: Mon Mar 27, 2006 6:14 am
Subject: Sql server source registration wizard 		chsudheer4
Send Email Send Email
  
Hi...thanks for replying me...I have found that wizard....but what
details I must give here...for oracle I can give connection string
and all...Here I must give the SQL*net connection string?But I have
selected the host name and gave the host IP address and port number
as 1433. Oracle service name: as my database name in SQL
server...and username as: sa and password as: admin...Iam unable to
connect...Plz reply me..thanks in advance..

The Error is has follows:
                 Testing...
Failed.
SQL Exception
  Repository Error:SQL Exception..
  Class Name: CacheMediator.
  Method Name: getDDEntryFromDB.
  Repository Error Message: ORA-28545: error diagnosed by Net8 when
connecting to an agent
NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from SQL_LINK
.
                      Plase Solve my problem...

Reply | Messages in this Topic (2)
#558 From: "chsudheer4" <chsudheer4@...>
Date: Mon Mar 27, 2006 11:40 am
Subject: Remote Database not found 		chsudheer4
Send Email Send Email
  
Hi All,

         In my mapping i got source tables from different server and
database (abc database) .... and repository ,runtime
repository,traget schema all are in different server and database is
(xyz database) .....i have impoted target table from
target_schema....
                   It is staight mapping.In mapping source table is
directly mapped to target table mapping is validated and generated
             while confuguring the map i gave dblink to source table
only after i validated the mapping and i got warning like VLD-
1124 :  Schema and/or Database link physical configuration
parameters should not be set for EMP...
               I Ignored that warning and deployed the mapping in
deployment manager. i got the following error


PL/SQL:ORA-04052:error occurred when looking up remote object
SCOTT.EMP@SRC_LINK123.US.ORACLE.COM
ORA-00604: ERROR OCCURRED AT RECRUCUVE SQL LEVEL 1
ORA-02019: connection description for remote database not found

                       Please Suggest me ASAP...
  Thanks In Advance

Reply | Messages in this Topic (1)
#559 From: "owb_kid" <owb_kid@...>
Date: Tue Mar 28, 2006 4:36 am
Subject: Workflow 		owb_kid
Send Email Send Email
  
Hi all

I am pretty new to OWB and also to this group.

On box A
a) I have installed Oracle 10.1.0.4
b) I have installed OWB (Runtime repository etc)

On box B

a) I have installed OWB (design time)

I have been going through some doco and one of which asks us to
install Workflow.

My question is, Oracle does not ship Workflow with the database. Do I
need to download Workflow and install it in box A.

Can some one please help me through this.

Cheers

Owb kid.

Reply | Messages in this Topic (6)
#560 From: sudheer ch <chsudheer4@...>
Date: Tue Mar 28, 2006 9:29 am
Subject: Re: Workflow 		chsudheer4
Send Email Send Email
  
Hi....Even Iam facing the same problem....Please let me know If anyone has the
solution....

owb_kid <owb_kid@...> wrote:  Hi all

I am pretty new to OWB and also to this group.

On box A
a) I have installed Oracle 10.1.0.4
b) I have installed OWB (Runtime repository etc)

On box B

a) I have installed OWB (design time)

I have been going through some doco and one of which asks us to
install Workflow.

My question is, Oracle does not ship Workflow with the database. Do I
need to download Workflow and install it in box A.

Can some one please help me through this.

Cheers

Owb kid.





Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





regards,
    SUDHEER.CH
                      (Biztune Software Pvt Ltd)







---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (6)
#561 From: "chsudheer4" <chsudheer4@...>
Date: Tue Mar 28, 2006 10:57 am
Subject: Re: Sql server source registration wizard 		chsudheer4
Send Email Send Email
  
--- In OracleWarehouseBuilder@yahoogroups.com, "chsudheer4"
<chsudheer4@...> wrote:
>
> Hi...thanks for replying me...I have found that wizard....but what
> details I must give here...for oracle I can give connection string
> and all...Here I must give the SQL*net connection string?But I
have
> selected the host name and gave the host IP address and port
number
> as 1433. Oracle service name: as my database name in SQL
> server...and username as: sa and password as: admin...Iam unable
to
> connect...Plz reply me..thanks in advance..
>
> The Error is has follows:
>                 Testing...
> Failed.
> SQL Exception
>  Repository Error:SQL Exception..
>  Class Name: CacheMediator.
>  Method Name: getDDEntryFromDB.
>  Repository Error Message: ORA-28545: error diagnosed by Net8 when
> connecting to an agent
> NCRO: Failed to make RSLV connection
> ORA-02063: preceding 2 lines from SQL_LINK
> .
>                      Plase Solve my problem...
>
Hi Frnds,
           My Problem Got Sloved....

Thanks,
S

Reply | Messages in this Topic (2)
#562 From: otavio otavio07 <otavio07@...>
Date: Tue Mar 28, 2006 11:49 am
Subject: Re: Workflow 		otavio07
Send Email Send Email
  
Dear Colleagues,

   Maybe I can give you some steps. I had the same problem...

   Install Oracle Workflow 2.6.3 schema via Windows
   This as an alternative to the problems with the installation of workflow
tables on Unix.
   ·        Install the Oracle 10g database software on a Windows client (but
don’t create a database)
This installation is very similar to installing Oracle 10g on Unix.
   ·        Update the Oracle 10g database software to version 10.1.0.4.
This installation is very similar to installing this patch version on Unix.
   ·        Install Oracle Workflow 2.6.3 in the Oracle 10g database home
directory.
This installation is very similar to installing Oracle Workflow 2.6.3 on Unix.
   ·        Create a tnsnames.ora file (in $ORACLE_HOME\network\admin) so that
the next step can connect to the database. (Forgetting this will result in the
error ‘This is not an Oracle 10g database’ which is a very confusing error when
the real problem is that it cannot contact the database.)
After creating a tnsnames.ora file test the connection. (Use SQL*Plus to test
the connection.)
   ·        Create the user owf_mgr in the database:
   o       SQL> grant connect,resource,dba to owf_mgr identified by owf_mgr;
   ·        Start workflow install on Windows and enter the needed parameters.
In a DOS box execute:
   o       Make sure database is started and a connection from Windows is
possible
   o       cd ……oracle_home….\wf\install
   o       wfinstall.bat
   §         Workflow account: owf_mgr (default)
   §         Workflow password: owf_mgr
   §         sys password: manager
   §         Install options: Install
   §         Language selection: US (cannot be changed)
   §         Connect method: remote
   §         Connect string: DWH1
(DWH1 is here the SQL*Net connect string.)
   §         Host name: <computer>
   §         JDBC connection: <computer>:1521:DWH1
(DWH1 is here the ORACLE_SID that is used on computer <computer>!!!
JDBC connections use the format <computer>:<port>:<oracle_sid>.)
   §         Enter LDAP parameters (optional): no
   §         Enter Mailer parameters (optional): no
   §         Change Tablespace: no
Notes:
   ·        You can try yes but it’s not possible to change the value to
WORKFLOW. That is why the WORKFLOW tablespace is not needed anymore when
creating the database.
   ·        Setting the default tablespace of user owf_mgr to workflow before
starting the installation does not solve the problem.

   The middle tier and client part of the Workflow installation are not needed.

   As user system do :

       grant execute any procedure to owf_mgr;


     After this, don't forget to create a flow module in OWB and its location ;
and inside runtime right-click on FLOW module created and Register the location
flow with the login OWF_MGR

   I hope it helps.

   Cheers,
   Otávio Tallarico.
   DW's DBA,  OWB Analyst & Microstrategy Administrator.

sudheer ch <chsudheer4@...> escreveu:

   Hi....Even Iam facing the same problem....Please let me know If anyone has the
solution....

owb_kid <owb_kid@...> wrote:  Hi all

I am pretty new to OWB and also to this group.

On box A
a) I have installed Oracle 10.1.0.4
b) I have installed OWB (Runtime repository etc)

On box B

a) I have installed OWB (design time)

I have been going through some doco and one of which asks us to
install Workflow.

My question is, Oracle does not ship Workflow with the database. Do I
need to download Workflow and install it in box A.

Can some one please help me through this.

Cheers

Owb kid.





Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





regards,
    SUDHEER.CH
                      (Biztune Software Pvt Ltd)







---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.

[Non-text portions of this message have been removed]



Join
http://www.smartgroups.com/groups/Datawarehouse



   SPONSORED LINKS
         Oracle 10g   Oracle database   Oracle 8i database     Oracle database
administration   Oracle database administrator   Oracle database software

---------------------------------
   YAHOO! GROUPS LINKS


     Visit your group "OracleWarehouseBuilder" on the web.

     To unsubscribe from this group, send an email to:
  OracleWarehouseBuilder-unsubscribe@yahoogroups.com

     Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---------------------------------





---------------------------------
  Yahoo! doce lar. Faça do Yahoo! sua homepage.

[Non-text portions of this message have been removed]

Reply | Messages in this Topic (6)
Messages 505 - 562 of 23952   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?
Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help