OraFAQ Forum: General

Home » Other » General » Connection (oracle 10g windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connection [message #632178]

Tue, 27 January 2015 00:08

hdba
Messages: 16
Registered: January 2015
Location: INDIA

Junior Member

what is the difference between system/password as sysdba and / as sysdba

Report message to a moderator

Re: Connection [message #632179 is a reply to message #632178]

Tue, 27 January 2015 00:36

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

Report message to a moderator

Re: Connection [message #632181 is a reply to message #632178]

Tue, 27 January 2015 01:26

John Watson
Messages: 8970
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>

Report message to a moderator

Re: Connection [message #632184 is a reply to message #632179]

Tue, 27 January 2015 01:56

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

Report message to a moderator

Re: Connection [message #632185 is a reply to message #632181]

Tue, 27 January 2015 01:56

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

Report message to a moderator

Previous Topic:	MOS and OTN login down?
Next Topic:	Naming convention - schema names

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 21:52:46 CDT 2025