Home » Infrastructure » Linux » ORA 01261 and 01262 (rhel 5 , 10.2.0)
ORA 01261 and 01262 [message #557089] Fri, 08 June 2012 14:23 Go to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
Hi to all ;

I am trying to create database manually. I used existing database init.ora file. It was created by DBCA.
I did all changes regarding my database.
while issue startup pfile i am facing ORA 01261 and ORA 01262


SQL> startup pfile='/u01/app/oracle/admin/test/pfile/init.ora' nomount
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory


In init.ora file i mentioned as

db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size=2147483648

" HOW CAN I RESOLVE THIS PROBLEM ? "

Thanks and Regards
Thiyagusham.G


Re: ORA 01261 and 01262 [message #557091 is a reply to message #557089] Fri, 08 June 2012 14:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does "=/u01/app/oracle/flash_recovery_area" exist and is accessible to Oracle OS account?

Regards
Michel
Re: ORA 01261 and 01262 [message #557092 is a reply to message #557091] Fri, 08 June 2012 15:13 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michel

Oracle user having full rights. Sure above directory not exist.

Thanks
Thiyagusham G
Re: ORA 01261 and 01262 [message #557096 is a reply to message #557092] Fri, 08 June 2012 15:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have to create it!

Regards
Michel
Re: ORA 01261 and 01262 [message #557099 is a reply to message #557096] Fri, 08 June 2012 16:13 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ michel

Now i crossed that error. Now i am facing this error.

SQL> @/u01/app/oracle/admin/test/script/createdb.sql
create database test
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

" please review screen shot you can easily understand what's current issue going on! "

Thanks and regards
Thiyagusham.G
  • Attachment: up.png
    (Size: 181.99KB, Downloaded 1795 times)
Re: ORA 01261 and 01262 [message #557104 is a reply to message #557099] Fri, 08 June 2012 20:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
bcm@bcm-laptop:~$ oerr ora 1092
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause:  The instance this process was connected to was terminated
//	    abnormally, probably via a shutdown abort. This process
//	    was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been 
//          restarted, retry action.
Re: ORA 01261 and 01262 [message #557131 is a reply to message #557104] Sat, 09 June 2012 07:43 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ blackswan

Thank you. I need to mention onething. Due to check ORA 01555 error , undo tablespace size was declared as 1m.
Is it major cause of error ????

ALERT LOG INFO
===============
Errors in file /u01/app/oracle/admin/test/udump/test_ora_5596.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6403
ORA-00604: error occurred at recursive SQL level 2
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519


Instance terminated by USER, pid = 5596
ORA-1092 signalled during: create database test
datafile '/u01/app/oracle/oradata/test/system.dbf' size 400m
sysaux
datafile '/u01/app/oracle/oradata/test/sysaux.dbf' size 400m
logfile
group 1 '/u01/app/oracle/oradata/test/redo1.log' size 15m,
group 2 '/u01/app/oracle/oradata/test/redo2.log' size 15m
undo tablespace undotbs1
datafile '/u01/app/oracle/oradata/test/undotbs1.dbf' size 1m
default temporary tablespace temp
tempfile '/u01/app/oracle/oradata/test/temp.dbf' size 100m
character set AL32UTF8...


DB SCRIPT DETAIL'S


create database test 
datafile '/u01/app/oracle/oradata/test/system.dbf' size 400m 
sysaux 
datafile '/u01/app/oracle/oradata/test/sysaux.dbf' size 400m 
logfile 
group 1 '/u01/app/oracle/oradata/test/redo1.log' size 15m, 
group 2 '/u01/app/oracle/oradata/test/redo2.log' size 15m 
undo tablespace undotbs1 
datafile '/u01/app/oracle/oradata/test/undotbs1.dbf' size 1m 
default temporary tablespace temp 
tempfile '/u01/app/oracle/oradata/test/temp.dbf' size 100m 
character set AL32UTF8; 

Re: ORA 01261 and 01262 [message #557132 is a reply to message #557131] Sat, 09 June 2012 07:54 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
From the example in the docs:
CREATE DATABASE mynewdb
   USER SYS IDENTIFIED BY pz6r58
   USER SYSTEM IDENTIFIED BY y1tz5p
   LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
           GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
           GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE tbs_1
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf' 
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs 
      DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
I would suggest that you take the filesizes above as the minimum requirement.
Re: ORA 01261 and 01262 [message #557134 is a reply to message #557132] Sat, 09 June 2012 08:19 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ john

Thanks john. I saw your database script. Except undo tablespace size " IS there any error ????
shall i use my own script ?????

Thanks
Re: ORA 01261 and 01262 [message #557139 is a reply to message #557134] Sat, 09 June 2012 09:04 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
Hi to all;

" Please Review both terminal what i marked.

DATABASE ORCL i created through DBCA
DATABASE TEST i created manually.
I executed following command

SQL>select * from tab;

Both database showing different count.

1.I want to know what are the views are not created ????

( In 10g R2 )

2. How many views are in 10g Oracle database ???

Thanks and Regards
Thiyagusham

  • Attachment: save.png
    (Size: 147.67KB, Downloaded 1901 times)

[Updated on: Sat, 09 June 2012 09:06]

Report message to a moderator

Re: ORA 01261 and 01262 [message #557140 is a reply to message #557139] Sat, 09 June 2012 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: ORA 01261 and 01262 [message #557143 is a reply to message #557139] Sat, 09 June 2012 09:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Make a diff
2. Depends on the options (and patchsets) you installed.

Regards
Michel
Re: ORA 01261 and 01262 [message #557144 is a reply to message #557143] Sat, 09 June 2012 09:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>2. Depends on the options (and patchsets) you installed.
& specific version & which edition
Re: ORA 01261 and 01262 [message #557146 is a reply to message #557144] Sat, 09 June 2012 10:18 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ blackswan

I am a DBA trainee. I can't understand your question

Thanks and Regards
Thiyagusham.G
Re: ORA 01261 and 01262 [message #557148 is a reply to message #557146] Sat, 09 June 2012 10:23 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ blackswan ,@ michal ,@ john

While running catalog , catproc i saw " DOESN'T Exist "
IS it specific reason ??? I think i made some mistakes am i right ???

Thanks and Regards
Thiyagusham.G

[Updated on: Sat, 09 June 2012 10:24]

Report message to a moderator

Re: ORA 01261 and 01262 [message #557150 is a reply to message #557148] Sat, 09 June 2012 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
IS it specific reason ???


1/ You didn't point in the correct directory
2/ You didn't type the correct file names
3/ You just installed a client version and a database version where you are pointing
4/ You delete the files
5/ A quark came and removed the directories
6/ Your PC is off
7/ WE ALWAYS SAY TO COPY AND PASTE WHAT YOU DO AND GET

Regards
Michel
Re: ORA 01261 and 01262 [message #557151 is a reply to message #557150] Sat, 09 June 2012 10:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
@MC, I think he is referring to the "ORA-00942: table or view does not exist" messages.

@Thiyagusham.G, if you look at those scripts you'll see that they create many views and packages. And before each CREATE WHATEVER statement there is always a DROP WHATEVER statement, so that the object can be re-created. The first time you run the scripts, the objects do not exist, so the DROP statements return a message saying that there is nothing to drop. That's all. Run the scripts again, and you'll see that there are no more messages of that type.

(ps: it always reminds me of Shiva's role in the Hindu triumvirate: the Destroyer and Re-creator)
Re: ORA 01261 and 01262 [message #557160 is a reply to message #557151] Sat, 09 June 2012 14:01 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ john , @ michal
Thank you for your replies.  Now i am facing new issue. I think three times i used startup pfile command. 
At that time i changed (pfile) from  inittest.ora to init.ora
here dbs directory using inittest.ora file not my new init.ora file. 
Actually that file renamed as init.ora from inittest.ora
ADMIN >> PFILE >> init.ora


" i want to change SYSTEM TABLESPACE From dictionary managed to Locally Managed.

SQL> select tablespace_name, status ,Extent_management from dba_tablespaces;

TABLESPACE_NAME STATUS EXTENT_MAN
------------------------------ --------- ----------
SYSTEM ONLINE DICTIONARY
UNDOTBS1 ONLINE LOCAL
SYSAUX ONLINE LOCAL
TEMP ONLINE LOCAL

4 rows selected.


SQL> shutdown immediate

 Database closed.
 Database dismounted.
 ORACLE instance shut down.

SQL> startup restrict
 
 ORA-01078: failure in processing system parameters
 LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/db s/inittest.ora'



Really i don't know how can change from inittest.ora to init.ora at dba directory.

Thanks help me ....
Thiyagusham. G

[Updated on: Sat, 09 June 2012 14:02]

Report message to a moderator

Re: ORA 01261 and 01262 [message #557162 is a reply to message #557160] Sat, 09 June 2012 14:17 Go to previous messageGo to next message
thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai
Senior Member
@ hai to all ;

now i startup database at restrict mode

startup restrict pfile='/u01/app/oracle/product/10.2.0/db_1/db s/init.ora'


SQL> startup restrict pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/init.ora'
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes


Thiyagusham.G
Re: ORA 01261 and 01262 [message #557164 is a reply to message #557162] Sat, 09 June 2012 14:30 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One of the solutions is in the message.

Regards
Michel

[Updated on: Sat, 09 June 2012 14:30]

Report message to a moderator

Previous Topic: external table error
Next Topic: Migration from Windows to Linux of Oracle 10g
Goto Forum:
  


Current Time: Thu Mar 28 12:27:48 CDT 2024