Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

HP 11.0 Oracle 8.0.5 fresh install connect internal need password

SOLVED
Go to solution
jacky400
Advisor

HP 11.0 Oracle 8.0.5 fresh install connect internal need password

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)



40 REPLIES
Eric Antunes
Honored Contributor

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

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

connect '/ as sysdba'

?
Each and every day is a good day to learn.
malay boy
Trusted Contributor

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

jacky,
Please comment below :

#SQLNET.AUTHENTICATION_SERVICES = (NTS)

in sqlnet.ora file.

Please try and tell us the result.

regards
mB
There are three person in my team-Me ,myself and I.
Ravi_8
Honored Contributor

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

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.
never give up
jacky400
Advisor

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

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
Honored Contributor

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

svrmgrl> connect internal

should do it.

HTH
Marty
Brian Crabtree
Honored Contributor

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

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

Thanks,

Brian
Indira Aramandla
Honored Contributor

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

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
Never give up, Keep Trying
jacky400
Advisor

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

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
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
jacky400
Advisor

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

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
Honored Contributor

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

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
Never give up, Keep Trying
jacky400
Advisor

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

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
Honored Contributor

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

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

Never give up, Keep Trying
jacky400
Advisor

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


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
Honored Contributor

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

hi,

can you try to connect using the following?

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

hth
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor
Solution

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

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

Never give up, Keep Trying
jacky400
Advisor

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

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
Honored Contributor

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

do the following

connect internal/oracle as sysdba

then do use startup statements.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

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

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
Honored Contributor

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

Make another attempt with

connect sys/oracle as sysdba

startup;

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

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

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
Honored Contributor

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

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
jacky400
Advisor

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

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
Honored Contributor

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

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

.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"