CLIENT SIDE settings in Oracle DBA

CLIENT SIDE

Dba12~]$ cd $ ORACLE_HOME / network /admin

Dba12 admin}$ cp tnsnames.ora $ HOME

Dba12 admin ] $ cd

Dba12 ~] $ vi .bash-profile

Export tTNS_ADMIN = $ HOME

:wq

Dba12   ~]$  ..bash_profile

Dba12   ~]$    vi tnsnames.ora

Tnsnames_dba12=

(              [Alias]

(

(protocol=tcp) (HOST=192.168.0.158)

(PORT=1111)

[same of dba15]

(SERVICE_NAME=bunny)

[parameter name of dba15}

:wq

Dba12~] $ tnsping tnsnames_dba12

Dba12 ~] $ sqlplus  ‘/as sysbda’

Dba12 sys> startup

Dba12 SYS> !

Dba12   ~]$ sqlplus Wilshire/Wilshire@tnsnames.dba12
(dba15’s user)

Dba12 SQL > sho user

Dba12 wilshire > select * fro tab;

[his own schema from server dba 15]

Dba15 SYS> select username, machine,

Terminal from V$ version

Where username = ‘WILSHIRE’;

Username           machine               terminal

Wilshire                dba12                    PTS/1

Dba15 SYS> !PS  -ef

(for all users remotely)

Dba15 SYS> !PS  -x

(for all users locally)

For connecting from dba12 (server) [now acting as client] as sysdba of dba15’s SYS

Dba15 ~]$ cd $ ORACLE_HOME/dbs

Dba 15 dbj]$  vi initbunny.ora

Remote_login_password file = exclusive

:wq

Dba12 dba]$ orapwd file=orapw$ ORACLE_SID

Password=bunny

Dba15 dbs]$ exit

Dba15 SYS > startup force

Dba15 SYS> select * from v$pwfile_users

 

Username           SYSDBA                                SYSOPER

SYS                         TRUE                     TRUE

Dba12  ~]$ sqlplus ‘SYS/SYS @tnsnames_dba12 as SYS dba’

Dba12 Sys> sho user

“SYS” [for the database of bunny of server dba15]

To connect remotely for more than one servers

Dba12 ~]$ vi tnsnames.ora

ALIAS 1 = (

(

(

(protocol=tcp) (Host= 192.168.0.158)

(port = 1111)

(SERVICE _ NAME= bunny)

 

ALIAS 2 = (

(

(

(protocol=tcp) (Host= 192.168.0.158)

(port =2222)

(SERVICE _ NAME= sunny)

ALIAS 3 = (

(

(

(protocol=tcp) (Host= 192.168.0.158)

(port = 3333)

(SERVICE _ NAME= funny)

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on CLIENT SIDE settings in Oracle DBA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.
    Three + 6