Oracle8i finalpatch 2005-02-03 - By Paul Foerster
Hi Reinhold, hi Frank,
On 03. Feb, 2005, at 17:43, Frank Grote wrote:
> What's about "sqlplus internal"?
... no. The correct syntax is sqlplus "/ as sysdba". The use of both
"svrmgrl" and the pseudo user "internal" is deprecated from versions 8i
and newer. The quoting of the "/ as sysdba" part is operating system
dependant and may vary from OS to OS. You might end up with one of the
following (not complete) list:
sqlplus "/ as sysdba"
sqlplus '"/ as sysdba"'
sqlplus "'/ as sysdba'"
It depends on how the shell interprets the parameters and quotes.
Or you can obviously do
sqlplus
Username: / as sysdba
> Listener is running?
... internal or sysdba connects do not use the listener unless you
provide the instannce name. In this case you'd need to do it this way
(quoting variations from above apply):
sqlplus sys@(protected)
Or, if you have a password file:
sqlplus "sys@(protected) as sysdba"
The latter is also used with 9i which requires a password file if you
intend to do an SQL*Net connect, ie. use the listener.
Hope this helps.
--
cul8er
Paul
paul.foerster@(protected)
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
