topic Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password in Operating System - HP-UX

HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 02:29:54 GMT

OS:HP 11.0 32-bit
Database :Oracle 8.0.5

After installation,i launch the svrmgrl and connect internal ,then ask password ,i tried every password also login failed.

I have login as oracle user which is under dba group
uid=103(oracle) gid=102(dba)

tnsnames.ora is setup ok
listener.ora is also ok and lsnrctl started
sqlnet.ora is set sqlnet.authentication_services=(nts)

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Eric Antunes — Wed, 16 Jun 2004 03:21:48 GMT

If you are using dblinks see Meatlink Note 1043217.6 to solve your issue. Have you tried:

connect '/ as sysdba'

?

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

malay boy — Wed, 16 Jun 2004 04:47:25 GMT

jacky,
Please comment below :

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

in sqlnet.ora file.

Please try and tell us the result.

regards
mB

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Ravi_8 — Wed, 16 Jun 2004 04:59:51 GMT

Hi,

what the SID says in user(oracle) environment
$env|grep -i sid

does this shows oracle sid?, else export it and try to connect.

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 11:33:27 GMT

To:Malay boy

If sqlnet.authentication_services=(nts) is commented out,when launch srvgrml

oracle@test%svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

ORA-03113: end-of-file on communication channel
SVRMGR>

To: Ravi

After i run env|grep -i sid
it show ORACLE_SID=orcl

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Martin Johnson — Wed, 16 Jun 2004 15:14:31 GMT

svrmgrl> connect internal

should do it.

HTH
Marty

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Brian Crabtree — Wed, 16 Jun 2004 20:47:16 GMT

Check the $ORACLE_HOME/rdbms/lib/config.c file and verify that the "dba" group in there.

Thanks,

Brian

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Indira Aramandla — Wed, 16 Jun 2004 21:16:56 GMT

Hi Jacky,

If it is prompting for a password, may be you have a password file setup. You may want to recreate the file specifying the password you desire.

Usage: orapwd file= password= entries=

where
file - name of password file
password - password for SYS
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.

"SQLNET.AUTHENTICATION_SERVICES" (in SQLNET.ORA)
This will authenticate the user at the OS level hence you may not need a password file. If there is no authentication then Oracle uses the password file orapwd.exe:

Attached is document form Metalink describing a check-list for connect internal issues.

I hope this helps.

Indira A

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 21:50:37 GMT

Brian

I check the $ORACLE_HOME/rdbms/lib/config.c
before
#define SS_OPER_GRP "dba"
#define SS_OPER_GRP "dba"

i even relink all the executable file,but also failed.

Indria

i also created a passwd file before
orapwd file=$ORACLE_HOME/dbs/orapwd_orcl
password=test entires=10

but when i svmgrl and connect internal/test
then it said login failed

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Steven E. Protter — Wed, 16 Jun 2004 22:15:08 GMT

I would think if tnsnames and listenr.ora are okay that this is cleary an environmental issue.

Seems like the ORA variables are not correclty set.

Do a env > env.txt
on this server
and a good server(or someone will help you out with that) and get the non working environment on the same page as the one that works.

SEP

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 22:19:59 GMT

here is my oracle env

umask 022
setenv ORACLE_SID orcl
setenv ORACLE_BASE /u01/app/oracle
setenv ORACLE_HOME /u01/app/oracle/product/8.0.5
setenv ORACLE_TERM xterm
setenv SHLIB_PATH /u01/app/oracle/product/8.0.5/lib
setenv ORA_NLS33 /u01/app/oracle/product/8.0.5/ocommon/nls/admin/data
setenv TMPDIR /tmp
setenv ORACLE_OWNER oracle
setenv PATH $ORACLE_HOME/bin:$PATH

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Indira Aramandla — Wed, 16 Jun 2004 22:49:02 GMT

Jacky,

When you do 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.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SVRMGR>connect internal

What error message are you getting.

Indira

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 23:03:47 GMT

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning option
JServer Release 8.0.5.0.0 - Production

SVRMGR>connect internal
password:

When i type the password as oracle,then login faile.
Note:i haven't use any orapwd to create password for internal account.

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Indira Aramandla — Wed, 16 Jun 2004 23:07:52 GMT

Jacky,

Do not use the password. Just do svrmgrl as oracle user from the UNIX prompt and then connect internal
Like this
$svrmgrl
SVRMGR>connect internal

What error message are you getting. Something like ORA.....ORA 9352. Please provide the error message.

Indira

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Wed, 16 Jun 2004 23:15:59 GMT

oracle@osstest%id
uid=103(oracle) gid=102(dba)
oracle@osstest%svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal;
Password:
ORA-01017: invalid username/password; logon denied
SVRMGR>

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Yogeeraj_1 — Wed, 16 Jun 2004 23:27:50 GMT

hi,

can you try to connect using the following?

sqlplus sys/@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))(CONNECT_DATA=(SID=)))

hth
yogeeraj

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Indira Aramandla — Wed, 16 Jun 2004 23:40:32 GMT

Jacky,
In you earlier update you specified that you has created the password file as $ORACLE_HOME/dbs/orapwd_orcl.

It should be $ORACLE_HOME/dbs/orapworcl.

Passwords for SYS and INTERNAL are held externally in the pwd.ora file.

If it is prompting for the password then may be this password file has been corrupted: You can drop it and recreating it by using ORAPWD.

Make sure you are using the "orapwd" utility correctly. The proper
syntax is:

orapwd file= password= entries=

where:

fname - name of password file (mandatory). Note that the name of the password file must be of the format $ORACLE_HOME/dbs/orapw{$ORACLE_SID because the name and location of the password file is hard coded in the file "sparams.h" (the line is:
# define SS_SIDPWFILE_DEFAULT "?/dbs/orapw@"). Thus, the file must be
put in the "dbs" directory and named "orapw".

password - password for SYS and INTERNAL (manditory)

entries - maximum number of distinct DBA and OPERs (optional)

I Hope this helps.

Indira

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Thu, 17 Jun 2004 01:20:51 GMT

Indria,

I created a passwd file named orapworcl as u tell me ,now can connect internal,but insufficient privileges.

oracle@osstest%svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal/oracle
Connected.
SVRMGR> startup nomount
ORA-01031: insufficient privileges
SVRMGR>

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

Sanjay Kumar Suri — Thu, 17 Jun 2004 01:27:50 GMT

do the following

connect internal/oracle as sysdba

then do use startup statements.

sks

Re: HP 11.0 Oracle 8.0.5 fresh install connect internal need password

jacky400 — Thu, 17 Jun 2004 01:38:38 GMT

oracle@osstest%svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal/oracle as sysdba
Connected.
SVRMGR> startup
ORA-01031: insufficient privileges
SVRMGR>