sqlplus login 2004-02-03 - By Miran Krajnc
You should connect to the server as the owner of Oracle SW/DB or add
user root to the dba group and then perform newgrp dba - but this option
could be dangerous.
Miran
-- --Original Message-- --
From: Alan Civita [mailto:a.civita@(protected)]
Sent: Tuesday, February 03, 2004 12:05 PM
To: suse-oracle@(protected)
Subject: Re: [suse-oracle] sqlplus login
what do you mean?
i'm connected on the server as root and i use the bash
sorry but i'm not really competent on oracle :)
-- -- Original Message -- --
From: "Miran Krajnc" <miran.krajnc@(protected)>
To: "Alan Civita" <a.civita@(protected)>; <suse-oracle@(protected)>
Cc: "Harald Maier" <harald@(protected)>
Sent: Tuesday, February 03, 2004 12:05 PM
Subject: RE: [suse-oracle] sqlplus login
Do you use the same login/shell group as you specified at Oracle link
time?
Regards Miran
-- --Original Message-- --
From: Alan Civita [mailto:a.civita@(protected)]
Sent: Tuesday, February 03, 2004 11:46 AM
To: suse-oracle@(protected)
Cc: Harald Maier
Subject: Re: [suse-oracle] sqlplus login
this is excatly what i've done but : the instance is called orcl. this
was
running on the server. from client it works fine
linuxone:/opt/oracle/product/9ir2/dbs # orapwd
file=$ORACLE_HOME/dbs/orapworcl password=manager
linuxone:/opt/oracle/product/9ir2/dbs # sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Feb 3 11:42:12 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/manager as sysdba
ERROR:
ORA-01031 (See ORA-01031.ora-code.com): insufficient privileges
SQL>
-- -- Original Message -- --
From: "Harald Maier" <harald@(protected)>
To: "Alan Civita" <a.civita@(protected)>
Cc: <suse-oracle@(protected)>
Sent: Tuesday, February 03, 2004 11:37 AM
Subject: Re: [suse-oracle] sqlplus login
> "Alan Civita" <a.civita@(protected)> writes:
>
> > hi i'm not able to connect as sys as sysdba from the server, instead
i
can
> > do that from a client..
> > how can i solve it?
>
> You should look for the orapwd program. With this program you can
> define a pwd file with that you will be able to connect as sysdba.
> The pwd file normally resides at $ORACLE_HOME/dbs. The name is
> usually called orapw with the DB name as suffix.
>
>
> Additional you should set the following init parameter:
>
> ,----[ init.ora ]
> | remote_login_passwordfile=exclusive
> `----
>
> ,----[ Command ]
> | $ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password«cdef
> `----
>
> More info you will find in the 'Database Administrator's Guide'.
>
> Harald
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
