suitable init.ora or .sql for launching isql
651943Oct 27 2009 — edited Oct 27 2009Hello!
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.