OraFAQ Forum: Weblogic & Application Server » problem in starting oracle

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » problem in starting oracle (

) 1 Vote

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

problem in starting oracle [message #203162]

Tue, 14 November 2006 03:05

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi
i installed oracle 9i in linux . which has two user root as well as oracle . but oracle runs gud in oracle user with sqlplus .but i doesn't run on root user .
it says error TNS lost contact
so anybody plz help me

Report message to a moderator

Re: problem in starting oracle [message #203345 is a reply to message #203162]

Tue, 14 November 2006 19:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why are you trying to run it as 'root'? If it works as 'oracle' that should be enough. There are environemnt variables that exist under the 'oracle' user which 'root' does not see automatically. If you HAVE to run as 'root' then you have to add the 'oracle' directories to 'root's paths.

David

Report message to a moderator

Re: problem in starting oracle [message #203367 is a reply to message #203345]

Tue, 14 November 2006 22:51

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi
thanks for ur reply . i try to run oracle in root because my java
and server r installed only in root user,i accept with ur conversation , say me how add oracle directories in root path , ya u said is wright the environmental variables is seen by oracle user but not as root , how to make it see to evry user....

byeee

Report message to a moderator

Re: problem in starting oracle [message #203373 is a reply to message #203367]

Tue, 14 November 2006 23:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please do not use IM speak It makes posts very hard to read.

I believe that the Oracle server should also be under Oracle and I thought that the Java would be available to all users.

Please look in the 'Application Server' forum for threads on Server installation.

David

Report message to a moderator

Re: problem in starting oracle [message #203385 is a reply to message #203373]

Wed, 15 November 2006 00:05

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi
how to set oracle avail for all users .... wat must b done
thanks

Report message to a moderator

Re: problem in starting oracle [message #203388 is a reply to message #203385]

Wed, 15 November 2006 00:14

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This is the 'Forms forum, please go to the 'Server Administration' forum and search there.

David

Report message to a moderator

Re: problem in starting oracle [message #203437 is a reply to message #203162]

Wed, 15 November 2006 02:40

zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan

Senior Member

Just login as root user and open .bash_profile and add the paths of Oracle software like

ORACLE_HOME=/<where oracle installed>
ORACLE_SID=database_sid
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/dcm/bin

etc...
in the root's .bash_profile
But it is better that just oracle would be the owner of Oracle related file because root users can stop/start the services and delete the files.
Zeeshan Ali AWan

Report message to a moderator

Re: problem in starting oracle [message #203446 is a reply to message #203437]

Wed, 15 November 2006 03:01

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

hi
its ok . then how to set rights for other user other than oracle only to start and stop permission of database and nothing else

bye

Report message to a moderator

Re: problem in starting oracle [message #208805 is a reply to message #203162]

Tue, 12 December 2006 05:01

mnrnjn
Messages: 61
Registered: November 2006
Location: india

Member

Report message to a moderator

Re: problem in starting oracle [message #209055 is a reply to message #203446]

Wed, 13 December 2006 02:10

zeshanali76
Messages: 180
Registered: January 2006
Location: Pakistan

Senior Member

U know my dear friend that there are two roles sysdba and sysoper that two roles can start and stop the database and sysdba can also create a new database.

About starting and stoping the Oracle Database I can understand ur requirement to give permissions to other users. Keep it in ur hand r give these roles to other users on whom u can trust. moslty Oracle user issues that commands to stop and start the database.

Zeeshan Ali Awan
zesh76@msn.com

Report message to a moderator

Previous Topic:	Oracle Applications Passwords Decryption Vulnerability.
Next Topic:	Hardware requirements Oracle 10gR2 AS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 02 02:16:12 CDT 2025