errors to overcome [message #277153] |
Mon, 29 October 2007 02:11 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Hi friends and especially Michael,
I am a bit puzzled.
I installed oracle 7 on SCO UNIX 5.0.5
In the last few seconds of the installation , ifound some errors that
/home/oracle7/orainst/wgstart.sh :/home/oracle7: can't execute
/home/oracle7/orainst/wgpostins.sh :/home/oracle7: can't execute
Though no errors came during the entire installation except the above ones , but when i try to dbstart the database,it shows errors
ora-00205: error in identifying control file 'ora_control1'
ora-07360: sfifi : stat error, unable to obtain information about file
AT&T System V/386 Error : 2 : No such file or directory
How could such error be come?
And i dont find any file in dbs ditrectory other than init.ora file
Does it mean the installer did not create any database during installation?
Does wgpostins.sh script create controlfiles and other files?
Do i have to manually create the database and control file??
I know i a mworking on very old systems.
Can anybody put some light on it?
Thanks
|
|
|
|
Re: errors to overcome [message #277164 is a reply to message #277153] |
Mon, 29 October 2007 02:24 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Thanks Michel for the quick response.
Can you check the steps to create the database
1)Startup nomount
2)Create database script same as in all the versions?
3) Post database creation steps??
Thanks
|
|
|
|
|
|
|
Re: errors to overcome [message #277229 is a reply to message #277153] |
Mon, 29 October 2007 05:01 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
SVRMGR> connect internal
SVRMGR> startup nomount
SVRMGR> create database orcl
maxinstances 1
maxlogfiles 8
datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
logfile
'$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
ORA-00376: file 1 cannot be read at this time
ora-01110: data file 1:'/home/oracle7/dbs/orcl_syst_01.dbf'
When i try to shutdown the instance it hanged
The alert logfile shows the same message.
|
|
|
Re: errors to overcome [message #277252 is a reply to message #277229] |
Mon, 29 October 2007 05:49 |
|
Michel Cadot
Messages: 68707 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Verify that your user has read/write accesses on directories.
Generally, there is an OS error message associated, which one it is?
Drop the current files and retry.
Regards
Michel
[Updated on: Mon, 29 October 2007 05:50] Report message to a moderator
|
|
|
|
|
Re: errors to overcome [message #277268 is a reply to message #277153] |
Mon, 29 October 2007 06:25 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
I killed all the processes of oracle.(ps -ef grep | oracle)
But the problem persisted.
Then issues ipcs -m to see the shared memory segments and removed the oracle segments .
ipcrm -m ID.
After restaring the machine when i did dbstart, new errors came.
Ora-12162: TNS: service name is incorrectly specified
SVRMGR> LCC-00161 : ORACLE error(possible syntax error) parameter [NULL]
I checked in the network/admin directory, the listener and other related files are of the extension v1.
i dont see any listener.ora file.
|
|
|
|
|
|
Re: errors to overcome [message #277285 is a reply to message #277153] |
Mon, 29 October 2007 07:25 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Hi Michel,
Now after executing the create database command i got the following error:
ORA-00603: ORACLE server session terminated by fatal error
SVRMGRL>MGR-11401: input error, unable to read input file
MGR-01508: unable to close the current file
|
|
|
|
Re: errors to overcome [message #277336 is a reply to message #277153] |
Mon, 29 October 2007 11:45 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
i issued the above create database command.
Yes i have sql.bsq file in the dbs directory.
As user root i gave 777 permission to /home/oracle7.
|
|
|
|
Re: errors to overcome [message #277404 is a reply to message #277153] |
Mon, 29 October 2007 23:46 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
The owner of dbs directory is oracle7 and it has read write permissions. I am creating database as user oracle7.
So there should not be any permisions issues.
I issued this command to create the database
SVRMGR> connect internal
SVRMGR> startup nomount
SVRMGR> create database orcl
maxinstances 1
maxlogfiles 8
datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
logfile
'$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
'$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
and recieved the above errors.
I removed Sql.bsq file also.
|
|
|
|
|
Re: errors to overcome [message #277421 is a reply to message #277153] |
Tue, 30 October 2007 01:03 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Hi Michel,
I reinstalled oracle server and it created the default database.
The installation went successfull with one error:
Oracle Web Listener, Version 1.01fc5
Copyright 1995 Oracle Corp. All Right Reserved.
Error: maid Service(maid.SCO_SV3.2.release) exited with unexpected error: the server was unable to initialize.
Information: The server is exiting
Is this error any cause of concern?
Thanks
|
|
|
|
|
Re: errors to overcome [message #277482 is a reply to message #277153] |
Tue, 30 October 2007 05:41 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Hi Michel,
During installation of forms 6i on Unix, igot following error:
$ ./orainst
Supported Terminals are:
Term=scoansi ORacle_term=
Can't find resource file
/cdrom/orainst/./tk2{TERM}.res or
/cdrom/orainst/./tk2{ORACLE_TERM}.res
Please sete your TERM variable to one of the supported terminals.
Exiting orainst procedure.
In my .profile file i have set TERM and ORACLE_TERM to ansi.
Do i have to set them to any other location also??
Thanks
|
|
|
|
|
|
|
|
Re: errors to overcome [message #278211 is a reply to message #278184] |
Fri, 02 November 2007 07:01 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Are your clients aware that they're using obsolete, unsupported software?
I just can't understand why you'd use it - it still needs licensing, so cost can't be the reason.
|
|
|
|