connecting to second database [message #72496] |
Mon, 30 June 2003 04:27 |
BIRENDER KUMAR
Messages: 18 Registered: May 2003
|
Junior Member |
|
|
Hi Expert,
Thanx 4 ur time,
I have few queries
(1) I have prod. database(8i enterprise edition) running on win nt server.
Its running fine.
Now I have created another database(test) thru Database Configuration assistance.
It has been created successfully.
But now I want to connect to this new database,
when I am trying to connect -connect scott/tiger@test
its giving error
-ERROR: ORA-12154: TNS:could not resolve service name
Kindly tell me what should I do ,in order to connect to new db.
(2) I want to change the password of internal
How can I do so
Pls reply in detail if possible.
Thanx.
|
|
|
Re: connecting to second database [message #72498 is a reply to message #72496] |
Mon, 30 June 2003 07:37 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
create a tnsentry 'test' in your tnsnames.ora.
so if you want to connect to prod database
use
-- by default it will go the primary sid ie..prod in
--this case ... if you want u create another entry for
-- prod so that you can connect like connect scott/tiger@prod
connect scot/tiger
-- to connect to test
connect scott/tiger@test
to change the password or set a password for internal use passwordfile
|
|
|