RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
Title: RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
Try rman target / (No quotes and no as sysdba)
-Original Message-
From: Roger Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
bigtex:oraadm 7% rman target / as sysdba
Argument Value Description
-
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN- prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
-
Both single and double quotes (' or ) are accepted for a quoted-string. Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-00552: syntax error in command line arguments
RMAN-01005: syntax error: found identifier: expecting one of: append, at, auxiliary, catalog, cmd file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, slaxdebug, send, target, time out, trace
RMAN-01008: the bad identifier was: as
RMAN-01007: at line 0 column 4 file: command line arguments bigtex:oraadm 8% rman target system/manager
Recovery Manager: Release 9.2.0.3.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DV2 (DBID=3650624848)
RMAN exit
Recovery Manager complete.
bigtex:oraadm 9% sqlplus / as sysdba
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production
SQL show user
USER is SYS
SQL exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production bigtex:oraadm 10%
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus newbie: How do I retrieve the last command I ran in a
Title: RE: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? You can either use the / key to re-run the last command, or you can type ed and enter to edit the last command. Then when you are finished editing, save the changes, and when you return to the SQL command prompt, just hit the / key again. -Scott Stefick -Original Message- From: Roger Xu [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? Hi, How do I retrieve the last commands I ran in a sqlplus session? I remembe in the training class, I were able to use arrow keys in Windows platform. But in Solaris 9/UNIX platform, it does NOT work. Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: 9i OCP Details
Title: RE: Re: 9i OCP Details It's well worth the begging. I went in April and it was a GREAT class. I suggest you do what you can to get there. -Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 26, 2003 7:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: Re: 9i OCP Details hotsos is going to be in town next week and im 'trying' get my boss to send me. slow economy. people dont want to spend money on training. :( hope it doesnt fill up before he makes up his mind. From: Gudmundur Bjarni Josepsson [EMAIL PROTECTED] Date: 2003/06/26 Thu AM 05:49:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: 9i OCP Details If you want real advanced courses go with [...] what Jonathan Lewis or guys at his level provide. I have to agree on this. I've had the good fortune to sit in on Lewis's 'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course I ever took from Oracle Education comes close to what these guys offer (and I've taken quite a few). Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
