HP 11.0 Oracle 8.0.5 fresh install connect internal need password

[jacky400]

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)

[Eric Antunes]

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

connect '/ as sysdba'

?

[malay boy]

jacky,
Please comment below :

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

in sqlnet.ora file.

Please try and tell us the result.

regards
mB

[Ravi_8]

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.

[jacky400]

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

[Martin Johnson]

svrmgrl> connect internal

should do it.

HTH
Marty

[Brian Crabtree]

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

Thanks,

Brian

[Indira Aramandla]

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

[jacky400]

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

[Steven E. Protter]

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