| Computers Forum Index » Computer - Databases - Oracle (Server) » Oracle password problem... |
|
Page 1 of 1 |
|
| Author |
Message |
| neilsolent... |
 Posted: Thu Oct 29, 2009 4:21 pm |
|
|
|
Guest
|
Hi
We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
I have tried this procedure to recover:
1. Stop the Oracle service of the instance you want to change the
passwords of.
2. Find the PWD###.ora file for this instance, this is usuallly
located atC:\oracle\ora81\database\, where ### is the SID of your
database.
3. rename the PWD###.ora file to PWD###.ora.bak for obvious safety
reasons.
4. Create a new pwd file by issuing the command:
orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX
where ### is the SID and XXXXX is the password you would like to use
for the SYS and INTERNAL accounts.
5. Start the Oracle service for the instance you just fixed. You
should be able to get in with the SYS user and change other passwords
from there.
But it still says username/password wrong afterwards...
What could I be missing? Could something be corrupted somewhere else?
Many thanks!
Neil |
|
|
| Back to top |
|
|
|
| ddf... |
| Posted: Thu Oct 29, 2009 4:31 pm |
|
|
|
Guest
|
On Oct 29, 10:21 am, neilsolent <n... at (no spam) solenttechnology.co.uk> wrote:
Quote: Hi
We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
I have tried this procedure to recover:
1. Stop the Oracle service of the instance you want to change the
passwords of.
2. Find the PWD###.ora file for this instance, this is usuallly
located atC:\oracle\ora81\database\, where ### is the SID of your
database.
3. rename the PWD###.ora file to PWD###.ora.bak for obvious safety
reasons.
4. Create a new pwd file by issuing the command:
orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX
where ### is the SID and XXXXX is the password you would like to use
for the SYS and INTERNAL accounts.
5. Start the Oracle service for the instance you just fixed. You
should be able to get in with the SYS user and change other passwords
from there.
But it still says username/password wrong afterwards...
What could I be missing? Could something be corrupted somewhere else?
Many thanks!
Neil
It's more likely that you're using a domain account rather than a
local server account; such configurations result in the error message
you see. Try using a local account to access the database.
David Fitzjarrell |
|
|
| Back to top |
|
|
|
| Mark D Powell... |
| Posted: Thu Oct 29, 2009 10:22 pm |
|
|
|
Guest
|
On Oct 29, 12:21 pm, neilsolent <n... at (no spam) solenttechnology.co.uk> wrote:
Quote: Hi
We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
I have tried this procedure to recover:
1. Stop the Oracle service of the instance you want to change the
passwords of.
2. Find the PWD###.ora file for this instance, this is usuallly
located atC:\oracle\ora81\database\, where ### is the SID of your
database.
3. rename the PWD###.ora file to PWD###.ora.bak for obvious safety
reasons.
4. Create a new pwd file by issuing the command:
orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX
where ### is the SID and XXXXX is the password you would like to use
for the SYS and INTERNAL accounts.
5. Start the Oracle service for the instance you just fixed. You
should be able to get in with the SYS user and change other passwords
from there.
But it still says username/password wrong afterwards...
What could I be missing? Could something be corrupted somewhere else?
Many thanks!
Neil
To add to what David and Fabrice said, if you are a local
administrator you should be able to connect via sqlplus /nolog then
issue connect / as sysdba without ever using a password. One
connected as sysdba you are user SYS and can use alter user x
identified by password to change the password for user SYS, SYSTEM,
etc..... as desired.
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
|
| Fabrice... |
| Posted: Thu Oct 29, 2009 11:04 pm |
|
|
|
Guest
|
neilsolent wrote:
Quote: Hi
We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
I have tried this procedure to recover:
1. Stop the Oracle service of the instance you want to change the
passwords of.
2. Find the PWD###.ora file for this instance, this is usuallly
located atC:\oracle\ora81\database\, where ### is the SID of your
database.
3. rename the PWD###.ora file to PWD###.ora.bak for obvious safety
reasons.
4. Create a new pwd file by issuing the command:
orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX
where ### is the SID and XXXXX is the password you would like to use
for the SYS and INTERNAL accounts.
5. Start the Oracle service for the instance you just fixed. You
should be able to get in with the SYS user and change other passwords
from there.
But it still says username/password wrong afterwards...
What could I be missing? Could something be corrupted somewhere else?
Many thanks!
Neil
Hello
You need to update the nt service with ORADIM.
or
Just insert the administrator account in the local "ORACLE groupe" and fix
the SQLNET.ORA file like this :
SQLNET.AUTHENTICATION_SERVICES=(NTS)
The connection
conn / at (no spam) YourSID as sysdba
fabrice |
|
|
| Back to top |
|
|
|
| Ciccio... |
| Posted: Fri Oct 30, 2009 2:49 am |
|
|
|
Guest
|
Mark D Powell wrote:
Quote: We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
Have you tried to look at orahome\database\start<SID>.bat file? You
should find the sys password here |
|
|
| Back to top |
|
|
|
| Palooka... |
| Posted: Fri Oct 30, 2009 4:38 am |
|
|
|
Guest
|
On 29/10/09 16:21, neilsolent wrote:
Quote: Hi
We have Oracle 8.1.7 on Windows 2000 - and the admin user account
passwords have been lost (sys, system etc). I urgently need to login
to increase tablespaces!
I have tried this procedure to recover:
1. Stop the Oracle service of the instance you want to change the
passwords of.
2. Find the PWD###.ora file for this instance, this is usuallly
located atC:\oracle\ora81\database\, where ### is the SID of your
database.
3. rename the PWD###.ora file to PWD###.ora.bak for obvious safety
reasons.
4. Create a new pwd file by issuing the command:
orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX
where ### is the SID and XXXXX is the password you would like to use
for the SYS and INTERNAL accounts.
5. Start the Oracle service for the instance you just fixed. You
should be able to get in with the SYS user and change other passwords
from there.
But it still says username/password wrong afterwards...
What could I be missing? Could something be corrupted somewhere else?
Many thanks!
Neil
The real answer is easy. If you have a toy OS, run a toy database, not a
serious one.
Palooka |
|
|
| Back to top |
|
|
|
| neilsolent... |
| Posted: Fri Oct 30, 2009 9:50 am |
|
|
|
Guest
|
MANY, MANY THANKS ALL !
Fabrice's post worked for me. However, I had to create a separate
initXXX.ora file and issue startup, as the db wouldn't start
automatically (not sure why).
Also - I could not change the sys or system password (it's almost as
if those accounts have been deleted! Could they have been?)
However, I managed to alter the tablespace allocations and fix the
problem. |
|
|
| Back to top |
|
|
|
| gazzag... |
| Posted: Fri Oct 30, 2009 10:42 am |
|
|
|
Guest
|
On 30 Oct, 09:50, neilsolent <n... at (no spam) solenttechnology.co.uk> wrote:
Quote: MANY, MANY THANKS ALL !
Fabrice's post worked for me. However, I had to create a separate
initXXX.ora file and issue startup, as the db wouldn't start
automatically (not sure why).
Also - I could not change the sys or system password (it's almost as
if those accounts have been deleted! Could they have been?)
What did you try and what happened?
Quote: However, I managed to alter the tablespace allocations and fix the
problem.
-g |
|
|
| Back to top |
|
|
|
| neilsolent... |
| Posted: Fri Oct 30, 2009 10:58 am |
|
|
|
Guest
|
Hi Gazzag
Quote: Also - I could not change the sys or system password (it's almost as
if those accounts have been deleted! Could they have been?)
What did you try and what happened?
alter user 'system' identified by 'password1';
I can't remember the error - sorry should have clocked it (been in a
bit of a panic with this).
Is there a simple command a normal user can run to just check these
user accounts are there perhaps?
thanks,
Neil |
|
|
| Back to top |
|
|
|
| gazzag... |
| Posted: Fri Oct 30, 2009 12:39 pm |
|
|
|
Guest
|
On 30 Oct, 10:58, neilsolent <n... at (no spam) solenttechnology.co.uk> wrote:
Quote: Hi Gazzag
Also - I could not change the sys or system password (it's almost as
if those accounts have been deleted! Could they have been?)
What did you try and what happened?
alter user 'system' identified by 'password1';
I can't remember the error - sorry should have clocked it (been in a
bit of a panic with this).
Is there a simple command a normal user can run to just check these
user accounts are there perhaps?
thanks,
Neil
SELECT USERNAME, ACCOUNT_STATUS
FROM DBA_USERS
WHERE USERNAME LIKE 'SYS%';
Additionally, you don't want the quotes in your ALTER USER command.
ie.
ALTER USER SYSTEM IDENTIFIED BY <new_password>;
HTH
-g |
|
|
| Back to top |
|
|
|
| neilsolent... |
| Posted: Fri Oct 30, 2009 1:14 pm |
|
|
|
Guest
|
Quote: Neil
SELECT USERNAME, ACCOUNT_STATUS
FROM DBA_USERS
WHERE USERNAME LIKE 'SYS%';
Additionally, you don't want the quotes in your ALTER USER command.
ie.
ALTER USER SYSTEM IDENTIFIED BY <new_password>;
HTH
Thanks - worked. Users were there, problem was those single quotes
(and my panic)
:) |
|
|
| Back to top |
|
|
|
| Fabrice... |
| Posted: Fri Oct 30, 2009 11:22 pm |
|
|
|
Guest
|
Good evening
I don't understand why you have to create a new pfile ...
Have you re create the service ? if yes, you have to indicate the path to
the pfile in the oradim command.
If no, can you run the the command
"startup pfile='path..'
does it work ?
Anyway you can use a system script to start or stop your database whithout
password if you use NTS authentication. I do it on a replica.
fabrice
neilsolent wrote:
Quote: MANY, MANY THANKS ALL !
Fabrice's post worked for me. However, I had to create a separate
initXXX.ora file and issue startup, as the db wouldn't start
automatically (not sure why).
Also - I could not change the sys or system password (it's almost as
if those accounts have been deleted! Could they have been?)
However, I managed to alter the tablespace allocations and fix the
problem. |
|
|
| Back to top |
|
|
|
| neilsolent... |
| Posted: Sun Nov 01, 2009 4:56 pm |
|
|
|
Guest
|
Quote: I don't understand why you have to create a new pfile ...
Have you re create the service ? if yes, you have to indicate the path to
the pfile in the oradim command.
No, I didn't re-create the service. When I changed the authentication
mode, it seemed to expect the profile at a different location, that
didn't exist. Not sure why.
Quote: If no, can you run the the command
"startup pfile='path..'
does it work ?
Yes that works.
Quote: Anyway you can use a system script to start or stop your database whithout
password if you use NTS authentication. I do it on a replica.
OK |
|
|
| Back to top |
|
|
|
|
