New Database Instance

[mcampb9713]

Hi,

I am on a windows NT with Oracle 7.3.3, and I have successfully created another instance. So, there is two instance and database on the same server. Wherenever I set oracle sid and mount to my new pfile in server manager, I am able to connect internal and system, view tables, V$, .. in other words everything works fine. But when I try to connect through sql 3.3 to create my new user etc, I get an error:
Ora-01017: invalid username/password; logon denied.

I find find that where since this is a new instance and database and I can connect internal or system to the new instance/database, but I cannot do it through SQL 3.3.3 on the desktop.

Please help

[omegamark]

Hi,

In Net 8 Easy config fill in the following details

Service name = name of database sid (ex. orcl)

Choose protocol as Tcp/ip

Port as 1521

and that's it

you'll be able to connect by username/passwd@servicename

-Anand


Say Thanks to Anand

[mcampb9713]

Hi,

Thanks for the response... I used Net 8 Config and have my alias created in the TNSnames.ora file. But, I still am getting the ORA-01017: invalid user/password; logon denied.

I do not know what else to try... Any suggestion(s) will be taken.

Thanks

[omegamark]

Check your username and password.connect string also..

Otherwise if the database is in local machine you have to use the protocal bequeth.Then there is a option at the end to test whether you have done the connect string correctly or not.

I do not think you have used that option.Test that by entering a valid username and password.if this comes out succesfull i do not see any trouble while loging...

pls inform whether you have used the test on net8 easy config

[mcampb9713]

Thank you so much.. I had to use bequeath.

Thanks, kindly, respectfully

[Prof]

I think that you must be setting ORACLE_SID variable in Windows registry. ( HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE ). And you must be use oradim utility ( if you can't made oracle<SID> service).