Re:RE: How to create a new oracle database from SVRMGRL??

2003-02-05 Thread dgoulet
Hi Majid, 1)how can I create a new database frm SVRMGRL ? Use DATABASE MIGRATION ASSISTANT, it is more easy to use. 2)can I have more than one database running in oracle8i? Yes you can. Hope this helps. Rgrds, Sony

Re: How to create a new oracle database from SVRMGRL??

2003-02-05 Thread Joan Hsieh
tablespace 5. Create your rollback segment 6. Create all your tablespaces 7. enjoy Joan majid wrote: 1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant

Re: How to create a new oracle database from SVRMGRL??

2003-02-05 Thread Joan Hsieh
.dbf' size 20M; 3. run @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql 4. Create rollback tablespace 5. Create your rollback segment 6. Create all your tablespaces 7. enjoy Joan majid wrote: 1)how can I create a new database frm SVRMGRL ? 2

RE: How to create a new oracle database from SVRMGRL??

2003-02-05 Thread Jacques Kilchoer
Title: RE: How to create a new oracle database from SVRMGRL?? If I may be so bold as to add a few details on a UNIX server you can just fire up sqlplus (or svrmgrl for older versions of Oracle) and issue the create database statement. On a Windows server you must first create the service

How to create a new oracle database from SVRMGRL??

2003-02-04 Thread majid
1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL

RE: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Gogala, Mladen
You should do it from sqldba or you should use ior init. Don't use svrmgrl -Original Message- From: majid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Subject: How to create a new oracle database from SVRMGRL?? 1

Re: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Igor Neyman
1) Read docs on the topic 2) Yes, you can Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 10:50 AM 1)how can I create a new database frm SVRMGRL ? 2)can I have more

Antwort: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Alex . Apostolopoulos
oracle database from SVRMGRL?? [EMAIL PROTECTED

Re: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Igor Neyman
Mladen, you forgot: -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 11:13 AM You should do it from sqldba or you should use ior init. Don't use svrmgrl -Original

Re:How to create a new oracle database from SVRMGRL??

2003-02-04 Thread dgoulet
that you can see what is happening behind the scenes. Dick Goulet Reply Separator Author: majid [EMAIL PROTECTED] Date: 2/4/2003 7:50 AM 1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks

Re:RE: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread dgoulet
Author: Gogala; Mladen [EMAIL PROTECTED] Date: 2/4/2003 8:13 AM You should do it from sqldba or you should use ior init. Don't use svrmgrl -Original Message- From: majid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:50 AM To: Multiple recipients of list ORACLE-L

RE: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Sony kristanto
Hi Majid, 1)how can I create a new database frm SVRMGRL ? Use DATABASE MIGRATION ASSISTANT, it is more easy to use. 2)can I have more than one database running in oracle8i? Yes you can. Hope this helps. Rgrds, Sony

RE: svrmgrl echo v$database in script

2002-10-04 Thread Robertson Lee - lerobe
PROTECTED] Sent: Thursday, October 03, 2002 1:33 PM Hi, This works #!/bin/ksh export ORACLE_SID=ADW export ORACLE_HOME=/usr/app/oracle/product/8.0.5 export PATH=$ORACLE_HOME/bin:$PATH svrmgrl EOF connect internal select name from v_\$database; exit EOF Just escape the $ sign

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
echo $ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle

RE: svrmgrl echo v$database in script

2002-10-03 Thread Rachel Carmichael
- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject:svrmgrl echo v$database in script Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere

RE: svrmgrl echo v$database in script

2002-10-03 Thread Robertson Lee - lerobe
Hi, This works #!/bin/ksh export ORACLE_SID=ADW export ORACLE_HOME=/usr/app/oracle/product/8.0.5 export PATH=$ORACLE_HOME/bin:$PATH svrmgrl EOF connect internal select name from v_\$database; exit EOF Just escape the $ sign with a backslash. HTH Lee -Original Message- [mailto

RE: svrmgrl echo v$database in script

2002-10-03 Thread Deshpande, Kirti
Use \ to escape the $ sign. select name from v_\$database; - Kirti -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle

RE: svrmgrl echo v$database in script

2002-10-03 Thread Fink, Dan
To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down

RE: svrmgrl echo v$database in script

2002-10-03 Thread Kevin Lange
: svrmgrl echo v$database in script Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down.While select name from v$database works fine from

Re: svrmgrl echo v$database in script

2002-10-03 Thread Ruth Gramolini
export PATH=$ORACLE_HOME/bin:$PATH svrmgrl EOF connect internal select name from v_\$database; exit EOF Just escape the $ sign with a backslash. HTH Lee -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:43 To: Multiple recipients of list ORACLE-L echo

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
To: Multiple recipients of list ORACLE-L Subject: RE: svrmgrl echo v$database in script What happens if the ORACLE_SID is set to one value and the caller uses SQL*Net to access a different database? While this is not usually the case in scripts, it could be a problem if the script is parted

Re:RE: svrmgrl echo v$database in script

2002-10-03 Thread dgoulet
echo $ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle 8.0.5

RE: svrmgrl echo v$database in script

2002-10-03 Thread Scott . Shafer
PM To: Multiple recipients of list ORACLE-L Subject: RE: svrmgrl echo v$database in script If fyou want to do it from within a script, you either need to code the select into a .sql file that you run OR you need to escape the $ with a \ in your ksh script --- [EMAIL PROTECTED

RE: RE: svrmgrl echo v$database in script

2002-10-03 Thread Fink, Dan
recipients of list ORACLE-L echo $ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v

Re:RE: RE: svrmgrl echo v$database in script

2002-10-03 Thread dgoulet
$ORACLE_SID logfile Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 6:28 PM To: Multiple recipients of list ORACLE-L Subject: svrmgrl echo v$database in script Oracle 8.0.5 Solaris 2.6

RE: RE: svrmgrl echo v$database in script

2002-10-03 Thread Jared . Still
the needed scripts. Jared Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2002 12:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: svrmgrl echo v$database in script Dick

svrmgrl echo v$database in script

2002-10-02 Thread Baker, Barbara
Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh) called from elsewhere that shuts down the database. I REALLY want to echo the name of the database into my log file before I shut down.While select name from v$database works fine from svrmgrl interactively, it throws up

Re: svrmgrl echo v$database in script

2002-10-02 Thread Ron Thomas
Sounds like you svrmgrl commands are in a where document. You need to escape the $, ie select name from v\$database ; Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: svrmgrl echo v$database in script

2002-10-02 Thread Sujatha Madan
Hi Barbara! Try using a \ before the $. So your script should read: echo Stop oracle instance \${ORACLE_SID}\ at `date` ${ORACLE_HOME}/bin/svrmgrl EOF connect internal select name from v\$database; EOF Cheers Suji -Original Message

RE: svrmgrl echo v$database in script

2002-10-02 Thread Jacques Kilchoer
Title: RE: svrmgrl echo v$database in script The shell thinks that $database is an environment variable. Try instead select name from v\$database -Original Message- From: Baker, Barbara [mailto:[EMAIL PROTECTED]] Oracle 8.0.5 Solaris 2.6 List: I've created a script (ksh

svrmgrl vs. sqlplus

2002-04-11 Thread Michal Zaschke
Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F: Oracle7 Server Release 7.3.4.0.0 with the 64-bit option

RE: svrmgrl vs. sqlplus

2002-04-11 Thread John Weatherman
11, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F

Re: svrmgrl vs. sqlplus

2002-04-11 Thread Michal Zaschke
for all the target instances (78) are the same? Good Luck! John -Original Message- Sent: Thursday, April 11, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use

RE: svrmgrl

2002-02-07 Thread
:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect

Re: svrmgrl

2002-02-07 Thread Igor Neyman
? Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wed, February 06, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl that's because, as Oracle has been promising

RE: svrmgrl

2002-02-07 Thread
: svrmgrl It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you can get. Igor Neyman, OCP DBA [EMAIL PROTECTED

RE: svrmgrl

2002-02-07 Thread
You also need to be an administrator. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Igor Neyman [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl It's

RE: svrmgrl

2002-02-07 Thread Rachel Carmichael
To: Multiple recipients of list ORACLE-L Subject:Re: svrmgrl It's an equivalent of 'internal' login, that's why you can access any table. On NT you'll be able to do : 'connect / as sysdba', only if you are logged into NT as a member of ORA_DBA group. That's as much security as you

RE: svrmgrl

2002-02-07 Thread hemantchitale
Well oracle IS the owner of the database. oracle has connected to the database as SYS. This is similar to connecting as INTERNAL. Go back to any database you have running the earlier versions of Oracle, connect as INTERNAL in svrmgrl and ask the same question again. Hemant K

svrmgrl

2002-02-06 Thread New2orcl
Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: svrmgrl

2002-02-06 Thread Rachel Carmichael
that's because, as Oracle has been promising, they no longer support svrmgrl in 9i. It does not exist, you will need to use sqlplus: sqlplus /nolog connect / as sysdba --- [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please

RE: svrmgrl

2002-02-06 Thread Carle, William T (Bill), ALINF
srvmgrl no longer exists in 9i. You do everything through sqlplus. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject:svrmgrl Hi, Where can

RE: svrmgrl

2002-02-06 Thread Ji, Richard
You should use sqlplus instead of svrmgrl now. -Original Message- Sent: Wednesday, February 06, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ: http

Re: svrmgrl

2002-02-06 Thread Joe Raube
It no longer exists -- all related functionality has been incorporated into sqlplus. Read the release notes and bulletins. -Joe On Wed, 06 Feb 2002 10:43:34 -0800 [EMAIL PROTECTED] wrote: Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see

RE: svrmgrl

2002-02-06 Thread Deshpande, Kirti
You will not find it in 9i, because they have taken it away. It doesn't exist starting from 9i. We have to use 'sqlplus' for everything we did using 'svrmgrl'. I suggest you check out the 9i docs at : http://tahiti.oracle.com/ as there are a lot of new features in 9i. - Kirti -Original

RE: svrmgrl

2002-02-06 Thread Farnsworth, Dave
Didn't Oracle get rid of SVRMGRL in 9i?? -Original Message- Sent: Wednesday, February 06, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ: http

RE: svrmgrl

2002-02-06 Thread Clinton Naude
Title: RE: svrmgrl svrmgrl no longer exists on 9i. You must use sqlplus. Clint -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Subject: RE: svrmgrl Didn't Oracle get rid

RE: svrmgrl

2002-02-06 Thread Robertson Lee - lerobe
I guess that'll be because it doesn't exist anymore !!! -Original Message- Sent: 06 February 2002 18:44 To: Multiple recipients of list ORACLE-L Hi, Where can I find svrmgrl in 9i. It is not in the same place as 8i. Thanks -- Please see the official ORACLE-L FAQ: http

RE: Need some help PLEASE on an ora 3113 in svrmgrl

2002-01-29 Thread SARKAR, Samir
to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink

Need some help PLEASE on an ora 3113 in svrmgrl

2002-01-28 Thread Bill Conner
Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine

RE: Need some help PLEASE on an ora 3113 in svrmgrl

2002-01-28 Thread Khedr, Waleed
everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost

RE: Message at the start of svrmgrl

2001-12-04 Thread Nirmal Kumar Muthu Kumaran
Title: RE: Message at the start of svrmgrl What are the new things on oracle 8.1.7.2.1 patch. is't available on oracle downloads...? I'm much interested to know why should apply this patch is it for to rectify some bugs or something else... Rgds, Nirmal -Original

Message at the start of svrmgrl

2001-12-03 Thread Anand Prakash
I have just done installation of 8.1.7.0 on a Compaq Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors. When I start svrmgrl I see a line "inst emulated pid=175364...". --$ svrmgrlinst emulated pid=175364 svrmgrl va=0x11fffa358 pc=0x1205c0148 inst=

RE: Message at the start of svrmgrl

2001-12-03 Thread Hand, Michael T
Anand, I installed the same(? 8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only

RE: Message at the start of svrmgrl

2001-12-03 Thread Anand Prakash
this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only executable responding like this. If so, try relinking. Mike Hand Polaroid Corp. -Original

RE: Message at the start of svrmgrl

2001-12-03 Thread Sunil_Nookala
Hello all, could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a minuteona table with 50,000 rows and about 21 mins on a table with 235,000 rows?? Ihave created a bigger rollback segment to take care of this, but no improvement.where should i be

Recall: Message at the start of svrmgrl

2001-12-03 Thread Sunil_Nookala
Nookala, Sunil would like to recall the message, Message at the start of svrmgrl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Message at the start of svrmgrl

2001-12-03 Thread Koivu, Lisa
Title: RE: Message at the start of svrmgrl Did you trace the statement? Send a trace to the list. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Message at the start

AW: Terminal Server / svrmgrl

2001-11-28 Thread Schoen Volker
Title: Nachricht I'm running 8.1.6 SE on W2K with terminal services enabled. svrmgrl and sqlplus are running fine, no problems. If your connect internal doesnt't work try "connect internal@your_instance". What are the error messages you get? regards Volker Schoen E-Mail: mai

svrmgrl and W2k

2001-11-27 Thread Koivu, Lisa
Title: svrmgrl and W2k OH MY GOSH this sucks. Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and the listener, for that matter) via Terminal Server and it keeps erring out with ORA-12560 protocol adapter error. I look on Metalink and it just plain says, Go

Re: SVRMGRL and W2K

2001-11-27 Thread DBarbour
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server

Terminal Server / svrmgrl

2001-11-27 Thread Koivu, Lisa
Title: Terminal Server / svrmgrl ZP? As in Zip It? Just really really frustrating. Thanks Ross and Michael Lisa -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: RE: ok

RE: SVRMGRL and W2K

2001-11-27 Thread Koivu, Lisa
Title: RE: SVRMGRL and W2K Thanks David!! Lisa -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: SVRMGRL and W2K Lisa, Got bit by this first time out of the box

RE: svrmgrl and W2k

2001-11-27 Thread Jack C. Applewhite
Title: svrmgrl and W2k Lisa, I'm running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl using internal@test or internal@dev. Works just fine.Am I missing part of the problem? Jack

RE: svrmgrl, sqlplus question ???

2001-08-28 Thread Nirmal Kumar Muthu Kumaran
Subject: svrmgrl, sqlplus question ??? Hi all, In sqlplus, you can use col ... format ... to make the output pretty. Can we format columns, make title in svrmgrl? Also I read that sqlplus can be used to mount, open database in 8i, but I don't see how. The db is 815 on Sun 5.6

Re: svrmgrl, sqlplus question ???

2001-08-28 Thread Paul Drake
, August 28, 2001 12:21 AM To: Multiple recipients of list ORACLE-L Subject: svrmgrl, sqlplus question ??? Hi all, In sqlplus, you can use col ... format ... to make the output pretty. Can we format columns, make title in svrmgrl? Also I read that sqlplus can be used to mount

RE: svrmgrl, sqlplus question ???

2001-08-28 Thread Nirmal Kumar Muthu Kumaran
Hi pual, i just replied for 'how to do db activities through SQLplus'. Nirmal. -Original Message- From: Paul Drake [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: svrmgrl, sqlplus question ??? yes

Re: svrmgrl, sqlplus question ???

2001-08-28 Thread Thater, William
Charlie Mengler wrote: RANT When I'm logged onto the Unix system as user oracle using 9i, Oracle refuses to allow me to log into it by just using /. It insists that always include the two words / as sysdba! Since it precludes me from logging into Oracle just using /, what is gained by forcing

Re: svrmgrl, sqlplus question ???

2001-08-28 Thread Ruth Gramolini
That was how I learned to log on when I first was using 8.0.x at Oracle classes. They said that internal was going away and that would be the way to log on from now on. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001

svrmgrl, sqlplus question ???

2001-08-27 Thread Janet Linsy
Hi all, In sqlplus, you can use col ... format ... to make the output pretty. Can we format columns, make title in svrmgrl? Also I read that sqlplus can be used to mount, open database in 8i, but I don't see how. The db is 815 on Sun 5.6. Thank you! Janet

Re: svrmgrl, sqlplus question ???

2001-08-27 Thread Thater, William
Janet Linsy wrote: Hi all, In sqlplus, you can use col ... format ... to make the output pretty. Can we format columns, make title in svrmgrl? AFAIK, you can't. Also I read that sqlplus can be used to mount, open database in 8i, but I don't see how. invoke sqlplus and at the username

Re: svrmgrl, sqlplus question ???

2001-08-27 Thread Rachel Carmichael
you cannot format in svrmgrl and you should start learning to use sqlplus for this stuff, as svrmgrl goes away in 9i in sqlplus what I do is: sqlplus then at the username prompt I type / as sysdba once you do that you can do startup and shutdown From: Janet Linsy [EMAIL PROTECTED] Reply

Re: svrmgrl, sqlplus question ???

2001-08-27 Thread Charlie Mengler
as sysdba, too /RANT Rachel Carmichael wrote: you cannot format in svrmgrl and you should start learning to use sqlplus for this stuff, as svrmgrl goes away in 9i in sqlplus what I do is: sqlplus then at the username prompt I type / as sysdba once you do that you can do startup

Re: Error conecting by svrmgrl

2001-07-20 Thread Christian Trassens
and on the MS-DOS screen try with a set LOCAL=ORACLE_SID. Regards. --- Eca Eca [EMAIL PROTECTED] wrote: Friends : I have a database Oracle installed in NT. I have deleted the service and rebuild it again. Now, when I try to connect in the database using svrmgrl i received a error message

Error conecting by svrmgrl

2001-07-19 Thread Eca Eca
Friends : I have a database Oracle installed in NT. I have deleted the service and rebuild it again. Now, when I try to connect in the database using svrmgrl i received a error message. Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol

svrmgrl error

2001-05-21 Thread Leyden, Joseph
Has anyone seen this error and found what the solution was? Hoping for a long shot here Joe $ svrmgrl exec(): 0509-036 Cannot load program svrmgrl because of the following errors: 0509-130 Symbol

Re: svrmgrl error

2001-05-21 Thread Joseph S. Testa
look at relinking the svrmgrl executable, ensure there is no 7.3 libraries in path BEFORE the 8.x libs(assuming an 8.x database). you got metalink, search for it, i'm 90% sure its on there. joe Leyden, Joseph wrote: Has anyone seen this error and found what the solution was? Hoping

RE: svrmgrl error

2001-05-21 Thread Leyden, Joseph
$ svrmgrl exec(): 0509-036 Cannot load program svrmgrl because of the following errors: 0509-130 Symbol resolution failed for /usr/lib/libc_r.a(aio.o) because: 0509-136 Symbol kaio_rdwr (number 0) is not exported from dependent module /unix

svrmgrl return code

2001-05-14 Thread Adams, Matthew (GEA, 088130)
Title: svrmgrl return code on unix (hpux 11) can svrmgrl return any value other than a zero (0)? even a exit 1 returns a 0 to the calling script R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.

RE: svrmgrl return code

2001-05-14 Thread Deshpande, Kirti
of list ORACLE-L Subject: svrmgrl return code on unix (hpux 11) can svrmgrl return any value other than a zero (0)? even a exit 1 returns a 0 to the calling script R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff

RE: 7.3.4 svrmgrl requiring password if called by root user

2001-04-11 Thread Steve McClure
Thanks everyone who responded to my request. I am still unsure why svrmgrl would prompt for a password, but I was able to solve the problem by extracting my dump2 commands from the PERL script that was doing my regular backup. So now I have root's crontab call a new shell script, that first SUs

RE: 7.3.4 svrmgrl requiring password if called by root user

2001-04-03 Thread Claudio Roca
running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are no

RE: 7.3.4 svrmgrl requiring password if called by root user

2001-04-03 Thread Scott . Shafer
To: Multiple recipients of list ORACLE-L Subject: 7.3.4 svrmgrl requiring password if called by root user My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my

Re: Summary : Svrmgrl connect internal asks for password??

2001-03-16 Thread Rotimi O. Gbadamosi
ot;Content-Type" CONTENT="text/html; charset=iso-8859-1" TITLERE: Summary : Svrmgrl "connect internal" asks for password??/TITLE META content="MSHTML 5.00.3103.1000" name=GENERATOR/HEAD BODY DIVFONT color=#ff face=Arial size=2SPAN class=127495920-1503200

Summary : Svrmgrl connect internal asks for password??

2001-03-15 Thread Fowler, Kenneth R
Finally managed to fix my problem. Thanks to Charlie Mengler, Christian Trassens, Djordje, Riyaj Shamsudeen, Ross Mohan, Terry Ball and Trivedi Hitarth who gave me many points to check (SQL*net config, $ORACLE_HOME/rdbms/audit space and protection, TWO Task etc etc). It turns out that the

RE: Summary : Svrmgrl connect internal asks for password??

2001-03-15 Thread Mohan, Ross
Title: RE: Summary : Svrmgrl connect internal asks for password?? Ken, Thank you for two things...giving credit where you deemed credit was due...and *especially* echoing your post-research results back to the list. You are -- and I mean this with some gratitude -- an excellent model

RE: Summary : Svrmgrl connect internal asks for password??

2001-03-15 Thread Fowler, Kenneth R
Title: RE: Summary : Svrmgrl "connect internal" asks for password?? And thank you all for taking time out of your day to help me... this list has so many helpful and knowledgeable people. I am still quite new to oracle but hopefully someday will be able to respond to other

RE: Svrmgrl connect internal asks for password??

2001-03-08 Thread Trassens, Christian
Kenneth, The password file could be another reason for svrmgrl asking you a password. Regards. -Mensaje original- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 7 de marzo de 2001 19:07 Para: Multiple recipients of list ORACLE-L Asunto: Re: Svrmgrl

RE: Svrmgrl connect internal asks for password??

2001-03-08 Thread Ben Poels
of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 1:06 PM Try looking in $ORACLE_HOME/rdbms/audit directory. If this directory is full, it can not create the .aud file to log that someone is using svrmgrl and will ask for password. Terry "Fowler, Kenneth R" wrot

RE: Svrmgrl connect internal asks for password??

2001-03-07 Thread Trassens, Christian
: Multiple recipients of list ORACLE-L Asunto: Re: Svrmgrl "connect internal" asks for password?? give default password "oracle" From: "Fowler, Kenneth R" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAI

RE: Svrmgrl connect internal asks for password??

2001-03-07 Thread Mohan, Ross
Title: RE: Svrmgrl connect internal asks for password?? Metalink: 114384.1 -Original Message- From: Terry Ball [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: Svrmgrl connect internal asks for password?? Try

RE: Svrmgrl connect internal asks for password??

2001-03-07 Thread Fowler, Kenneth R
Something I forgot to mention in the original post... I am trying to create test databases (one for Oracle 8.1.6 and one for Oracle 8.1.7). The database creation scripts and the parameter files are created from templates and thus all parameters are pretty much equivalent except in places where

Re: svrmgrl ...only startup command not working

2001-03-05 Thread Ruth Gramolini
e to start my database also.. At the svrmgrl prompt when I give svrmgrl startup it suddenly comes on a $ promp and does not gives any error also but when I give a wrong ORACLE_SID in the environment then it search for the corresponding init parameter file and gives error. I have removed all

Re: svrmgrl ...only startup command not working

2001-03-05 Thread Ruth Gramolini
database also.. At the svrmgrl prompt when I give svrmgrl startup it suddenly comes on a $ promp and does not gives any error also but when I give a wrong ORACLE_SID in the environment then it search for the corresponding init parameter file and gives error. I have removed all the extra param

Re: svrmgrl ...only startup command not working

2001-03-04 Thread dgoulet
database also.. At the svrmgrl prompt when I give svrmgrl startup it suddenly comes on a $ promp and does not gives any error also but when I give a wrong ORACLE_SID in the environment then it search for the corresponding init parameter file and gives error. I have removed all the extra parameters from

Re: svrmgrl vs sys account

2001-03-04 Thread dgoulet
is the only account that I allow to be shared. Dick Goulet -- Reply Separator -- Author: [EMAIL PROTECTED] Date: 3/2/01 5:50 PM Hi, I am a beginner DBA could you tell me what is the diffrent: create user /tablespace or else using svrmgrl and sys account oh ya.

Re: svrmgrl ...only startup command not working

2001-03-04 Thread Ramamohan B N
Author: [EMAIL PROTECTED] Date: 3/2/01 9:55 PM Hi all, This is a special problem I am facing and hence I am not able to start my database also.. At the svrmgrl prompt when I give svrmgrl startup it suddenly comes on a $ promp and does not gives any error also but when I give a wrong

svrmgrl vs sys account

2001-03-02 Thread sinardyxing
Hi, I am a beginner DBA could you tell me what is the diffrent: create user /tablespace or else using svrmgrl and sys account oh ya.. I'm using Oracle8i Thank you very much -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

RE:Invoking svrmgrl

2001-03-01 Thread GANTI . SIVA
svrmgrlFILE(Or any other symbol ! ,some mark) connect user/password@my_db @c:\temp\my_script.sql FILE(end of mark) Cheers GANTI -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Invoking svrmgrl

2001-03-01 Thread Witold Iwaniec
user/password@my_db @c:\temp\my_script.sql but I think in some minimal installations you may not have sqlplus installed. I thought about calling svrmgrl but I don't think it accepts command line parameters. I tried to write small batch file: svrmgrl connect user/password@my_db @c:\temp

  1   2   >