Sqll demekle bir basha veritabanina baglanmaq


Ilk olaraq Servere baglandigimiz zaman sqll demekle veritabanina baglana bilrikmi onu test edeek.

bash-3.00$ sqll

bash: sqll: command not found

Gorduyunuz kimi command not found hatasi aldiq.

Bunu nece aradan qladira bielrik:

1)      Root useri ile sunucuya baglaniriq. /usr/bin location gedirik.

2)      Vi sqll deyib  icherisine sqlplus “/ as sysdba”; yazib wq! (save) edirik

3)      Root user ile Chmod 777 /usr/bin/sqll  Premession  veririk

4)      Root userinden oracle userien switch edirik.

root@ANARDBdr # su - oracleOracle Corporation      SunOS 5.10      Generic Patch   January 2005You have new mail.Ve yeniden sqll ile veritabanina baglanmaga chalishaq:bash-3.2$ sqllSQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 25 10:26:37 2013Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing optionsSQL> SQL> select name,open_mode from v$database;NAME      OPEN_MODE--------- --------------------TST    MOUNTED



Gorduyunuz kimi sqll ile veritabanina baglan bildik.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: