Home » RDBMS Server » Server Administration » SVRMGRL and SQLPLUS
SVRMGRL and SQLPLUS [message #235530] Mon, 07 May 2007 01:28 Go to next message
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 ?
Re: SVRMGRL and SQLPLUS [message #235534 is a reply to message #235530] Mon, 07 May 2007 01:36 Go to previous messageGo to next message
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
Re: SVRMGRL and SQLPLUS [message #235541 is a reply to message #235530] Mon, 07 May 2007 02:04 Go to previous messageGo to next message
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 ?
Re: SVRMGRL and SQLPLUS [message #235542 is a reply to message #235541] Mon, 07 May 2007 02:09 Go to previous messageGo to next message
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.

Re: SVRMGRL and SQLPLUS [message #235545 is a reply to message #235530] Mon, 07 May 2007 02:19 Go to previous messageGo to next message
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 .

Re: SVRMGRL and SQLPLUS [message #235548 is a reply to message #235530] Mon, 07 May 2007 02:24 Go to previous messageGo to next message
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
.
Re: SVRMGRL and SQLPLUS [message #235563 is a reply to message #235530] Mon, 07 May 2007 03:44 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thank you
Re: SVRMGRL and SQLPLUS [message #235604 is a reply to message #235548] Mon, 07 May 2007 06:46 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: How to parallelize table partition move operation
Next Topic: Cross Platform Database Migration
Goto Forum:
  


Current Time: Sat Dec 10 01:00:36 CST 2016

Total time taken to generate the page: 0.11348 seconds