Some questions about Oracle encountering date display issues, importing and exporting, installing, uninstalling, modifying listener profiles, creating users and tablespaces, and more.

1. Recently, some problems with Oracle have been encountered in the company. For example, after installation, after importing the backup file, it is found that the datetime display format is not normal (2014-02-12:00 00:00). Once this happens, you can be in the environment variable, Create a new NLS_TIMESTAMP_FORMAT:YYYY-MM-DD HH24:MI:SS:FF6. After restarting Plsql, you will see the time format you want.

2.oracle Database for Export import: Open cmd, enter command:

Export: Exp name/[email protected] file=d:\xx.dmp Log=xx.log

Import: Imp name/[email protected] file= d:\xx.dmp full=y log=xx.log

3. Detailed steps to uninstall oracle11g:

To completely uninstall the oracle11g step:
1. Start-> Settings-> Control Panel-> Management Tool-> Service stop all Oracle services.
2, Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer, click "Uninstall Product"-"Expand All", select except "Oradb11g_home1" All directories outside of the directory, delete.
5. Run regedit, select Hkey_local_machine\software\oracle, and press Del to delete this entry.
6. Run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete all Oracle portals (keys starting with Oracle or Oraweb).
7. Run Refedit,hkey_local_machine\system\currentcontrolset\services\eventlog\application and delete all Oracle portals.
8. Delete all keys prefixed with Ora, Oracle, ORCL or Enumora in the HKEY_CLASSES_ROOT directory.
9. Delete Hkey_current_user\software\microsoft\windows\currentversion\explorer\menuorder\start Menu\ All keys in the programs that start with Oracle.
10, delete Hkey_local_machine\software\odbc\odbcinst. INI In addition to the Microsoft ODBC for Oracle registry key, all the keys that contain Oracle.
11. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.
12. Remove all Oracle-related groups and icons from the desktop, startup Group, and Programs menu.
13. Delete all Oracle-related directories (if not deleted, restart the computer and then delete it) include:
1.c:\program file\oracle directory.
2.oracle_base directory (the installation directory for ORACLE).
3.c:\windows\system32\config\systemprofile\oracle directory.
4.c:\users\administrator\oracle or C:\Documents and settings\administrator\oracle directories.
5.c:\windows Delete the following files Oracle.ini, Oradim73. INI, Oradim80. INI, Oraodbc.ini, and so on.
If there is a [ORACLE] tag segment in the Win.ini file under 6.c:\windows, delete the segment.
14. If necessary, delete all Oracle-related ODBC DSN
15, to the Event Viewer, delete the Oracle related log description: If there are individual DLL files can not be deleted, then ignore, restart, start a new installation, install, select a new directory, then, after installation and restart, the old directory and files can be deleted.

4. Recently in the company, to modify the maximum number of connections to oracle10g, after modification, to restart the service monitoring, after the landing is no longer landing, I am not too familiar with Oracle, I looked up a lot of information, some hints, modified, requires Oracle itself to buffer a day or two, after, It is possible that it will return to normal and be able to log on. It is also suggested that the system may not be compatible after modifying the connection parameters, resulting in the inability to gain monitoring. I go to ... Finally, I can only download oracle10g, in the process of unloading, it is the life ah, in the process of unloading products, in addition to the directory, All other one by one tick delete. I'm going to take a walk, and in the process of checking, you can experience the pain and bitterness.

5. Finally attach the CREATE table space and user. and configure the Listener table content file

Create table spaces and users

C:\Documents and Settings\administrator>sqlplus/as Sysdba

Sql*plus:release 11.1.0.6.0-production on Monday July 15 18:21:54 2013

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-production

With the partitioning, OLAP, Data Mining and Real application testing options

sql> Create temporary tablespace csdbtmp

2 Tempfile ' D:\app\oradata\orcl\csdbtmp.dbf '

3 Size 100m

4 autoextend on;

The tablespace has been created.

sql> Create Tablespace Csdb

2 Logging

3 datafile ' D:\app\oradata\orcl\csdb.dbf '

4 size 2000m

5 Autoextend on next 50M MaxSize Unlimited;

The tablespace has been created.

Sql> create user Ftuser identified by unicorn406

2 Default Tablespace Csdb

3 temporary tablespace csdbtmp;

The user has created.

Sql> Grant CONNECT,RESOURCE,DBA to Ftuser;

Authorization is successful.

Sql>

Configuring Listener Table Content Files

Locate the file D:\app\product\11.1.0\db_1\network\admin\listener.ora, change the content to

Sid_list_listener =

(Sid_list =

(Sid_desc =

(Sid_name = ORCL)

(Oracle_home = D:\app\product\11.1.0\db_1)

)

)

LISTENER =

(Description_list =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = Note The user name of your machine) (PORT = 1521))

)

)

------Some people think that host should be the ID of the PC, or localhost. This is also possible, but in order to ensure that the ID will automatically modify that? If you fill in the name of the PC, it will guarantee foolproof. Hey.

Some questions about Oracle encountering date display issues, importing and exporting, installing, uninstalling, modifying listener profiles, creating users and tablespaces, and more.