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

[jacky400]

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

[Indira Aramandla]

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

[jacky400]

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.

[Indira Aramandla]

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

[jacky400]

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>

[Yogeeraj_1]

hi,

can you try to connect using the following?

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

hth
yogeeraj

[Indira Aramandla · Accepted solution]

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

[jacky400]

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>

[Sanjay Kumar Suri]

do the following

connect internal/oracle as sysdba

then do use startup statements.

sks

[jacky400]

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>

[Sanjay Kumar Suri]

Make another attempt with

connect sys/oracle as sysdba

startup;

sks

[jacky400]

Now i can connect internal using password=oracle

but when i startup nomount
it always ORA-03113 end-of-line communication

The trace is as below,

Dump file /u01/app/oracle/admin/orcl/udump/ora_2108.trc
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
ORACLE_HOME = /u01/app/oracle/product/8.0.5
System name: HP-UX
Node name: osstest
Release: B.11.00
Version: U
Machine: 9000/869
Instance name: orcl
Redo thread mounted by this instance: 0
Oracle process number: 0
Unix process pid: 2108, image: oracleorcl

Exception signal: 10, code = 7f7e4040
sc_onstack: 00000000c0049a03, sc_mask 0000000000000480
pcsqh: 0x00000000 pcoqh: 0x000004b4 pcsqt: 0x00000000 pcoqt: 0x00007a5d
isr: 0x00000000 ior: 0x00000000
sc_flags: 0x4005324c sc_sp: 0x00000002 sc_ret1: 0x000004b4 sc_ret0: 0x0ec41093
sc_arg0: 0x00000000 sc_arg1: 0xc0049a07 sc_arg2: 0x00000000 sc_arg3: 0xc0049a03
sc_dp: 0xffffffff sc_rp: 0x00000002 sc_sar: 0x00000003 sc_ipsw: 0x000c3154 sc_psw: 0x000c3154
sc_gr1: 0x4005817a sc_gr2: 0x00000002 sc_gr3: 0x00000000 sc_gr4: 0x0000025b
sc_gr5: 0x00000444 sc_gr6: 0x0000017a sc_gr7: 0x0000014c sc_gr8: 0x00000000
sc_gr9: 0x7f7aa6f0 sc_gr10: 0x00000000 sc_gr11: 0x7f7e38c0 sc_gr12: 0x00000000
sc_gr13: 0x7f7b9be8 sc_gr14: 0x40068ac0 sc_gr15: 0x7f7a0182 sc_gr16: 0x7f7b9be8
sc_gr17: 0x40060188 sc_gr18: 0x00000000 sc_gr19: 0x000000b8 sc_gr20: 0x7f7e3b40
sc_gr21: 0xc011cbdb sc_gr22: 0x00000008 sc_gr27: 0xffffffff sc_gr28: 0x0ec41093
sc_gr29: 0x000004b4 sc_gr30: 0x00000002 sc_gr31: 0x0006fd1f sc_sr4: 0x000c0000
ORA-07445: exception encountered: core dump [10] [2138980416] [3221527043] [1152] [] []





===================================================
PROCESS STATE
-------------
Process global information:
process: 0, call: 0, xact: 0, curses: 0, usrses: 0
No process is allocated.
END OF PROCESS STATE
******************** Cursor Dump ************************
No curdef array
ssexhd: crashing the process...
Shadow_Core_Dump = full

[Sanjay Kumar Suri]

Can you also look into the trace file created in background_dump_dest for PMON/SMON etc?

What is the shared_pool_size defined in init.ora file?

sks

[jacky400]

There is no pmon and smon trace file under the directory of bdump

The following is my initorcl.ora

db_name=orcl_db
db_files=100
db_block_buffers=3200
shared_pool_size=20000000
sort_area_size=20000000
log_checkpoint_interval=10000
processes=10
compatible=8.0.5
remote_login_passwordfile=exclusive
job_queue_processes=10
job_queue_interval=60
max_dump_file_size=10240
user_dump_dest=/u02/admin/udump/
background_dump_dest=/u02/admin/bdump/
core_dump_dest=/u02/admin/cdump
control_files=("/u02/orcl/control01.ctl","/u02/orcl/control02.ctl")

log_archive_start=true
log_archive_dest=/u02/orcl/arch
log_archive_format=arch_%s

[Alexander M. Ermes]

Hi Jacky.
Did you check the attributes of your oracle executable ?

Make sure, that user oracle is the owner
and the attributes set to 6751 ( with the sticky bit ).
Rgds
Alexander M. Ermes