OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SVRMGRL and SQLPLUS

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

SVRMGRL and SQLPLUS [message #235530]

Mon, 07 May 2007 01:28

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

In 8i version,Why oracle has both SVRMGRL and SQLPLUS ?
Is there a seperate use for both applications ?

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235534 is a reply to message #235530]

Mon, 07 May 2007 01:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Both is same.
Before oracle 9i we used -->SVRMGRL in 9i and onwards -->SQLPLUS
http://www.jlcomp.demon.co.uk/faq/svrmgr.html
Regards
Taj

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235541 is a reply to message #235530]

Mon, 07 May 2007 02:04

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thanks Taj .

Today i had a issue (8i version),while connecting to database from sqlplus .i got error
"ORA-00020: maximum number of processes (300) exceeded"

but from SVRMGRL, i could connect easily and OPEND the database.

after that, SQLPLUS did allow me to connect.

I have a feeling SVRMGRL has some features that SQLPLUS dont have .

Anyoneelse has any such experience ?

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235542 is a reply to message #235541]

Mon, 07 May 2007 02:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

"ORA-00020: maximum number of processes (300) exceeded"

for above error you should increase PROCESSES parameters.

it is static parameter that is why you have to BOUNCE your database.

Which user are you trying to connect

SVRMGRL is internal user.

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235545 is a reply to message #235530]

Mon, 07 May 2007 02:19

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

sqlplus>connect / as sysdba - got max process error

SVRMGRL>connect internal
worked .

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235548 is a reply to message #235530]

Mon, 07 May 2007 02:24

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Hi,
SVRMGR is for Administrative purpose..
(like START/STOP Database ....)
These things cannot be done in Oracle8 using SQLPLUS as in 9i.

Thanks and Regards,
Raja.

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235563 is a reply to message #235530]

Mon, 07 May 2007 03:44

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thank you

Report message to a moderator

Re: SVRMGRL and SQLPLUS [message #235604 is a reply to message #235548]

Mon, 07 May 2007 06:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As Raja already said,
Svrmgr/svrmgrl was the command line interface for administrative purposes. Functinalities were later infused with sqlplus (9i).
use of internal was exclusive for svrmgrl before.

Report message to a moderator

Previous Topic:	How to parallelize table partition move operation
Next Topic:	Cross Platform Database Migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:40:11 CDT 2024