A: oracle64&32 Build: Oracle & 32 All need to build, there is a special document, Baidu to search, a lot of, here do not say, (because do not want to add pictures, good trouble) (test all need to build, development seems to only need 64 bit of it, not very clear, Development Ask your boss): Note 1, data sources, UESR, password best with the same (because good remember to use); 2. When uninstalling Oracle, follow the online uninstall procedure, uninstall clean (because if you do not uninstall cleanly, will affect the next reinstallation); 3. Here are some Oracle build problems and solutions: 3.1, Oracle Login problem: "Oracle database" Ora-12541:tns:no Listener detailed solution 1, regedit open service 2, Find Oracleoradb11g_home1tnslistenerTESTDB This service3, open ok!3.2, install Oracle 11g when the start service error, unable to find oraclemtsrecoveryservice mode one: Run the registry (cmd-input regedit), to HKEY_ Local_machine\system\currentcontrolset\services, find Oraclemtsrecoveryservice and Oracleremexecservice, Check that the ImagePath corresponds to the correct path, if you find dbhome_2 directly to dbhome_1 on line, because the previous installation did not uninstall clean caused. (Mine is so solved, and not universal) way two: Run cmd→net stop oraclemtsrecoveryservice SC delete OracleMTSRecoveryService3.3, oracle When you cannot install manually, use the DOM command to install (because Oracle Uninstall is not clean) Note: CD to the. exe directory for client installation, execute command in CMD; setup.exe-ignoreprereq-j "- Doracle.install.client.validate.clientsupportedoscheck=false "For server-side installation, execute command in cmd: Setup.exe-ignoreprereq-j"- Doracle.install.db.validate.supportedoscheck=false "3.4, test will go to help develop to do regression test, development will give you an Oracle address: databasedriver= Oracle.jdbc.driver.oracledriverdatabaseconnectionurl=jdbc:oracle:thin: @xx. xx.xx:000:zzzzdatabaseuser= xxxdatabasepassword=xxx3.4 steps: 1, you can parse: databaseconnectionurl=jdbc:oracle:thin:@: @xx. Xx.xx:000:zzzz is the data source, will: @ Xx.xx.xx/zzzz to the data source; Enter the username and password so you can connect to the database.
SQL for Oracle Import. dmp Files:The first step:--Create table space and index files, adjust according to project configurationCREATE tablespace "DATA01" LOGGINGdatafile ' D:\ORADATA\DATA011.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\ORADATA\DATA012.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\ORADATA\DATA013.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\ORADATA\DATA014.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\ORADATA\DATA015.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITEDEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;# DATA01 is a tablespace name# D:\ORADATA\DATA011.DBF is the path to the Oracata file to search the computer directly for the "Oradata" file .Part II:CREATE tablespace "INDEX01" LOGGINGdatafile ' D:\TTRMIS\oracle\oradata\INDEX011.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\TTRMIS\oracle\oradata\INDEX012.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\TTRMIS\oracle\oradata\INDEX013.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\TTRMIS\oracle\oradata\INDEX014.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITED,' D:\TTRMIS\oracle\oradata\INDEX015.dbf ' SIZE 1024M autoextend on NEXT 100M MAXSIZE UNLIMITEDEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;# INDEX01 is the index file name# D:\ORADATA\DATA011.DBF is the path to the Oracata file to search the computer directly for the "Oradata" file .Part III:--Create a database usercreate user Md_gdzd identified by Md_gdzd # The first "Md_gdzd" is a username the second "md_gdzd" is the password default tablespace Data01 # DATA01 is the tablespace name Temporary Tablespace tempQuota 0 on systemQuota Unlimited on data01 # DATA01 is the tablespace name --quota Unlimited on data02Quota Unlimited on index01; # index01 is the index name Grant CONNECT,RESOURCE,DBA to Md_gdzd; #MD_GDZD is the user name Grant CREATE procedure to MD_GDZD; #MD_GDZD is the user name COMMIT;--delete database user--drop USER md65_gdzd CASCADE; # MD65_GDZD is a database user Part Fourth: --Import Databaseimp testdb/[email protected] buffer=2048000 FROMUSER=ESPOS65HBG touser=testdb FILE=C:\LL_CESHI\STORE\ESPOS65HBG. DMP\ESPOS65HBG. DMPThe first "TESTDB" is the user name to create the database, and the second "TESTDB" is the password to create the database@TESTDB is the name of the table created in the TNSNames file, such as "TestCase"fromuser=md62_std "MD62_STD" is the name of the import file for example: import abcd.dmp This file then write ABCD here;Touser = MD62 This MD62 is a user name such as WangfenNote:the Direct cmd command enters the execution of this code without entering into the sql>;--Exportexp md_hnld/[email protected]/testdb buffer=2048000 owner=md_hnld file=c:\md_hnld_201803007.dmp log=c:\MD_HNLD_ 201803007_exp.log
Oracle Build _ Problem Solving _ Import Database
