dbTalk Databases Forums  

How to access Oracle DB under Solaris System?

comp.database.oracle comp.database.oracle


Discuss How to access Oracle DB under Solaris System? in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel Mark
 
Posts: n/a

Default How to access Oracle DB under Solaris System? - 08-27-2004 , 10:48 AM






Hello all:

I want to know how to access Oracle DB under Solaris System.

I could access the Oracle DB with system administrator permission under
windows 2000 where the oracle is installed.

however, I cannot user sqlplus + username to access my oracle DB as
DBA.
<beasta:>sqlplus sysdba

SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 27 10:45:31 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
Enter user-name: ^C<hestia:>^C
<hestia:>

I am totally new to this DBA duty.

does anyone give me some comments?



thank you
-Daniel

Reply With Quote
  #2  
Old   
Daro
 
Posts: n/a

Default Re: How to access Oracle DB under Solaris System? - 08-27-2004 , 11:28 AM






Dnia 08/27/2004 05:48 PM, Użytkownik Daniel Mark napisał:

Quote:
beasta:>sqlplus sysdba

SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 27 10:45:31 2004

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
Enter user-name: ^C<hestia:>^C
hestia:

I am totally new to this DBA duty.

does anyone give me some comments?



thank you
-Daniel
ROTFL

Read!!! > Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]

example: sqlplus sys@base as sysdba

RTFM!!!

Daro.


Reply With Quote
  #3  
Old   
Daniel Mark
 
Posts: n/a

Default Re: How to access Oracle DB under Solaris System? - 08-31-2004 , 01:32 PM



Hello Daro:

Quote:
Read!!! > Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]

example: sqlplus sys@base as sysdba
I still met problem to access Oracle DB as sys admin.

May you write the command for me?

given the sys admin user name is : 'sys' with password as '1234'
the connection string is 'cs610':

i try the command as follows, however it failed

Quote:
sqlplus sys/1234@cs610 as sysdba

thank you again


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.