Home » Other » General » Connection (oracle 10g windows 7)
Connection [message #632178] Tue, 27 January 2015 00:08 Go to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
what is the difference between system/password as sysdba and / as sysdba
Re: Connection [message #632179 is a reply to message #632178] Tue, 27 January 2015 00:36 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Read http://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN00102
Re: Connection [message #632181 is a reply to message #632178] Tue, 27 January 2015 01:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

How do you interpret this test?
C:\Users\john>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 27 07:22:19 2015

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

> conn / as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>
orclz> conn system/oracle as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>
orclz> conn system/garbage as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>
Re: Connection [message #632184 is a reply to message #632179] Tue, 27 January 2015 01:56 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
Lalit Kumar B wrote on Tue, 27 January 2015 06:36
Read http://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN00102


thank you
Re: Connection [message #632185 is a reply to message #632181] Tue, 27 January 2015 01:56 Go to previous message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
John Watson wrote on Tue, 27 January 2015 07:26
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

How do you interpret this test?
C:\Users\john>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 27 07:22:19 2015

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

> conn / as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>
orclz> conn system/oracle as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>
orclz> conn system/garbage as sysdba
Connected.
orclz> sho user
USER is "SYS"
orclz>


thank you
Previous Topic: MOS and OTN login down?
Next Topic: Naming convention - schema names
Goto Forum:
  


Current Time: Thu Mar 28 11:45:00 CDT 2024