12cR2静默建库，报错如下：
[oracle@rhel6lhr dbs]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
> -gdbname lhr122 -sid lhr122 \
> -createAsContainerDatabase false \
> -sysPassword lhr -systemPassword lhr -serviceUserPassword lhr \
> -datafileDestination '/u04/oradata' -recoveryAreaDestination '/u04/flash_recovery_area' \
> -storageType FS \
> -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 \
> -sampleSchema true \
> -memoryPercentage 10 \
> -databaseType OLTP \
> -emConfiguration NONE
[WARNING] [DBT-14501] The version of the Oracle Grid Infrastructure for Standalone Server software is lower than database software version. Created database will not be registered with Oracle Grid Infrastructure.
ACTION: Upgrade the version of the Grid Infrastructure software to register the database.
[FATAL] [DBT-10317] Specified SID Name (lhr122) already exists.
ACTION: Specify a different SID Name that does not already exist.
解决：
1、查看/etc/oratab中是否还有SID
2、ps -ef|grep SID ，查看是否后台进程还有SID
[oracle@rhel6lhr dbs]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -responseFile NO_VALUE \
> -gdbname lhr122 -sid lhr122 \
> -createAsContainerDatabase false \
> -sysPassword lhr -systemPassword lhr -serviceUserPassword lhr \
> -datafileDestination '/u04/oradata' -recoveryAreaDestination '/u04/flash_recovery_area' \
> -storageType FS \
> -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 \
> -sampleSchema true \
> -memoryPercentage 10 \
> -databaseType OLTP \
> -emConfiguration NONE
[WARNING] [DBT-14501] The version of the Oracle Grid Infrastructure for Standalone Server software is lower than database software version. Created database will not be registered with Oracle Grid Infrastructure.
ACTION: Upgrade the version of the Grid Infrastructure software to register the database.
[FATAL] [DBT-10317] Specified SID Name (lhr122) already exists.
ACTION: Specify a different SID Name that does not already exist.
解决：
1、查看/etc/oratab中是否还有SID
2、ps -ef|grep SID ，查看是否后台进程还有SID
About Me
...............................................................................................................................
● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用
● 本文在itpub（http://blog.itpub.net/26736162）、博客园（http://www.cnblogs.com/lhrbest）和个人微信公众号（xiaomaimiaolhr）上有同步更新
● 本文itpub地址：http://blog.itpub.net/26736162/viewspace-2135035/
● 小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/
● QQ群：230161599 微信群：私聊
● 联系我请加QQ好友(642808185)，注明添加缘由
● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解
● 版权所有，欢迎分享本文，转载请保留出处
...............................................................................................................................
拿起手机使用微信客户端扫描下边的左边图片来关注小麦苗的微信公众号：xiaomaimiaolhr，扫描右边的二维码加入小麦苗的QQ群，学习最实用的数据库技术。
![[Err] 1143 - SELECT command denied to user 'XX'@'%' for column 'XXX' in table 'XX'](https://ucc.alicdn.com/pic/developer-ecology/1812874d6bd5432ebb1884428a4d9cc2.png?x-oss-process=image/resize,h_160,m_lfit)