博文

目前显示的是标签为“oracle12c”的博文

Oracle 12c jdbc connect string for PDB

Ref :  h t t p s:// forums.oracle.com/thread/2566804 1 . link string in code # <!--指定连接数据库用的驱动 ojdbc6.jar--> database.driver=oracle.jdbc.OracleDriver #// oracle.jdbc.driver.OracleDriver is deprecated and replaced with oracle.jdbc.OracleDriver. #h t tp://download.oracle.com/otn_hosted_doc/jdeveloper/905/jdbc-javadoc/oracle/jdbc/OracleDriver.html # <!--指定连接数据库的路径--> # for oracle 11g database.url= jdbc:oracle:thin:@localhost:1521:orcl # for oracle 12c1 database.url= jdbc:oracle:thin:@//127.0.0.1:1522/pdborcl or database.url= jdbc:oracle:thin:@127.0.0.1:1522/pdborcl #<!--指定连接数据库的用户名--> database.username=test # <!--指定连接数据库的密码--> database.password=test <!--指定数据库使用的SQL--> hibernate.dialect=org.hibernate.dialect.Oracle9Dialect #org.hibernate.dialect.OracleDialect #Oracle10gDialect # <!--当show_sql属性为true时表示在程序运行时在控制台输出SQL语句,默认为false--> hibernate.show_sql=false oracle.maxConnection=100 oracle.expireTime=2400000 oracle.updateTim...

Oracle 12c - need to start container AND pluggable databases

From : blog .contractoracle. com/2013/06/ oracle-12c-need-to-start-container-and. html Oracle 12c - need to start container AND pluggable databases.  In Oracle 12c we start the Container Database (CDB) the same as we started previous database versions. [oracle@rac1 lib]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Thu Jun 27 14:47:35 2013 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2289016 bytes Variable Size             989856392 bytes Database Buffers          654311424 bytes Redo Buffers                7061504 bytes Database mounted. Database opened. But then we find that the Pluggable Databases (PDBs) are still in "MOUNTED" ...