on 08-23-2007 2:28 PM
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 'MDD', Schema 'SYSTEM', ERROR CODE=1119 ||| ORA-01119: error in creating database file '/A2I_myrep20_m000_Ix.DBF'<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 '/A2I_myrep20_m000_Ix.DBF' 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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.