OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » oracle 10g problems (oracle 10g)

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

oracle 10g problems [message #471186]

Thu, 12 August 2010 13:28

sudeep_mansh
Messages: 3
Registered: August 2010
Location: Shimoga

Junior Member

We are using oracle 10g in linux machine which runs as server. And there are around 25 clients which run at the same time parallel to each other. I am new to oracle 10g and also for client-server version of database. I faced some problems when i first put the server into actual use.

-> Users have been created and tablespace is USERS and temporary space is TEMP. RESOURCE privilege is given.
-> Some times login fails for some clients.
-> Some times all the client login will be successful.
-> Query execution will be sometimes fast, but some times it takes too much time.
-> Some times the connection will be lost and again I have bring UP the server.

So please help me to maintain the oracle server.

-> Should I have to make any configuration settings in the server.
-> Should I change any values in the server.
-> Is there any way to properly maintain the server.

Please help me.

Report message to a moderator

Re: oracle 10g problems [message #471188 is a reply to message #471186]

Thu, 12 August 2010 13:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

RESOURCE privilege is given

A very very bad idea. NEVER uses Oracle predefined roles, no one, ever.

Quote:

Some times login fails for some clients.

Without more information, we can't do anything for you. At least an error message is required.

Quote:

Query execution will be sometimes fast, but some times it takes too much time.

Idem (same thing).

Quote:

Some times the connection will be lost and again I have bring UP the server.

Idem.

Quote:

-> Should I have to make any configuration settings in the server.
-> Should I change any values in the server.
-> Is there any way to properly maintain the server.

Hire a consultant for the time (s)he configures your server. I bet you have no backup.

Regards
Michel

Report message to a moderator

Re: oracle 10g problems [message #471331 is a reply to message #471188]

Fri, 13 August 2010 07:49

sudeep_mansh
Messages: 3
Registered: August 2010
Location: Shimoga

Junior Member

Thanks for your reply.

Today there was some advancements. The user space was only 5mb. I raised that to 100 mb. Today disconnection problems were not there. It was running fine. But one client failed. Some query blocked that client. We had to close the browser, and then again tried to relogin, it worked fine.

But dont know why it happened like that.

Any suggestions in this regard.

Report message to a moderator

Re: oracle 10g problems [message #471355 is a reply to message #471331]

Fri, 13 August 2010 10:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Still insufficient data to compute.

Regards
Michel

[Updated on: Sat, 14 August 2010 03:18]

Report message to a moderator

Previous Topic:	ORA-29702 Error
Next Topic:	TNS error, DBCA after database creation script complete

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:51:41 CST 2024