Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » problem in starting oracle  () 1 Vote
icon9.gif  problem in starting oracle [message #203162] Tue, 14 November 2006 03:05 Go to next message
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




Re: problem in starting oracle [message #203345 is a reply to message #203162] Tue, 14 November 2006 19:22 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #203367 is a reply to message #203345] Tue, 14 November 2006 22:51 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #203373 is a reply to message #203367] Tue, 14 November 2006 23:07 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #203385 is a reply to message #203373] Wed, 15 November 2006 00:05 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
hi
how to set oracle avail for all users .... wat must b done
thanks
Re: problem in starting oracle [message #203388 is a reply to message #203385] Wed, 15 November 2006 00:14 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #203437 is a reply to message #203162] Wed, 15 November 2006 02:40 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #203446 is a reply to message #203437] Wed, 15 November 2006 03:01 Go to previous messageGo to next message
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
Re: problem in starting oracle [message #208805 is a reply to message #203162] Tue, 12 December 2006 05:01 Go to previous messageGo to next message
mnrnjn
Messages: 61
Registered: November 2006
Location: india
Member
Hi
Re: problem in starting oracle [message #209055 is a reply to message #203446] Wed, 13 December 2006 02:10 Go to previous message
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
Previous Topic: Oracle Applications Passwords Decryption Vulnerability.
Next Topic: Hardware requirements Oracle 10gR2 AS
Goto Forum:
  


Current Time: Fri Mar 29 06:53:52 CDT 2024