If have an X display, you may run OEM tools from unix with "oemapp". This is like the MSWindows OEM: oemapp console
Looks in $ORACLE_HOME/bin for oemapp.
Thursday, March 16, 2006
Oracle SQLPlus Without Password
Many Oracle administrators are concerned about hard-coding passwords
in scripts and crontabs. Oracle 9i from the command line allows a simple
logon like this: oracle@bighost $ sqlplus '/ as sysdba'
This provides a simple method to run scripts without a password.
Another method is to create and externally authenticated account, such as
ops$oracle. Then log on with: oracle@bighost $ sqlplus /
When using either method, remember to set up the shell environment
variables before running sqlplus.
in scripts and crontabs. Oracle 9i from the command line allows a simple
logon like this: oracle@bighost $ sqlplus '/ as sysdba'
This provides a simple method to run scripts without a password.
Another method is to create and externally authenticated account, such as
ops$oracle. Then log on with: oracle@bighost $ sqlplus /
When using either method, remember to set up the shell environment
variables before running sqlplus.
Tuesday, March 14, 2006
Oracle SQL Developer
Oracle has released SQL Developer, a no-charge GUI tool for developers.
Quest has sold TOAD for several years, though hasn't done much develop in recent years. When in a software development office, the morning are filled with the croaking toad sound when developers start the application.
Tora is an open source package that has similar functionality.
Quest has sold TOAD for several years, though hasn't done much develop in recent years. When in a software development office, the morning are filled with the croaking toad sound when developers start the application.
Tora is an open source package that has similar functionality.
Subscribe to:
Posts (Atom)