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

If you have access to Metalink there is a good article there (Doc. 69642 or just put your subject in search), which lists all different causes why this might happen audit dir being full is one of them, ORACLE_HOME and/or SID set inapropriatelly, and a number of others.

Djordje

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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" wrote:
>
> > List,
> >
> > I have an installation of Oracle 8.1.6 on a DBA test server where
svrmgrl
> > "connect internal" seems to want a password...
> >
> > Sun Microsystems Inc. SunOS 5.8 Generic February 2000
> >
> > Configured oracle environment aliases...
> >
> > Alias SID Oracle Home
> > ----- --- -----------
> > dba816 dba816 /Volumes/app/oracle/product/8.1.6
> > dba817 dba817 /Volumes/app/oracle/product/8.1.7
> >
> > $ id
> > uid=301(oracle) gid=300(dba)
> > $ groups
> > dba
> > $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > $ dba816
> > dba816 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba816
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.6
> > dba816 $ cdcreate
> > /Volumes/app/oracle/admin/dba816/create
> > dba816 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.6.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.6.2.0 - Production
> >
> > SVRMGR> connect internal;
> > Password:
> > Password:
> > ORA-01031: insufficient privileges
> > SVRMGR> ^D
> > Server Manager complete.
> > dba816 $ dba817
> > dba817 $ env | grep ORACLE
> > ORACLE_BASE=/Volumes/app/oracle
> > ORACLE_SID=dba817
> > ORACLE_HOME=/Volumes/app/oracle/product/8.1.7
> > dba817 $ cdcreate
> > /Volumes/app/oracle/admin/dba817/create
> > dba817 $ svrmgrl
> >
> > Oracle Server Manager Release 3.1.7.0.0 - Production
> >
> > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
> >
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> >
> > SVRMGR> connect internal;
> > Connected.
> > SVRMGR> ^D
> > Server Manager complete.
> >
> > I know that the usual reason for this is that the account running
svrmgrl is
> > not a member of the appropriate unix group (usually "dba" or as
specified at
> > installation time) but this is not the case here. On this server I have
> > Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7
> > (Home = /Volumes/app/oracle/product/8.1.7). My login script sets up
aliases
> > for each SID listed in /var/opt/oracle/oratab. These aliases use the
oraenv
> > script with environment variable ORAENV_ASK=NO to set appropriate values
for
> > ORACLE_SID, ORACLE_HOME and PATH etc. Other than that, the environment
is
> > exactly the same regardless of what SID I switch to (see log above).
> > However "connect internal" asks for a password for Oracle 8.1.6 but does
not
> > ask for one for Oracle 8.1.7. I am pretty sure that I specified that
the
> > group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue.
> >
> > Can anybody give me some pointers of other things to look at to try and
> > resolve the problem???
> >
> > Thanks,
> > Ken
> > _________________________________________
> > Clinical and Regulatory Informatics - Groton/New London
> > Coordinator, Business and Technical Services
> > Tel: (860) 732-0026 Fax: (860) 715-8346
> > Email: Kenneth_R_Fowler_at_groton.pfizer.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Fowler, Kenneth R
> > INET: kenneth_r_fowler_at_groton.pfizer.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (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.com
> --
> Author: Terry Ball
> INET: terry_ball_at_csgsystems.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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.com
-- 
Author: djordjej
  INET: djordjej_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).