![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 81
iteye_9496
这个作者很懒,什么都没留下…
展开
-
ORA-12541: TNS no listener
cannot connect to oracle due to error "ORA-12541: TNS no listener". casuse: most likely the Oracle listener is not started. solution: you need to logon to the database server as oracle user or ...原创 2012-07-04 14:02:48 · 114 阅读 · 0 评论 -
老是忘记的Oracel sql statements
-- find oracle version SELECT * FROM SYS.product_component_version; -- find table meta data: table name is in upper case select * from all_tables WHERE TABLE_NAME = 'CUSTOMERS'; -- find constr...原创 2012-07-04 14:09:03 · 93 阅读 · 0 评论 -
Start/shutdown oracle
## set the database to logon export ORACLE_SID=mydb ## conect sqlplus to the target database sqlplus / as sysdba ## make sure connected to the correct database SQL>show user; user is "SYS" SQ...2012-10-06 16:26:47 · 105 阅读 · 0 评论 -
manually create a new oracle database
using [b]dbca[/b] to create a database is preferred approach: http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm The following describes MANUALLY creating a new oracle database: ...2012-10-06 18:25:05 · 86 阅读 · 0 评论 -
cold back up an oracle database
Refrence: search "Oracle DBA Justin - How to backup an 11g Oracle database cold" on YouTube http://www.youtube.com/watch?v=iH0E-g9qj90&feature=relmfu "Cold Backup" means to shutdown the Oracle ...2012-10-06 19:23:28 · 73 阅读 · 0 评论 -
manually drop and delete an Oracle database
Using DBCA command line to delete a database is quite simple: dbca -silent -deleteDatabase -sourceDB dbSID2delete The following describes MANUALLY delete a database: Refrence: Search "Orac...2012-10-06 19:43:55 · 92 阅读 · 0 评论 -
Use Oracle DBCA silent mode to create new database from template
### command line to use Oracle DBCA (-silent) to create a new dabase, using a NoSeed template ### 1. replace "SIDofNewDb" with the "SID" for your new database ### 2. you can edit the template to ...原创 2012-10-12 12:23:51 · 195 阅读 · 0 评论 -
When to configure an XA datasource?
If you ever came across this warning message from JBoss, you might wonder what's wrong: [b]WARN [TxConnectionManager] Prepare called on a local tx. Use of local transactions on a jta transaction wi...2012-11-16 12:58:33 · 137 阅读 · 0 评论