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

[Enrico Venturi]

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

[Piergiacomo Perini · Accepted solution]

Hi Enrico,
you have to use "sqlplus".

Regards

[Yogeeraj_1]

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

[Eric Antunes]

Hi Enrico,

I think svrmgrl was discontinued on Oracle 9i.

Best Regards,

Eric Antunes

[Jean-Luc Oudart]

Enrico

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

(not connect internal)

Regards
Jean-Luc

[Nguyen Anh Tien]

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.

[Enrico Venturi]

sqlplus replaces sqldba.