netca oracle 11g [RESOLVIDO]

juliansoares
(usa Debian)

Enviado em 04/07/2012 - 15:49h

Boa tarde linuxers!!!

Instalei o oracle 11g em minha máquina. Configurei tudo e instalou normalmente. Porém não consigo executar o comando netca nem dbca: dá um erro. Já olhei no log e não encontrei nada sobre o mesmo. Segue:

oracle@zeus ~ $ netca



Configuração de Serviços do Oracle Net:

No protocol specified

Error: null

Verifique o arquivo de rastreamento para obter detalhes: /opt/oracle/app/oracle/cfgtoollogs/netca/trace_OraDb11g_home1-1207043PM4858.log

A configuração de Serviços do Oracle Net falhou. O código de saída é 1

oracle@zeus ~ $ cat /opt/oracle/app/oracle/cfgtoollogs/netca/trace_OraDb11g_home1-1207043PM1722.log

[main] [ 2012-07-04 15:17:22.729 GMT-03:00 ] [NetCALogger.initTrace:203]  Oracle Net Configuration Assistant: 1207043PM1722

[main] [ 2012-07-04 15:17:22.730 GMT-03:00 ] [NetCALogger.initTrace:204]  Oracle Home: /opt/oracle/app/oracle/product/11.2.0/dbhome_1

[main] [ 2012-07-04 15:17:22.730 GMT-03:00 ] [NetCALogger.initTrace:205]  Oracle Base: /opt/oracle/app/oracle

[main] [ 2012-07-04 15:17:22.730 GMT-03:00 ] [NetCALogger.initTrace:206]  Oracle Home Name: OraDb11g_home1

[main] [ 2012-07-04 15:17:22.752 GMT-03:00 ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[main] [ 2012-07-04 15:17:22.752 GMT-03:00 ] [HAUtils.<init>:188]  oui location /opt/oracle/app/oraInventory/ContentsXML

[main] [ 2012-07-04 15:17:22.767 GMT-03:00 ] [Version.isPre:274]  version to be checked 11.2.0.1.0 major version to check against10

[main] [ 2012-07-04 15:17:22.768 GMT-03:00 ] [Version.isPre:285]  isPre.java: Returning FALSE

[main] [ 2012-07-04 15:17:22.771 GMT-03:00 ] [OCR.loadLibrary:308]  

 Inside constructor of OCR

[main] [ 2012-07-04 15:17:22.784 GMT-03:00 ] [OCR.loadLibrary:316]  Going to load the ocr library

[main] [ 2012-07-04 15:17:22.785 GMT-03:00 ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false

[main] [ 2012-07-04 15:17:22.785 GMT-03:00 ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false

[main] [ 2012-07-04 15:17:22.785 GMT-03:00 ] [Library.load:254]  Loading  library /opt/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libsrvmocr11.so

[main] [ 2012-07-04 15:17:22.787 GMT-03:00 ] [OCR.loadLibrary:318]  loaded ocr libraries

[main] [ 2012-07-04 15:17:22.787 GMT-03:00 ] [OCR.isCluster:939]  Calling OCRNative for isCluster()

[main] [ 2012-07-04 15:17:22.790 GMT-03:00 ] [OCR.isCluster:943]  OCR Result status = true

[main] [ 2012-07-04 15:17:22.791 GMT-03:00 ] [OCR.isCluster:955]  Bolean result = false

[main] [ 2012-07-04 15:17:22.795 GMT-03:00 ] [CmdlineArgs.<init>:110]  Initializing variables array...

[main] [ 2012-07-04 15:17:22.795 GMT-03:00 ] [CmdlineArgs.<init>:116]  Initializing NetProperties...

[main] [ 2012-07-04 15:17:22.796 GMT-03:00 ] [CmdlineArgs.initArgs:133]  Initializing command line arguments...

[main] [ 2012-07-04 15:17:22.797 GMT-03:00 ] [CmdlineArgs.setOraArgs:236]  Setting Oracle arguments...

[main] [ 2012-07-04 15:17:22.797 GMT-03:00 ] [CmdlineArgs.setOraArgs:240]  Passed Oracle Home = NO_VALUE

[main] [ 2012-07-04 15:17:22.797 GMT-03:00 ] [CmdlineArgs.setOraArgs:243]  Read Oracle Home = /opt/oracle/app/oracle/product/11.2.0/dbhome_1

[main] [ 2012-07-04 15:17:22.798 GMT-03:00 ] [CmdlineArgs.setOraArgs:246]  Read Oracle Home ID = 

[main] [ 2012-07-04 15:17:22.798 GMT-03:00 ] [CmdlineArgs.setOraArgs:249]  Read Oracle Home Name = null

[main] [ 2012-07-04 15:17:22.798 GMT-03:00 ] [CmdlineArgs.setOraArgs:257]  Setting Oracle Home = /opt/oracle/app/oracle/product/11.2.0/dbhome_1

[main] [ 2012-07-04 15:17:22.799 GMT-03:00 ] [InitialSetup.configureOPS:4504]  Cluster mode is OFF

[main] [ 2012-07-04 15:17:22.799 GMT-03:00 ] [InitialSetup.<init>:4028]  TNS_ADMIN is: null

[main] [ 2012-07-04 15:17:22.803 GMT-03:00 ] [OPSUtil.getHomeVersion:446]  Inside getHomeVersion...

[main] [ 2012-07-04 15:17:22.804 GMT-03:00 ] [OPSUtil.getHomeVersion:447]  oracleHome = /opt/oracle/app/oracle/product/11.2.0/dbhome_1

[main] [ 2012-07-04 15:17:22.804 GMT-03:00 ] [OPSUtil.getHomeVersion:451]  oracle.sysman.assistants.util.OracleHome Object = /opt/oracle/app/oracle/product/11.2.0/dbhome_1

[main] [ 2012-07-04 15:17:22.805 GMT-03:00 ] [OracleHome.getVersion:877]  OracleHome.getVersion called.  Current Version: null

[main] [ 2012-07-04 15:17:22.807 GMT-03:00 ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[main] [ 2012-07-04 15:17:22.807 GMT-03:00 ] [OracleHome.getVersion:896]  Homeinfo /opt/oracle/app/oracle/product/11.2.0/dbhome_1,1

[main] [ 2012-07-04 15:17:23.247 GMT-03:00 ] [OracleHome.getVersion:922]  OracleHome.server.getVersion Version: 11.2.0.1.0

[main] [ 2012-07-04 15:17:23.247 GMT-03:00 ] [OracleHome.getVersion:943]  Current Version From Inventory: 11.2.0.1.0

[main] [ 2012-07-04 15:17:23.248 GMT-03:00 ] [OracleHome.getVersion:948]  using sqlplus: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

[main] [ 2012-07-04 15:17:23.248 GMT-03:00 ] [OPSUtil.getHomeVersion:452]  returning oracleHome Version = 11.2.0.1.0

[main] [ 2012-07-04 15:17:23.249 GMT-03:00 ] [OracleHome.getVersion:877]  OracleHome.getVersion called.  Current Version: 11.2.0.1.0

[main] [ 2012-07-04 15:17:23.249 GMT-03:00 ] [OracleHome.getVersion:943]  Current Version From Inventory: 11.2.0.1.0

[main] [ 2012-07-04 15:17:23.249 GMT-03:00 ] [OracleHome.getVersion:948]  using sqlplus: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

[main] [ 2012-07-04 15:17:23.250 GMT-03:00 ] [InitialSetup.<init>:4041]  Admin location is: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin

[main] [ 2012-07-04 15:17:23.295 GMT-03:00 ] [OsUtilsBase.getBaseFromOrabase:516]  oraBaseUtility /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase

[main] [ 2012-07-04 15:17:23.296 GMT-03:00 ] [OsUtilsBase.getBaseFromOrabase:525]  cmds: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/bin/orabase

[main] [ 2012-07-04 15:17:23.320 GMT-03:00 ] [OsUtilsBase.getBaseFromOrabase:530]  baseLocation from orabase 

/opt/oracle/app/oracle

[main] [ 2012-07-04 15:17:23.321 GMT-03:00 ] [OsUtilsBase.getBaseFromOrabase:555]   orabaseLocation= /opt/oracle/app/oracle

[main] [ 2012-07-04 15:17:23.321 GMT-03:00 ] [ConfigureProfile.setProfileParam:136]  Setting ADR_BASE: /opt/oracle/app/oracle

java.lang.NullPointerException

	at oracle.ewt.lwAWT.BufferedApplet.<init>(Unknown Source)

	at oracle.net.ca.NetCA.<init>(NetCA.java:420)

	at oracle.net.ca.NetCA.main(NetCA.java:406)







oracle@zeus ~ $ dbca 

No protocol specified

 

PS: isso tudo sendo executado como user oracle, agora com meu usuario, já add no grupo oinstall e dba, aparece isso :

julian@zeus ~ $ netca

java.lang.NoClassDefFoundError: oracle/sysman/oii/oiil/OiilNativeException

	at oracle.net.ca.NetCAUtils.getOracleBase(NetCAUtils.java:69)

	at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:218)

	at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130)

	at oracle.net.ca.NetCA.main(NetCA.java:404)



Error: oracle/sysman/oii/oiil/OiilNativeException

A configuração de Serviços do Oracle Net falhou. O código de saída é 1

 

juliansoares
(usa Debian)

Enviado em 24/07/2012 - 10:55h

consegui resolver isso com

xhost +localhost


criei o listener e também o banco de dados , agora qndo entro pelo sqlplus

pede user e senha e não sei qual é ? já tentei system e a senha cadastrada na config do dbca

entrando como sqlplus / as sysdba consegui entrar, mas qndo tento startar o banco não vai :

oracle@zeus ~/app/oracle/product/11.2.0/dbhome_1/bin $ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 24 15:08:35 2012

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initCFLEX.ora'

thierryvdb
(usa Fedora)

Enviado em 31/01/2013 - 20:09h

Amigo quanto a usuario e senha é a menor preocupação.

tente logar utilizando sqlplus / as sysdba.


O erro que esta acontecendo é que criou a instancia, mas nao foi criado o initfile (initCFLEX.ora). Sera que nao confundiu a localização de instalação do software?

juliansoares
(usa Debian)

Enviado em 31/01/2013 - 21:39h

reinstalei o oracle e configurei novamente, e deu certo.