add username and password after installation

[love247]

hello everyone...

i installed oracle 10g developer, and created a new home for the database, and completed the installation...

but now i can't use SQL plus, or forms builder, because there is no username and password specified..

i tried (scott/tiger) and (system/manager) but they did not work...

how can i add a username and password after the installation?

thanks for any help

 

[taupirho]

When connecting as system did you use "connect system/manager as sysdba"

If not please try this. If you did and had no luck try logging on as user sys with its default password change_on_install (again using as sysdba)



In order to understand recursion, you must first understand recursion.

 

[love247]

what do you mean [as sysdba] ??

 

[taupirho]

As of Oracle 9 I think, when connecting to the database with a DBA type account using sqlplus you need to use the following syntax

sqlplus user/password as sysdba

So in your case try this:-

sqlplus system/manager as sysdba


In order to understand recursion, you must first understand recursion.

 

[taupirho]

No, try this:-

sqlplus /nolog
connect system/manager as sysdba


In order to understand recursion, you must first understand recursion.

 

[love247]

its 10g, not 9

 

[love247]

well, when i saw the version, its 9, not 10.... im sorry...

now, where must i write this
[sqlplus /nolog
connect system/manager as sysdba ]
???

 

[taupirho]

Well, you said " ... but now I can't use SQL Plus ... "

So I guessed from that comment that you kind of had an idea how to use sqlplus in the first place.

Just from your O/S command prompt type

sqlplus /nolog

Then type

connect system/manager as sysdba



In order to understand recursion, you must first understand recursion.

 

[sem]

I suppose that the problem is with the location of your sqlnet.ora and tnsnames.ora files (aka TNS_ADMIN environment variable): you have added a new ORACLE_HOME and now these (empty!) files are read from the new directory. You may either set the variable to point to your old directory or copy that files to a new location.

BTW are you trying to connect to your local database? Doy you want to connect from Forms etc. to you local database? It's not clear from your question.

Regards, Dima

http://seminihin.narod.ru