Ask the Expert

Running two databases on Win2000 simultaneously

Is it possible to run two databases on Windows 2000 simultaneously? How do I register the two database with listeners to start at the same time? I keep getting this error:
ORA-12514:

    Requires Free Membership to View

TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Yes, it is possible to run more than one instance on a Windows server and to have one listener configured for all the instances on that server. To set up your listener, you'll need to modify your LISTENER.ORA file to contain information similar to the following:
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= sid1)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= sid2)
        )
  )
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
    (SID_NAME = sid1)
    (ORACLE_HOME = d:oracleora9i)
  )
  (SID_DESC =
    (SID_NAME = sid2)
    (ORACLE_HOME = d:oracleora9i)
  )
)

But all of this may be unnecessary if you set USE_PLUG_AND_PLAY_LISTENER = ON so that each instance dynamically registers itself with the listener.

This was first published in October 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: