Home » RDBMS Server » Networking and Gateways » change SYSDBA password change_on_install password
change SYSDBA password change_on_install password [message #151783] Mon, 19 December 2005 04:00 Go to next message
matrik02
Messages: 64
Registered: November 2005
Member
I have install the Oracle 10i on server machine..I have set up the user account.How to change the password change_on_install for SYSDBA.

I hope to get your respond... Thanks
Re: change SYSDBA password change_on_install password [message #151825 is a reply to message #151783] Mon, 19 December 2005 06:34 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
You have to change the password for the user SYS. (and also for system etc)

Login as user sys and give the command :

alter user sys identified by <new password>;

Re: change SYSDBA password change_on_install password [message #151857 is a reply to message #151825] Mon, 19 December 2005 08:26 Go to previous messageGo to next message
matrik02
Messages: 64
Registered: November 2005
Member
i need to login the user as SYS but i did not know the password?Does i need to use default password "change_on_install" .Then i type the command that you give to me.it is correct?In the username box,what should i have to put in it?SYS or SYSDBA ?
Re: change SYSDBA password change_on_install password [message #151858 is a reply to message #151857] Mon, 19 December 2005 08:32 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
yes the password you have to supply is that -change_on_install
when you login as sys.

In the username put sys

entire string will be like: sys/change_on_install as sysdba


N.
Re: change SYSDBA password change_on_install password [message #151863 is a reply to message #151858] Mon, 19 December 2005 08:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
orausern
Messages: 817
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #153260 is a reply to message #153257] Fri, 30 December 2005 08:57 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
search for a file named : tnsnames.ora in ur computer. it will have entry like

<service_name> = --some details here.



this service_name you have to use ..so use this name in the connection string.

Re: change SYSDBA password change_on_install password [message #153490 is a reply to message #153260] Mon, 02 January 2006 22:06 Go to previous messageGo to next message
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

Re: change SYSDBA password change_on_install password [message #219984 is a reply to message #151857] Sat, 17 February 2007 05:20 Go to previous message
pradnya
Messages: 1
Registered: January 2007
Location: mumbai
Junior Member
you have to select user name as sys only just follow bellow link


http://www.pentest.co.uk/sql/check_users.sql


and search it......
Previous Topic: 10g won't connect to 9i
Next Topic: net8 easy configuration does not work
Goto Forum:
  


Current Time: Mon Dec 05 12:47:07 CST 2016

Total time taken to generate the page: 0.27187 seconds