|
|
|
|
|
|
|
|
| Re: change SYSDBA password change_on_install password [message #151863 is a reply to message #151858] |
Mon, 19 December 2005 08:50   |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
Thanks niravshah i will try the command in my lab tomorrow.
what is difference between SYS and SYSTEM?
Let say,I forgot the password after i changed it,What should i do?For you information,I now learn on installation and setup the database.The database just contain default database since i had start install the Oracle today.Can i reinstall the software if i forgot the sys and system password?
for SYSTEM the default password is "manager" it is correct? but i don't know the host string name, Does it use SYSDBA for SYSTEM user host string?
|
|
|
|
| Re: change SYSDBA password change_on_install password [message #151865 is a reply to message #151863] |
Mon, 19 December 2005 08:54 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Sys and system are 2 different users -both will have different password..you are right about default passwd of system.
You should NOT forget these passwords! but if you do , then reset the passwd by same command:
alter user sys/system identified by <new passwd>
rest of questions, i leave as ur homework or labwork!
N.
|
|
|
|
| Re: change SYSDBA password change_on_install password [message #151946 is a reply to message #151865] |
Mon, 19 December 2005 23:52 |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
what should i need to put in the box that popup when i click on the SQLPLUS icon? Does i need to put this information on the box ?Username : SCOTT password : TIGER Host string:PSM2006
Or after i finish log on as scott
i need to put type this command sys/change_on_install as sysdba it is correct?then i can alter the password for sys using this command alter user sys/system identified by <new passwd>?
|
|
|
|
| Re: change SYSDBA password change_on_install password [message #153257 is a reply to message #151865] |
Fri, 30 December 2005 08:44 |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
hai
I want to change sys password.But when i double click on SQLPlus icon,The dialog box pop up.
What information i need to put in it?
Username : SYS
Password :Change_on_install
host string : <I DON'T KNOW>
Does host string refer my database instance for Oracle?
Or i need to log in as
Username : Scott
Password : Tiger
host string : PSM06
Help me.
|
|
|
|
|
|
| Re: change SYSDBA password change_on_install password [message #153490 is a reply to message #153260] |
Mon, 02 January 2006 22:06 |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
I need to log in as sys from the server side or client side?
I have try to log in from client side SQLPLUS icon and type with this
username : sys
password : GISDB
host string : PSM2006
and then i got this error message :-
ORA-28009: connection to sys should be as sysdba or sysoper
Here is my TNSNAMES.ORA
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
PSM2006 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server_psm)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PSM2006)
)
)
Why it happed?
[Updated on: Mon, 02 January 2006 22:17] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
