Skip to Content

ORA-01119 when trying to create a repository

Hi

Could anyone please asssist. I get an error ORA-01119 when trying to create a repository. I hava an oracle 10.2.2 database and MDM server 5.5 SP05 patch level 2 all running on one UNIX (Solaris 10 server).

I am trying to crate a repository (TEST) using the clix command tool with oracle user SYSTEM. The clix tool reports an error: Unable to modify database.. The same error comes up when using the Console Tool (on windows). The Server*.xml log file shows the following:

<Trace ts="2007/08/23 13:06:52.339 GMT" tid="5" entry-no="323">Service &apos;MDD&apos;, Schema &apos;SYSTEM&apos;, ERROR CODE=1119 ||| ORA-01119: error in creating database file &apos;/A2I_myrep20_m000_Ix.DBF&apos;<LF/>ORA-27040: file create error, unable to create file<LF/>SVR4 Error: 13: Permission denied<LF/><LF/>Last CMD: CREATE TABLESPACE A2I_myrep20_m000_Ix DATAFILE &apos;/A2I_myrep20_m000_Ix.DBF&apos; SIZE 128K REUSE AUTOEXTEND ON NEXT 256K MAXSIZE UNLIMITED DEFAULT STORAGE (INITIAL 32K NEXT 128K MAXEXTENTS UNLIMITED PCTINCREASE 0)<LF/></Trace>

Does anyone have an idea on what this could be caused by and how one can resolve it.

This is the command used:

clix repoCreate <mdm host> TEST:<DBINST>:o:<USER>:<PASSWORD> port

Please assist

Kind Regards

Ronny Mabuza

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2007 at 12:13 AM

    Hello Ronny,

    Error ORA-01119 indicates a problem creating a database file

    Error ORA-27040 indicates a problem creating a file.

    The last error in the chain is "13: Permission denied."

    It looks like your Oracle server does not have the permission(s) necessary to create files needed by the new database. You might want to have your DBA/sysadmin find out where the DBMS is configured to store data files and whether it has the permissions necessary to create new files there.

    Hope that helped,

    Simon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2007 at 06:08 AM

    hello,

    i was also facing the same problem but u r facing this problem on UNIX operating system so i was on windows,

    but as u have been told it shows the error ORA-01119 this problem is related to u r oracle database that means u r oracle database is not ready with its listeners and services to communicate with u r SAP product.

    so please follow the link.

    http://www.cryer.co.uk/brian/oracle/ORA12545.htm

    this site will tell u the error nature follow that and try to solve it. otherwise follow the installation guid for MDM server 5.5 SP05.

    regards,

    swapnil

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.