-
Hi,
Oracle 8.1.7/Win 2000
I am facing a strange problem.I logged into my DB with Internal/Oracle from SVRMGRL.Then I performed certain activities like exp,imp,view creation,etc from other users.Now when again I want to connect as Internal its gving error that
ORA-01017: invalid username/password; logon denied. Can anyone help.I am unable to shutdown my Database.
Thanks.
-
Hello;
Try to connect with : sys/oracle as sysdba
this is a second form of connecting as internal
Orca
-
Hi,
This is also giving the same error.
Thanks.
-
any replies ??
any replies , I cannot shutdown my database as I cannot connect as Internal.
-
Create new password file using the ORAPW utility and use new password top do connect internal
An elephant is a mouse with an operating system.
-
Hi
Is the win2000 user a member of the ORA_DBA group? if not you will have to give the password specified in the password file.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Hi ,
I was able to connect as sys/***** as sysdba but not as Internal.Causes ?
-
If you can connect as SYS, you should not have a problem shutting down your database (all internal does is connect as sys.)
You do have to look at either rebuilding your password file or checking your host id group against the Oracle id group. This situation could happen if the id you are using is not or no longer a member of the SYSDBA group.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
Originally posted by jrpm
all internal does is connect as sys
CONNECT INTERNAL is same as CONNECT / AS SYSDBA
CONNECT SYS/password is not same as CONNECT / AS SYSDBA
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
I have LInux RH AS 2.1 and Oracle9i2
I can do >connect sys/... as sysdba
I can not do >connect / as sysdba
returns ERROR: ORA-01031: unsufficient privileges
Because of this problem I can not use dbstart dbstop scripts.
I do not want to modify them to print sys password inside.
I onle can start database manually from sys user.
I found on internet some information:
http://www.geocrawler.com/archives/3.../10/0/6954364/
I checked SYSDBA users on my installation:
select * from v$pwfile_users;
This is what expected:
USERNAME SYSDBA SYSOPER
------------------------- ------ -------
INTERNAL TRUE TRUE
SYS TRUE TRUE
This is what I have:
USERNAME SYSDBA SYSOPER
------------------------- ------ -------
SYS TRUE TRUE
Can somebody give me clue why I do not have INTERNAL user?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|