OraFAQ Forum: Linux » How to start all of service in Linux RedHat?

Home » Infrastructure » Linux » How to start all of service in Linux RedHat?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to start all of service in Linux RedHat? [message #266038]

Sun, 09 September 2007 04:45

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Dear all!

I am newbie on Linux, today, there were some problem that appeared.

All of services such as:
- OracleDBConsole
- Listener
- OracleServiceFuji -- Fuji that is DB's service name

My Oracle DB is RAC, 10.2
My OS is Redhat Linux

I have privilege root and oracle account

How to start these services with XWindow? Please guide me step by step.

Thank you very much!

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266046 is a reply to message #266038]

Sun, 09 September 2007 05:11

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

-emctl start dbconsole
-lsnrctl start <listener name>
-startup Fuji

[Updated on: Sun, 09 September 2007 05:46]

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266050 is a reply to message #266038]

Sun, 09 September 2007 05:40

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Dear Arju!
First time, I wish the best to you.

And, I'll follow to your guide:

#su -oracle
..
connected
$emctl start dbconsole
$lsnctl start Fuji
$startup Fuji

Are there all right? Sorry, because my server is not open at now to start them.

Thank again!

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266057 is a reply to message #266046]

Sun, 09 September 2007 07:19

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

startup Fuji
@OP you have to also connect with sysdba user and "startup" your database.

$./sqlplus /nolog
Connected to idle instance.
SQL>startup

Note: if you database is not started or your will get this message "connected to idle instance." then you have to startup/open your database for normal use.

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266073 is a reply to message #266038]

Sun, 09 September 2007 09:10

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Quote:

Err listener could not resolve SERVICE_NAME given in connect descriptor

This is error message when I attempted connect to DB by this command:

$sqlplus /nolog
SQL> conn sys/password@FUJI as sysdba
ORA-12514: Err listener could not resolve SERVICE_NAME given in connect descriptor

The Listener started successfully!
But I did not how to start DBService, in one website, a guide as:

su -c oracle /oracle/ora10g/bin/dbstart

However, my Oracle DB is 9.2.0.1, and this is path of Network directory

home\app\oracle\procedure\9.2.0\network\admin

Must I start DB? And if I must, please guide me to start DB.

Thank you very much!

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266075 is a reply to message #266073]

Sun, 09 September 2007 09:16

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Please read my previous post for how to startup your database.

you have to give below command on linux prompt.

$ export ORACLE_SID=<sid>
$ export ORACLE_HOME=path
$ ./sqlplus /nolog
SQL> conn / as sysdba

SQL> STARTUP

ORA-12514:
Through NETCA(Network configuration tools configure your TNSNAMES.ORA file for database services names.

open netca
$ ./netca <<hit enter>>

Regards
Taj

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266083 is a reply to message #266075]

Sun, 09 September 2007 10:11

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Yeah! Thank you Taj!

I followed your guide, and I have this error message:

SQL>conn /as sysdba
Connected to the idle instance
SQL>Starup
ORA-00205 error in identifying controlfile, check alert log for more info

Please help me!

Thank you!

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266085 is a reply to message #266083]

Sun, 09 September 2007 10:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-00205 error in identifying controlfile, check alert log for more info

Now follow below procedure.

1. check alert_<sid>.log file and check what is clause of above error message. ( may be controlfile is missing or path is incorrect)

FIX controlfile problem 
If path is incorrect then first edit "init<sid>.ora" file and give right path for controlfile and create spfile from pfile.

if controlfile is missing then restore / recover last valid database backup of controlfile.

2.
SQL>startup

Regards
Taj

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266089 is a reply to message #266085]

Sun, 09 September 2007 11:52

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello trantuananh24hg,

Follow the Mohammad Taj directions.

Also.. check your environment variables.

Can you post the result of the commands below?

set |grep ORACLE
set |grep PATH
whoami

Regards,

mson77

[Updated on: Sun, 09 September 2007 11:53]

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266116 is a reply to message #266089]

Sun, 09 September 2007 19:59

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Thank for all!

I've followed Mohammad direction, and, actually, I found that every controlfiles in /u01/fuji have been removed. And I am trying to restore all of control files.

After I restore them, in RAC, must I issue statement:

SQL>Alter database open resetlog;

Actually, I found that all of datafile, controlfile and redolog file are put in the third device named as sdb3/u01.

This script is often run by system administrator every day

 #!/bin/sh
cd /home/oracle
case $1 in
'start')
     mount /dev/sdb3 /u01
     chown -R oracle.dba /u01
     su - oracle -c /opt/cluster/oracle/startdb.sh
;;
'stop')
     su - oracle -c /opt/cluster/oracle/stopdb.sh
;;
'status')
      su - oracle -c /opt/cluster/oracle/dbmonitor | grep "error"
      if [ $? -eq 0 ] ; then
           service cluster stop
      fi
;;	    
esac

But at Sartuday, one error message occurred like:

"...This device is blocked..."

I tried to mount /dev/sdb3 manually by root, but it did not.

Anybody guide me about this error?

Thank you!

[Updated on: Sun, 09 September 2007 21:02]

Report message to a moderator

Re: How to start all of service in Linux RedHat? [message #266122 is a reply to message #266038]

Sun, 09 September 2007 22:08

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

This error is not oracle related rather OS related. Create another thread or search on Unix forum about this error.

Report message to a moderator

Previous Topic:	10g plus Fedora7 only text mode server installed
Next Topic:	Oracle for Linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 03:34:14 CST 2025