hello...i just installed oracle 10g in my pc but i dint get username and password for sql*plus......plz help me

user: SCOTT
pass: TIGER

There is no generic answer to this.

A lot will depend on how you have installed and configured the DB.

During installation it is compulsory to set password for SYS and SYSTEM account. Again you can unlock and set password for other preexisting accounts (SCOTT is one of them) which is not compulsory during installation and can be done later by logging in from either of SYS or SYSTEM accounts.

So to log in into SYS or SYSTEM accounts, you need to login with the password that you have set (which you only know) during installation process.

first u open command promt
type SQLPLUSW SYS AS SYSDBA then press enter
after opening command promt window
type SQL>ALTER USER SCOTT IDENTIFIED BY TIGER ACCOUNT UNLOCKED;
SQL>ALTER USER SYSTEM IDENTIFIED BY MANAGER;
SQL>CONN SCOTT/TIGER
SQL>SHOW USER
then u can carry on with ur oracle.byeeeeeeeeeeee......

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.