Home » RDBMS Server » Server Administration » sql connectivity problems
sql connectivity problems [message #54399] Fri, 15 November 2002 02:32 Go to next message
Silke Booms
Messages: 2
Registered: November 2002
Junior Member
Hello,
I've a problem with oracle's sqlplus on a SUN maschine. If a try to perform a sqlplus statement I'll get the message "oracle not avaiable". If the same UNIX user is put into the UNIX group "dba" the sqlplus statement succeeds. The environment settings were not changed with the exception that user got an additionally UNIX group.
Is there anybody who has an idea what the problem could be?

Thanks for your help, Silke

Report message to a moderator

Re: sql connectivity problems [message #54405 is a reply to message #54399] Fri, 15 November 2002 04:45 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
did U try to connect internal ?

Report message to a moderator

Re: sql connectivity problems [message #54407 is a reply to message #54405] Fri, 15 November 2002 04:59 Go to previous messageGo to next message
silke
Messages: 3
Registered: November 2002
Junior Member
The oracle instance is installed on the same maschine I'am working on. Nevertheless, the connect with oracle's DBA Studio went well.

Silke

Report message to a moderator

Re: sql connectivity problems [message #54410 is a reply to message #54405] Fri, 15 November 2002 08:31 Go to previous messageGo to next message
F. Tollenaar
Messages: 64
Registered: November 2002
Member
You have to startup the database before any subordinate user can connect.

Report message to a moderator

Re: sql connectivity problems [message #54417 is a reply to message #54399] Fri, 15 November 2002 13:39 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
First check your connect string - it should be

SQL>connect user/password@service_name

in both cases.

Second, check the permissions on these files

${ORACLE_HOME}/bin/oracle -rwsr-s--x (6751) ${ORACLE_HOME}/bin/tnslsnr -rwsr-xr-x (4755)

These files has to be owned by oracle user and dba group. If not then that's why your user w/o dba group is getting the above error.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: sql connectivity problems [message #54427 is a reply to message #54417] Mon, 18 November 2002 00:02 Go to previous messageGo to next message
silke
Messages: 3
Registered: November 2002
Junior Member
I've controlled these files. They exactly have the right you've written. But the connection still doesn't work. It seems to be something misterious.

Silke

Report message to a moderator

Re: sql connectivity problems [message #55197 is a reply to message #54417] Fri, 10 January 2003 01:05 Go to previous message
nidhi
Messages: 22
Registered: March 2002
Junior Member
We have win-2000 server operating system and sql-7.0.
We have a problem in export our database to our host server where our our web site is hosted. We have IP address as well as user Id and password of our remote server but when we insert all these details even then it shows "sql server not found"

Report message to a moderator

Previous Topic: set pause on crashing sql *plus;
Next Topic: kill database sessions and processes that are no longer in use
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:37:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.