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
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
.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
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
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
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
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
oracle
database from SVRMGRL??
[EMAIL PROTECTED
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
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
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
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
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
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
-
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
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
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
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
: 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
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
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
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
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
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
$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
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
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
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
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
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
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
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
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
:[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
?
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
: 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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=
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
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
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
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
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
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
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
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server
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
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
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
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
, 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
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
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
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
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
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
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
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
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
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
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
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
$ 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
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.
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
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
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
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
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
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
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
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
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
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
: 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
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
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
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
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
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
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.
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
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
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)
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 - 100 of 103 matches
Mail list logo