New Database Instance

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

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

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

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

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

Thanks, kindly, respectfully

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