-
We have an Oracle 8.0.5 application on Unix. We took over a contract from another company which left us with no account names & passwords for dba. How can I sign on in order to shutdown this database? There are two instances on the box. When I try to sign on under server manager I get only one version. I've used "connect internal@test as sysdba" but it won't work with any password I have. I've changed the SYS password to get the internal password changed. That only works when I sign on as "Connect SYS/password." Not with "internal". "Connect internal as sysdba" connects me to the wrong instance. I can't find a way to shutdown this other instance. There is no password file on the UNIX.
I have tried using SET ORACLE_SID=TEST, but it still goes to the other instance when I go into server manager.
Help please!!!
Thanks.
-
You can also use the same version(db version you are trying to connect) binaries for server manager executable and use connect string as follows.
connect internal@xyz
where xyz is service name of the database you are connecting to.
Reddy,Sam
-
Once after you set your environment, did you get to confirm that it had got set in the env.
If you are using c shell i.e "%" then you get to use setenv
If you are using the borne shell i.e. "$" then you use export.
eg:
Borne shell:
ORACLE_SID=xyz; export ORACLE_SID
C Shell:
setenv ORACLE_SID xyz
Then confirm that it had got set in the environment as
env
Then try connecting to theinstance as
svrmgrl
connect internal
now you can alter the sys password as
alter user sys identified by password;
alter user system identified by password;
:
.
etc
Hope this would help you,
Sam
Thanx
Sam
Life is a journey, not a destination!
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
|