xiaoxing tech

July 24, 2007

Memo For Configuring New PCS Oracle DB

Filed under: Oracle — xiaoxing @ 1:42 pm

Access
to EUEOLTD1 Development Database and change password (
by using SQL*Plus,
the tool comes with Oracle database, this program is at
C:\oracle\ora81\bin\SQLPLUSW.EXE):

 

step
1: Open tnsnames.ora with Notepad

        (this file is at: C:\oracle\ora81\network\ADMIN\tnsnames.ora)

        Add the following five lines of code
to the end of that file:

        eueoltd1  =

  (DESCRIPTION =

    (ADDRESS =
(PROTOCOL = TCP)(Host = 3.59.41.217)(Port = 1598))

    (CONNECT_DATA =
(SID = eueoltd1))

  )

step
2: Try log into DB through SQL*Plus by using your

        username, password and Host String:
eueoltd1

        If it works, done.

        If it doesn’t work, open the same
folder that containing tnsnames.ora.

        Delete (or move) the file: sqlnet.ora.

        Then try again.

step
3: change password: Open SQL*Plus, fill in user name, password, and eueoltd1 as
Host String

 

Type
password in the command line:

input
the old password then input a new password twice,

it’s
done!

 

The
JDBC DB url is: jdbc:oracle:thin:@3.59.41.217:1598:eueoltd1

 

 

 

Powered by ScribeFire.

No Comments Yet »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.