Oracle 12c Insights

Tag: Start Lin Lis height port top for optimized address

1. After restarting listener, the remote client can not login, only a new start Oralce service can be normal, after analysis, with net Manager to increase the server's IP address monitoring.

Execute net START listener service name

Then the remote client is logged on successfully. As to why each restart of the server, but also to connect, there is no time to analyze why, if a friend has this experience, can be said.

2. Backup Problem of PDB database

EXPDP and IMPDP on the internet said to add a service name, expdb username/[email protected] Service name ... Later study Tnsnames.ora found that the service name is actually an IP address interpretation, under the condition of not configuring the service name, you can use:

expdb username/[email protected] or domain name: The port number/pdb the service name, also can be implemented. The same is true for exporting.

3, IMPDP optimization:

4, the main use of the command

Lsnrctl Start|stop

Lsnrctl status

Oracle 12c Insights