Question

ORA-03113 during database creation

Rating7.8Very Good

I just installed Oracle 8.1.7 on Sparc box. But when I try to create a database I get ORA-03113 error. Error description is not meaningful. Basically when I start svrmgrl and do 'connect internal; startup nomount pfile = "/mpt01/app/oracle/admin/MSK/pfile/initMSK.ora"' I instantly get this error (ORA-03113: end-of-file on communication channel). I have Sun Ultra 10 with 256Mb memory, running Solaris 8 with the latest cluster patch.

  1. error ORA-00904 when reading Function O…
    This is a sever brain fart. I'm trying to read the output from a function and I keep getting an ORA-00904 error saying invalid identifier. I'm in sqlplus trying variations of select add_five(1,2,3) from dual; also tried select user_name.add_five(1,2,3) from dual;
  2. Error ORA-03113
    Hi Experts! I was searching information about this error (ORA-03113) and saw that the user "Bajwa" sent a comment from Oracle. This comment says "... Remove the user from the ORA_DBA group an then logoff and log back on. ...". So my question is: What user do I need to remove? Because I verify the u…
  3. ORA-03113 with oracle on NT5
    I formatted my hard drive and tried to install personal oracle 8.1.7 and get the ORA-03113 error when trying to create a database. I reformatted my hard drive and then tried the SE version of oracle, and got the same error again. What do I need to do to get this to work? Thanks, Sean
  4. Oracle 9i multi-table left join bombs with ora-0…
    It seems that almost any time I do a LEFT JOIN involving 3 or more tables oracle bombs with ora-03113 end-of-file on communcation channel. Sometimes it works, but not often. for example: I want to find happy things (from the 'happy' table) about animals with mouths, w/o excluding animals (like myself) who aren't happy. Here is the …
  5. Oracle system parameter
    SQL> startup pfile=c:\app\hussain\admin\test\pfile\inittest.ora nomount LRM-00116: syntax error at 'C:\app\Hussain\f' following '=' ORA-01078: failure in processing system parameters SQL> startup pfile=c:\app\hussain\admin\test\pfile\inittest.ora nomount LRM-00116: syntax error at 'C:…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
creation
Participating Experts
1
Solution Grade
B

Replies

 
by: sbenyo

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: tigra17

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: sbenyo

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: tigra17

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: tigra17

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: sbenyo

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert