# Sqlplus ашиглан client ээс server руу as sysdba privilege ээр холбогдож болохуу?

**URL:** <https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830>\
**Category:** Oracle Database\
**Created:** [September 12, 2018, 7:36am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830 "2018-09-12T07:36:38Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rdn](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/r/e99b99/32.png) [@Rdn](https://www.batmunkh.net/u/Rdn)\
**Post date:** [September 12, 2018, 7:36am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/1 "2018-09-12T07:36:38Z")

</div>

host /windows/ дээр ажиллах боломжгүй байгаан

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [September 12, 2018, 8:09am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/2 "2018-09-12T08:09:15Z")

</div>

Болно

```
sqlplus username/pass@IP_ADDRESS:PORT/[SID|SERVICE_NAME] as sysdba

```

коммандыг ашиглана.

Жш:

```
sqlplus sys/pass@192.168.1.5:1521/ORCL as sysdba

```

SQL promt -с

```
SQL> connect sys/pass@192.168.1.5:1521/ORCL as sysdba

```

Энэ нь EZ\_CONNECT аргачилал юм.

---

<div class="post-metadata">

**Author:** ![Rdn](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/r/e99b99/32.png) [@Rdn](https://www.batmunkh.net/u/Rdn)\
**Post date:** [September 12, 2018, 8:33am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/3 "2018-09-12T08:33:27Z")

</div>

sys user iin pass ийг мэдэхгүй эсвэл account locked болсон үед яахуу?

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [September 12, 2018, 8:38am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/4 "2018-09-12T08:38:23Z")

</div>

locked account-ийн хувьд шинэ нууц үг өгнө.

```
SQL> alter user MYSUER identified by MYPASS account unlock;

```

Sys нууц үгийн хувьд orapwd коммандын тусламжтай сэргээж болно. Эсвэл тухайн сервер дээрээс ‘sqlplus / as sysdba’ коммандаар хандаж дараах коммандыг ашиглаж болно.

```
SQL> alter user sys identified by MYPASS; 

```

ORAPWD жишээ:

```
[~/] cd $ORACLE_HOME/dbs
[~/] orapwd file=orapwd[SID] password=MYPASS entries=5

```

SID хэсэгт инстансын нэр байх хэрэгтэй.

#Linux, *nix

> hints:  
> password file байхгүй тохиолдолд sys хэрэглэгчээр гаднаас (сүлжээгээр) хандах боломжгүй.

---

<div class="post-metadata">

**Author:** ![Rdn](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/r/e99b99/32.png) [@Rdn](https://www.batmunkh.net/u/Rdn)\
**Post date:** [September 12, 2018, 8:46am UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/5 "2018-09-12T08:46:05Z")

</div>

thank you sir

---

<div class="post-metadata">

**Author:** ![tumenjargal](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenjargal/32/236_2.png) [@tumenjargal](https://www.batmunkh.net/u/tumenjargal)\
**Post date:** [September 12, 2018, 12:11pm UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/6 "2018-09-12T12:11:10Z")

</div>

> [@batmunkh](#):
>
> сүлжээгээр

and REMOTE\_LOGIN\_PASSWORDFILE must be EXCLUSIVE 🙂

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [September 12, 2018, 12:20pm UTC](https://www.batmunkh.net/t/sqlplus-client-server-as-sysdba-privilege/830/7 "2018-09-12T12:20:06Z")

</div>

> [@tumenjargal](#):
>
> and REMOTE\_LOGIN\_PASSWORDFILE must be EXCLUSIVE

community advantage :D/