Home » Infrastructure » Linux » How to start all of service in Linux RedHat?
How to start all of service in Linux RedHat? [message #266038] Sun, 09 September 2007 04:45 Go to next message
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!

Re: How to start all of service in Linux RedHat? [message #266046 is a reply to message #266038] Sun, 09 September 2007 05:11 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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!
Re: How to start all of service in Linux RedHat? [message #266057 is a reply to message #266046] Sun, 09 September 2007 07:19 Go to previous messageGo to next message
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.
Re: How to start all of service in Linux RedHat? [message #266073 is a reply to message #266038] Sun, 09 September 2007 09:10 Go to previous messageGo to next message
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!

Re: How to start all of service in Linux RedHat? [message #266075 is a reply to message #266073] Sun, 09 September 2007 09:16 Go to previous messageGo to next message
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
Re: How to start all of service in Linux RedHat? [message #266083 is a reply to message #266075] Sun, 09 September 2007 10:11 Go to previous messageGo to next message
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!
Re: How to start all of service in Linux RedHat? [message #266085 is a reply to message #266083] Sun, 09 September 2007 10:21 Go to previous messageGo to next message
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
Re: How to start all of service in Linux RedHat? [message #266089 is a reply to message #266085] Sun, 09 September 2007 11:52 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: 10g plus Fedora7 only text mode server installed
Next Topic: Oracle for Linux
Goto Forum:
  


Current Time: Thu Mar 28 13:12:12 CDT 2024