General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE 9: what's available for sqldba /svrmgrl?

SOLVED
Go to solution
Enrico Venturi
Super Advisor

ORACLE 9: what's available for sqldba /svrmgrl?

Hello colleagues,
I've installed ORACLE 9;
I've a lot of scripts using sqldba utility; when we migrated to ORACLE 8 we'd to use svrmgrl, so we created a logical link from it to sqldba; now, in ORACLE 9 we don't see any utility equivalent to sqldba ....

what we have to do???

thanks a lot
Enrico
6 REPLIES
Piergiacomo Perini
Trusted Contributor
Solution

Re: ORACLE 9: what's available for sqldba /svrmgrl?

Hi Enrico,
you have to use "sqlplus".

Regards
Yogeeraj_1
Honored Contributor

Re: ORACLE 9: what's available for sqldba /svrmgrl?

hi Enrico,

you will have to use sqlplus.

e.g.

$ sqlplus /nolog

SQL*Plus: Release 9.x.x.x.x - Production on Tue Oct 11 14:37:15 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> show sga

Total System Global Area xxxxxxxxx bytes
Fixed Size bbbbbbb bytes
Variable Size sssssssss bytes
Database Buffers ccccccccc bytes
Redo Buffers zzzzzz bytes
SQL>


same functionalities as svrmgrl

you can also do, "show parameter" , "show sga" etc

hope this helps too!

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: ORACLE 9: what's available for sqldba /svrmgrl?

Hi Enrico,

I think svrmgrl was discontinued on Oracle 9i.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Jean-Luc Oudart
Honored Contributor

Re: ORACLE 9: what's available for sqldba /svrmgrl?

Enrico

sqldba is long gone 7.x
svrmgrl gone with 9i onwards
use sqlplus "/ as sysdba"

(not connect internal)

Regards
Jean-Luc
fiat lux
Nguyen Anh Tien
Honored Contributor

Re: ORACLE 9: what's available for sqldba /svrmgrl?

sqldba/svrmgrl is not avalable in Oracle9i.
you must use sqlplus command
For example:
#sqlplus /nolog

SQL*Plus: Release 9.2.1.01 - Production on Tue Oct 11 16:39:15 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> connect /as sysdba
Connected.
HP is simple
Enrico Venturi
Super Advisor

Re: ORACLE 9: what's available for sqldba /svrmgrl?

sqlplus replaces sqldba.