Shulou(Shulou.com)06/01 Report--

I. Common commands

1. Lsnrctl command

If lsnrctl status cannot be executed, first notice if you have switched to the oracle user.

Secondly, go directly to the installation bin directory

Cd $ORACLE_HOME/bin

. / lsnrctl status

From: lsnctrl start

Stop: lsnctrl stop

2. Connect command

Ordinary users enter

Sqlplus clean/vids123

Dba users enter

Sqlplus sys/sinnren123 as sysdba

No information to enter:

Sqlplus / nolog

Connect sys/sinnren123 as sysdba

3. Start and stop the database

Startup,shutdown

4. Create a user and authorize:

Create user abc identified by 123456

Grant connect,resource,dba to abc

II. PL/SQL client connection

Sample XE and sid different links

1. Tnsnames.ora configuration

# sample XE library

XE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 172.17.10.100) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = XE)

)

)

# sample SID library

Vids =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 61.129.57.225) (PORT = 1521))

)

(CONNECT_DATA =

(SID = orclvids)

(SERVER = DEDICATED)

)

)

2. PLSQL needs to be configured

3. If an TNS error occurs, it may be a problem with environment variables. Configure ORACLE_HOME and TNS_ADMIN.

Eg:

ORACLE_HOME is the client directory of plsql: e:\ developertools\ PLSQL\ instantclient_11_2

III. Frequently asked questions

1 、 TNS:protocol adapter error

2 、 TNS:could not resolve the connect identifier specified

3. Because the target host or object does not exist

4 、 TNS:listener does not currently know of service requested in connect descriptor

These are basically configuration problems. Just take a closer look at the two steps.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.