Re: sys ans system password

shark wrote:
> Hi all,
>
> i installed 10g but i don't remeber whether i hv given a password for
> sys & system .

Presuming the installation completely successfully you shouldn't NEED the password for SYS using a local connection.

> As a result of which i can tn connect 2 the D/b . i
> treid using the default password of this 2 acct but it does nt wrk :(

Again, you shouldn't need a password for SYS connecting locally from a command prompt:

c:\oracle\is\my\friend > sqlplus /nolog
[lots of header stuff here]

SQL> connect / as sysdba
Connected.
SQL> This, of course, presumes you have the OracleServiceXXXX running, where XXXX is replaced with your database name; simply visit Services and browse:

Start -> Control Panel -> Administrative Tools -> Services

You should see an OracleServiceXXXX entry (again, it will NOT show XXXX, it will show your database name). It should have the status Started. If not, start it. Then try the connection method provided above from a command prompt:

Start -> Run -> cmd

In the window thus created:

c:\oracle\is\my\friend > sqlplus /nolog
[lots of header stuff here]

SQL> connect / as sysdba
Connected.
SQL> Should you see the text 'Connected to an idle instance.' simply type 'startup' at the SQL> prompt:

SQL> startup
....

> .
> is there ne way in which i can i reset this passwrd using o/s
> authentication.

You shouldn't NEED to, however you DO need to clean up your presentation and stop using 'netspeak'.

> os windows 2000 server.
> oracle version 10g
>
>
> thanks.

David Fitzjarrell Received on Thu May 25 2006 - 15:21:38 CDT