How to
connect internal?
Question:
When using SVRMGR to connct
the database I cannot connect.
I'm using the command 'CONNECT
INTERNAL' and I get a response back stating I need to enter a password.
My knowledge lead me to believe that INTERNAL implicitly attains the user/password
from your operating system. Does your OS user/pass
have to be the same as ORACLE user/pass.
Ans1:
The internal account always
require a password.( ExceptPersonal Oracle) In Multiple database
environments the oracle_sid is set and connected to the particular
dataabse internal.
the default password is oracle
.
Ans2:
You should be logged in as
'oracle' user (unix user, who is owner of oracle files)
Ans3:
Create a password file using
the password application called orapwd...
(depending on your system)
you will find it in /bin.
orapwd80 file=c:\orawin95\database\pwdorcl.ora
password=oracle
change "remote_login_passwordfile
= exclusive"
You should be able to connect
internal without a password.
Ans4:
Check the environment variable
TWO_TASK to see if it has a
value. If this
is set, you need to 'unset TWO_TASK'. Once
this has been done, you won't
get a prompt for a password
when connecting as internal.
Common annoyance you can run
into.
Ans5:
I have been told by instructors
at Oracle that CONNECT INTERNAL is being phased out. Instead, it will be
CONNECT sys/password as sysdba
That will be the same deal.
If you can connect as system/manager, go in and change the password for
sys as one you want, and start using the connect string I stated earlier
as that is what Oracle recommends. You can always change passwords using
the following command,
ALTER USER username IDENTIFIED
BY password;
(the user must already exist)