ORA 01261 and 01262 [message #557089] |
Fri, 08 June 2012 14:23 |
|
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 #557132 is a reply to message #557131] |
Sat, 09 June 2012 07:54 |
John Watson
Messages: 8963 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 #557139 is a reply to message #557134] |
Sat, 09 June 2012 09:04 |
|
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 2441 times)
[Updated on: Sat, 09 June 2012 09:06] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: ORA 01261 and 01262 [message #557151 is a reply to message #557150] |
Sat, 09 June 2012 10:49 |
John Watson
Messages: 8963 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 |
|
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
|
|
|
|
|