Operating System - HP-UX
1748259 Members
3910 Online
108760 Solutions
New Discussion юеВ

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

 
SOLVED
Go to solution
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>