Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

suitable init.ora or .sql for launching isql

651943Oct 27 2009 — edited Oct 27 2009
Hello!

I installed Ora11gr1 in my suse11.1, but when I do,

./isqlplus / as sysdba

there is a problem with the original init.ora in my pc, I think memory problem... I solved it commenting SHARED_POOL_SIZE line but after that, there's another problem,

ORA-00205: error in identifying control file.

So, I create a sql to recreate the control file, and, ./sqlplus sys/sys as sysdba @p.sql


SHUTDOWN INMEDIATE
STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 1
MAXLOGHISTORY 449
LOGFILE
GROUP 1 '/dev/sdc11/app/oracle/product/11.1.0/db_1/dbs/t_log1.f' SIZE 500K,
GROUP 2 '/dev/sdc11/app/oracle/product/11.1.0/db_1/dbs/t_log2.f' SIZE 500K
DATAFILE
'/dev/sdc11/app/oracle/product/11.1.0/db_1/dbs/t_db1.f',
'/dev/sdc11/app/oracle/product/11.1.0/db_1/dbs/dbu19i.dbf'
CHARACTER SET WE8DEC
;

But the last problem is:

ORA-01565 error in identifying file
ORA-27047 unable to read the header block of file
Linux Error: 92: Protocol not available
Additional information: 1

What must I do?

I don't understand anything because this is a clean install of Oracle11gr1.

Thanks.
This post has been answered by Hans Forbrich on Oct 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2009
Added on Oct 27 2009
5 comments
639 views