Oracle Telnet sqlplus TNS: no monitoring

1. Change localhost to computer name best-pc, or IP address. I changed the computer name because I often switch between the wireless network and the Limited network

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = d:\app\long.yue\product\11.2.0\dbhome_2)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\app\long.yue\product\11.2.0\dbhome_2\bin\oraclr11.dll")
)
)


LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = best-pc) (PORT = 1521))
)
)


Adr_base_listener = D:\app

2. Restart Listener Service

Fault resolution

If you still have a problem, please continue to modify the Tnsnames.ora file located in d:\app\long.yue\product\11.2.0\dbhome_2\network\admin\ Tnsnames.ora (the path for each person to install Oracle will vary, please do so)

LocalHost is replaced with native IP or computer name

The final recommendation: if you are dynamically acquiring IP or multiple network adapters, set the computer name

============================

SELECT * from v$version where rownum <=1; Version number of the--oracle

Step One: Delete user
Drop Userxxcascade

Note: Delete the user, just delete the schema objects under the user, will not delete the corresponding tablespace.

Step Two: Delete tablespace
Alter tablespace DMS offline;
Drop tablespace DMS including contents and datafiles cascade constraints;

Step Three: Create Tablespace
Create Tablespace DMS
Logging
DataFile ' F:\Tools\Oracle\app\oradata\orcl\DMS.dbf '
Size 2000m
Autoextend on
Next 100m
MaxSize 5024m;
-Increase
ALTER tablespace tstemptest
ADD Tempfile
' F:\Tools\Oracle\app\oradata\orcl\dms2. DBF ' SIZE 64M autoextend on NEXT 32M MaxSize Unlimited;

Step four: Create a user
--Create the user
Create User Dev
Identified by Dev
Default Tablespace DMS
Temporary tablespace TEMP
Profile DEFAULT;
--Grant/revoke role privileges
Grant dba to Dev;
Grant resource to Dev;
Grant connect to Dev;

Step Five: Exp/imp
--Export multiple Table:t1,t2,t3
Exp Username/[email protected] tables=t1,t2,t3 file=d:\tbs.dmp log=d:\tbs.log grants=y
--Export the entire shcema:
Exp Dev/[email protected] Owner=dev file=f:\dev_20140716.dmp grants=y log=d:\tbs.log
--Import data
IMP Devsc/[email protected] file=f:\project\devsc170828. DMP full=y log=f:\project\devsc170828. LOG

Imp lis/[email protected] file=exp.dmp frouser=lis touser=lis log=d:\tbs.log
Use CMD to enter the folder where the Exp.demp file is located.
Using the IMP statement: IMP lis/[email protected] file=exp.dmp frouser=lis Touser=lis
Error imp-00013:
There are two ways to resolve this:
1). Use DBA user to import imp sys/sys file=exp.dmp fromuser=sys touser=lis ignore=yes
2). Assign DBA authority to LIS. Execute Grant DBA to LIS using SYS login pl\sql;
And then execute the statement
Imp lis/[email protected] file=exp.dmp frouser=lis touser=lis log=dev_miracle_news_back20140526.log log=d:\tbs.log

Step Six: EXPDP/IMPDP
Sql>drop directory DPDATA1;
Sql>create directory dpdata1 as ' F:/project ';
Sql>select * from Dba_directories;
Sql>grant read, write on directory dpdata1 to Dev
1) According to the user guide
EXPDP Dev/[email protected] Schemas=dev dumpfile=expdp11g_expdp_20150909_es.dmp directory=dpdata1;
2) Parallel Process parallel
EXPDP Scott/[email protected] directory=dpdata1 dumpfile=scott3.dmp parallel=40 job_name=scott3
3) According to the table name guide
EXPDP Scott/[email protected] tables=emp,dept dumpfile=expdp.dmp directory=dpdata1;
4) Guided by query criteria
EXPDP Scott/[email protected] directory=dpdata1 dumpfile=expdp.dmp tables=emp query= ' WHERE deptno=20 ';
5) According to the Table space Guide
EXPDP System/manager directory=dpdata1 dumpfile=tablespace.dmp tablespaces=temp,example;
6) Guide the entire database
EXPDP System/manager directory=dpdata1 dumpfile=full.dmp full=y;
1) leads to the specified user
IMPDP Dev/[email protected] Schemas=dev dumpfile=expdp11g_20150420_000000.dmp directory=dpdata1
2) Change the owner of the table
IMPDP system/manager directory=dpdata1 dumpfile=expdp.dmp tables=scott.dept remap_schema=scott:system;
3) Import Table space
IMPDP System/manager directory=dpdata1 dumpfile=tablespace.dmp tablespaces=example;
4) Import the database
impdb System/manager directory=dump_dir dumpfile=full.dmp full=y;
5) Append Data
IMPDP system/manager directory=dpdata1 dumpfile=expdp.dmp schemas=system table_exists_action=append;

Oracle Telnet sqlplus TNS: no monitoring