OraFAQ Forum: Networking and Gateways » change SYSDBA password change_on

Home » RDBMS Server » Networking and Gateways » change SYSDBA password change_on_install password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change SYSDBA password change_on_install password [message #151783]

Mon, 19 December 2005 04:00

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

Report message to a moderator

Re: change SYSDBA password change_on_install password [message #151825 is a reply to message #151783]

Mon, 19 December 2005 06:34

orausern
Messages: 826
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>;

Report message to a moderator

Re: change SYSDBA password change_on_install password [message #151857 is a reply to message #151825]

Mon, 19 December 2005 08:26

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 ?

Report message to a moderator

Re: change SYSDBA password change_on_install password [message #151858 is a reply to message #151857]

Mon, 19 December 2005 08:32

orausern
Messages: 826
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.

Report message to a moderator

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?

Report message to a moderator

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.

Report message to a moderator

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>?

Report message to a moderator

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.

Report message to a moderator

Re: change SYSDBA password change_on_install password [message #153260 is a reply to message #153257]

Fri, 30 December 2005 08:57

orausern
Messages: 826
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.

Report message to a moderator

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

Re: change SYSDBA password change_on_install password [message #219984 is a reply to message #151857]

Sat, 17 February 2007 05:20

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......

Report message to a moderator

Previous Topic:	10g won't connect to 9i
Next Topic:	net8 easy configuration does not work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:40:06 CST 2024