Home » RDBMS Server » Server Administration » errors to overcome
errors to overcome [message #277153] Mon, 29 October 2007 02:11 Go to next message
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 #277159 is a reply to message #277153] Mon, 29 October 2007 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Does it mean the installer did not create any database during installation?

This is the more likely.

Quote:

Do i have to manually create the database

Yes.

Regards
Michel
Re: errors to overcome [message #277164 is a reply to message #277153] Mon, 29 October 2007 02:24 Go to previous messageGo to next message
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 #277166 is a reply to message #277164] Mon, 29 October 2007 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
0) create an init.ora file

Regards
Michel
Re: errors to overcome [message #277167 is a reply to message #277153] Mon, 29 October 2007 02:28 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
That is already there in dbs directory but no other file other than that
Re: errors to overcome [message #277171 is a reply to message #277167] Mon, 29 October 2007 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant init<SID>.ora not the sample one.
No other file in Oracle7 (as far I remember) but of course directories in which you want to put your files.

Regards
Michel

[Updated on: Mon, 29 October 2007 02:42]

Report message to a moderator

Re: errors to overcome [message #277172 is a reply to message #277153] Mon, 29 October 2007 02:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok i copy pasted the file and rename it init(SID_name).ora
Re: errors to overcome [message #277229 is a reply to message #277153] Mon, 29 October 2007 05:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

icon8.gif  Re: errors to overcome [message #277262 is a reply to message #277153] Mon, 29 October 2007 05:56 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I killed the shutdown process as shutdown was hanged.
Since then i am getting the legendary ora01081: oracle initialization or shutdown in progress error Sad
Re: errors to overcome [message #277266 is a reply to message #277262] Mon, 29 October 2007 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Kill all the Oracle processes, remove the sgadef file created in dbs directory (iirc).

Regards
Michel
Re: errors to overcome [message #277268 is a reply to message #277153] Mon, 29 October 2007 06:25 Go to previous messageGo to next message
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 #277275 is a reply to message #277153] Mon, 29 October 2007 06:33 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Thanks Michel.
Problem solved.
You truly are a genius.
But how did sgadef file come in dbs directory and what is its purpose?

Thanks
Re: errors to overcome [message #277277 is a reply to message #277275] Mon, 29 October 2007 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Internal stuff, just to let Oracle knows there was an instance and something like that. Useful only in old versions.

Regards
Michel

[Updated on: Mon, 29 October 2007 06:42]

Report message to a moderator

Re: errors to overcome [message #277279 is a reply to message #277153] Mon, 29 October 2007 06:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Ok Now i have given chmod 777 oracle7 .

Now i hope the create database command wont fail.
Re: errors to overcome [message #277285 is a reply to message #277153] Mon, 29 October 2007 07:25 Go to previous messageGo to next message
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 #277290 is a reply to message #277285] Mon, 29 October 2007 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not there to see what you wrote.
I don't which file it is trying to get.
Are you sure your user has all privileges on Oracle directories?
Check if you have sql.bsq file somewhere in $ORACLE_HOME (I don't remember where it should be located in your version).
Check alert.log.

Regards
Michel
Re: errors to overcome [message #277336 is a reply to message #277153] Mon, 29 October 2007 11:45 Go to previous messageGo to next message
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 #277339 is a reply to message #277336] Mon, 29 October 2007 12:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about subdirectories and files?
By the way, 777 is not a good thing, just the owner which MUST NOT be root.
Don't use root to install Oracle or create a database.

Regards
Michel
Re: errors to overcome [message #277404 is a reply to message #277153] Mon, 29 October 2007 23:46 Go to previous messageGo to next message
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 #277414 is a reply to message #277404] Tue, 30 October 2007 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I removed Sql.bsq file also

Aaargh! You MUST not remove this file, it is necessary and mandatory for database creation.

Regards
Michel
Re: errors to overcome [message #277418 is a reply to message #277153] Tue, 30 October 2007 00:24 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Embarassed Mad Sad

Is there any way to retrieve that file or i have install oracle all over again?
Re: errors to overcome [message #277421 is a reply to message #277153] Tue, 30 October 2007 01:03 Go to previous messageGo to next message
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 #277430 is a reply to message #277421] Tue, 30 October 2007 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it is safe, it is only related to one old component (the name I don't remember) that was seldomly used. I assume you chose all options on installation.

Regards
Michel
Re: errors to overcome [message #277437 is a reply to message #277153] Tue, 30 October 2007 02:20 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Thanks Michel for all your valuable suggestions. Smile
Re: errors to overcome [message #277482 is a reply to message #277153] Tue, 30 October 2007 05:41 Go to previous messageGo to next message
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 #277489 is a reply to message #277482] Tue, 30 October 2007 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know forms.
Try vt100 instead of ansi.

Regards
Michel
Re: errors to overcome [message #277543 is a reply to message #277489] Tue, 30 October 2007 08:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Dear OP,
I go through complete thread. and happy with Micheal Knowledge.but OP why you use Oracle 7 ???


Regards
Mohammed Taj
Re: errors to overcome [message #278044 is a reply to message #277153] Thu, 01 November 2007 11:24 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Dear MT,
I am `using oracle 7 as one of our project is based on it.
Re: errors to overcome [message #278181 is a reply to message #278044] Fri, 02 November 2007 05:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You are aware that it's utterly unsupported, aren't you?
Re: errors to overcome [message #278184 is a reply to message #277153] Fri, 02 November 2007 05:25 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
yes i am aware but thanks to Michel for his help.Now the project is up and running and has been implemented at the client site.
Re: errors to overcome [message #278211 is a reply to message #278184] Fri, 02 November 2007 07:01 Go to previous messageGo to next message
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.

Re: errors to overcome [message #278217 is a reply to message #277153] Fri, 02 November 2007 07:23 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Of course they have license.We are planning to ungrade it.
Previous Topic: Indexes doubt
Next Topic: Oracle Shuts down automatically
Goto Forum:
  


Current Time: Thu Nov 07 16:49:17 CST 2024