Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pmora8.dll Error while creating Repository

Status
Not open for further replies.
venku72

venku72

Technical User
Joined
Sep 28, 2005
Messages
25
Location
JP
Hi..

I installed Informatica 7.1 on windows XP Professional and Oracle 9i is my database.

When I create the repository, its giving an error and the error is pmora8.dll.

Can any one give me what is this error and how to solve...

thanks in advance
venku72
 
Sort by date Sort by votes
Did you check the path on the machine? Make sure Oracle/bin... path is listed.
Also make sure repository server is installed in a folder that does not contain spaces.

Ties Blom

 
Upvote 0 Downvote
I installed informatica. and when i tried to crete a repositioy am getting these problems...

After some time its giving an error that it could not create repository..and see the log ...

Logfile contains the following errors....
If i see the database there are 41 tables created....
How to solve this problem..

The db user is having RESOURCE , CONNECT , AND DBA privelages..Are they sufficient?

Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.

Create repository started at 08/04/2006 11:17:07...
--------------------------------------------------------------------------------

drop table OPB_REPOSIT

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SUBJECT

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_PICDSC

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SRC_FLD

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SCHEMA

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SRC

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SELINFO

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_TARG

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_TARG_FLD

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_FLDLINK

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_TARGINDEX

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_TARGINDEXFLD

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_RTSEQ

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_DBD

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_LOAD_SESSION

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_LOAD_FILES

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_BATCH_SESSION

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_LOAD_BATCH

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_BATCH_OBJECT

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_DATABASES

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_LOAD_SESS_CMDS

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SESSION_LOG

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SESS_TARG_LOG

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_RECOVERY

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_KEYWORD

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_SESSION_PARAMS

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_CC_INSTANCE

ORA-00942: table or view does not exist

Database driver error...
Function Name : ExecuteDirect

Oracle Fatal Error
drop table OPB_CC_MAPPINGS
 
Upvote 0 Downvote
Is the repository an empty ORACLE database? I cannot recall that the installation script tries to drop objects first. [I've installed Powercenter 7 last month on Oracle 9i, without a hassle]. Make sure that user executing script has rights to create objects. It does not need to be a DBA account.
You cannot create a repository if already one exists..


Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
402
sa0309
sa0309
devaraj21c
  • Locked
  • Question Question
problem while importing flat file
Replies
1
Views
315
rasETL
rasETL
jkc58
  • Locked
  • Question Question
Access Error 430
Replies
0
Views
254
jkc58
jkc58
mohitpiscean
  • Locked
  • Question Question
READER_1_1_1-RR_4053 Row error occured while fetching data from databa
Replies
1
Views
670
mohitpiscean
mohitpiscean
MINIACS
  • Locked
  • Question Question
"Invalid date, time or timestamp" error - Pervasive 10
Replies
0
Views
279
MINIACS
MINIACS

Part and Inventory Search

Sponsor

Back
Top