search

mikhailidim / chronicler-comments

0 stars 0 forks source link

https://chronicler.tech/mint-oracle-18c-xe/ #7

Open utterances-bot opened 5 years ago

utterances-bot commented 5 years ago

Oracle XE 18c on Debian Linux

Oracle Database XE 18c install guide Debian Linux , For example. Mint, Ubuntu, LMDE. Post guides you through preparation, installation, and configuration .

https://chronicler.tech/mint-oracle-18c-xe/

bytesmx commented 5 years ago

Hi Michael, I've followed every step in your tutorial, but I couldn't install XE on Linux MInt 19.3

At the time of executing "sudo /etc/init.d/oracle-xe-18c-cfg configure" for the first time, the process fails, on the second attempt, the process got stuck at 7%. =(

any ideas?? Can you help me please?

mikhailidim commented 5 years ago

Hi, I'd like to see an error messages when your installation fails.

On Mon, Aug 26, 2019 at 12:38 AM bytesmx notifications@github.com wrote:

Hi Michael, I've followed every step in your tutorial, but I couldn't install XE on Linux MInt 19.3

At the time of executing "sudo /etc/init.d/oracle-xe-18c-cfg configure" for the first time, the process fails, on the second attempt, the process got stuck at 7%. =(

any ideas?? Can you help me please?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/mikhailidim/chronicler-comments/issues/7?email_source=notifications&email_token=ACNMKYGW3KGKSQWJLXFTUMTQGNM5XA5CNFSM4IPLVT52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD5DHU3I#issuecomment-524712557, or mute the thread https://github.com/notifications/unsubscribe-auth/ACNMKYEUU2PLJECMDAHTOGLQGNM5XANCNFSM4IPLVT5Q .

bytesmx commented 5 years ago

Hi Michael, sorry for the waiting time,

When I execute first time, I got this on CLI

sudo /etc/init.d/oracle-xe-18c-cfg configure [sudo] contraseña para brujo:
/bin/df: unrecognized option '--direct' Pruebe '/bin/df --help' para más información. Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration failed. Check log '/opt/oracle/cfgtoollogs/netca/netca_configure_out.log' for more details.

The log says:

more /opt/oracle/cfgtoollogs/netca/netca_configure_out.log

Analizando argumentos de la línea de comandos: Parámetro "orahome" = /opt/oracle/product/18c/dbhomeXE Parámetro "instype" = typical Parámetro "inscomp" = client,oraclenet,javavm,server,ano Parámetro "insprtcl" = tcp Parámetro "cfg" = local Parámetro "authadp" = NO_VALUE Parámetro "responsefile" = /opt/oracle/product/18c/dbhomeXE/network/install/netca_typ.rsp Parámetro "silent" = true Parámetro "orahnam" = OraHomeXE Parámetro "listenerparameters" = DEFAULT_SERVICE=XE Análisis de los argumentos de la línea de comandos listo. Configuración de Servicios de Red de Oracle: Configuración del perfil terminada. Inicio del Listener de Red de Oracle: No se ha devuelto ninguna dirección IP válida para el host brujo. Compruebe el archivo de rastreo para obtener más información: /opt/oracle/cfgtoollogs/netca/trace_OraHomeXE-1910031PM463 4.log Fallo al configurar los Servicios de Red de Oracle. El código de salida es 1

Basicly, the error say that I no have an IP for localhost, but mi hosts file is this

more /etc/hosts 127.0.0.1 localhost 127.0.1.1 brujo

The following lines are desirable for IPv6 capable hosts

::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters

When I tried a second time, the process just got stuck in 7%

sudo /etc/init.d/oracle-xe-18c-cfg configure /bin/df: unrecognized option '--direct' Pruebe '/bin/df --help' para más información. Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database XE. Introduzca la contraseña de usuario SYS:

Introduzca la contraseña de usuario SYSTEM:

Introduzca la contraseña de usuario de PDBADMIN:

Preparar para funcionamiento de base de datos 7% finalizado Copiando archivos de base de datos

Can you help me??

mikhailidim commented 5 years ago

HI, not sure if Google Translate is good in Spanish but for me it sounds like netca can't find the IP address for host brujo. Check the results of the hostname and domainname commands and make sure that you have your hostname in the /etc/hosts file.

Plus, your entry for 12.0.0.1 is a little bit not canonical. The standard entry has to be the first entry and looks similar to this:

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

On Thu, Oct 3, 2019 at 2:59 PM bytesmx notifications@github.com wrote:

Hi Michael, sorry for the waiting time,

When I execute first time, I got this on CLI

sudo /etc/init.d/oracle-xe-18c-cfg configure [sudo] contraseña para brujo: /bin/df: unrecognized option '--direct' Pruebe '/bin/df --help' para más información. Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration failed. Check log '/opt/oracle/cfgtoollogs/netca/netca_configure_out.log' for more details.

The log says:

more /opt/oracle/cfgtoollogs/netca/netca_configure_out.log

Analizando argumentos de la línea de comandos: Parámetro "orahome" = /opt/oracle/product/18c/dbhomeXE Parámetro "instype" = typical Parámetro "inscomp" = client,oraclenet,javavm,server,ano Parámetro "insprtcl" = tcp Parámetro "cfg" = local Parámetro "authadp" = NO_VALUE Parámetro "responsefile" = /opt/oracle/product/18c/dbhomeXE/network/install/netca_typ.rsp Parámetro "silent" = true Parámetro "orahnam" = OraHomeXE Parámetro "listenerparameters" = DEFAULT_SERVICE=XE Análisis de los argumentos de la línea de comandos listo. Configuración de Servicios de Red de Oracle: Configuración del perfil terminada. Inicio del Listener de Red de Oracle: No se ha devuelto ninguna dirección IP válida para el host brujo. Compruebe el archivo de rastreo para obtener más información: /opt/oracle/cfgtoollogs/netca/trace_OraHomeXE-1910031PM463 4.log Fallo al configurar los Servicios de Red de Oracle. El código de salida es 1

Basicly, the error say that I no have an IP for localhost, but mi hosts file is this

more /etc/hosts 127.0.0.1 localhost 127.0.1.1 brujo The following lines are desirable for IPv6 capable hosts

::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters

When I tried a second time, the process just got stuck in 7%

sudo /etc/init.d/oracle-xe-18c-cfg configure /bin/df: unrecognized option '--direct' Pruebe '/bin/df --help' para más información. Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database XE. Introduzca la contraseña de usuario SYS:

Introduzca la contraseña de usuario SYSTEM:

Introduzca la contraseña de usuario de PDBADMIN:

Preparar para funcionamiento de base de datos 7% finalizado Copiando archivos de base de datos

Can you help me??

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mikhailidim/chronicler-comments/issues/7?email_source=notifications&email_token=ACNMKYD5L2KU52CU57FF3WTQMY6HLA5CNFSM4IPLVT52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAJHFCA#issuecomment-538079880, or mute the thread https://github.com/notifications/unsubscribe-auth/ACNMKYE3LDJ7KBYPKIVLH33QMY6HLANCNFSM4IPLVT5Q .

bytesmx commented 5 years ago

Hi Michael, thanks for your time.

I tried and tried and tried... but simply I couldn't install oracle.

Some of solutions I tried was:

No matter what I do, the process just got stuck at 7%.

I did the same process in 3 different computers, and the result was the same.

In the end, I believe that is error when convert from rmp to deb. A bug in the installer process o just XE 12c is just installable in pc with specifics components. I don't know.

Thanks for time, I'll wait for an update to XE 12c, In the meantime I will stay with XE 11g.

Regards.

oscasc commented 4 years ago

Hi! I had, the same problem with a _oracle-database-xe-18c_1.0-2amd64.deb with Ubuntu 19.10 (converted from rpm using 'alias').

I revised my localdomain , then set with: $sudo domainname miEmpresa.local then edited the /etc/hosts (with my local IP address)

127.0.0.1 localhost.localdomain localhost 10.128.117.48 osalgado.miEmpresa.local osalgado

then executed again: $ sudo /etc/init.d/oracle-xe-18c-cfg configure

...and everything ok! I think it's not the alias convertion from rpm to deb.

By the way!!! before it, I installed net-tools. I hadn't ifconfig. $ sudo apt install net-tools

I hope it work for you. Best Regards.

mikhailidim commented 4 years ago

Glad to hear that! Good luck with your new XE!

On Tue, Jan 21, 2020 at 11:08 AM Oscar Salgado notifications@github.com wrote:

Hi! I had, the same problem with a oracle-database-xe-18c_1.0-2_amd64.deb with Ubuntu 19.10 (converted from rpm using 'alias').

I revised my localdomain , then set with: $sudo domainname miEmpresa.local then edited the /etc/hosts (with my local IP address)

127.0.0.1 localhost.localdomain localhost 10.128.117.48 osalgado.miEmpresa.local osalgado

then executed again: $ sudo /etc/init.d/oracle-xe-18c-cfg configure

...and everything ok! I think it's not the alias convertion from rpm to deb.

By the way!!! before it, I installed net-tools. I hadn't ifconfig. $ sudo apt install net-tools

I hope it work for you. Best Regards.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mikhailidim/chronicler-comments/issues/7?email_source=notifications&email_token=ACNMKYEACYYLMHLOSHYMVDDQ64MWLA5CNFSM4IPLVT52YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJQI7QI#issuecomment-576753601, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACNMKYHKVWJ6MZVC3AXI4CLQ64MWLANCNFSM4IPLVT5Q .

bytesmx commented 4 years ago

Hi Mike / Oscar, I ran to try this solution, but no luck, my life is so sad.........

I must say, is the fifth pc where I tried to install XE.

wanderer2022 commented 4 years ago

Dear Michael, we tried a lot to make it work, but its allways stopping when detected a running Oracle Database. The output is: Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database XE. SYS-Benutzerkennwort eingeben:

SYSTEM-Benutzerkennwort eingeben:

PDBADMIN-Benutzerkennwort eingeben:

DB-Vorgang vorbereiten 7 % abgeschlossen Datenbankdateien werden kopiert 8 % abgeschlossen [WARNING] ORA-01081: cannot start already-running ORACLE - shut it down first

9 % abgeschlossen [FATAL] ORA-01034: ORACLE not available

29 % abgeschlossen 100 % abgeschlossen [FATAL] ORA-01034: ORACLE not available

7 % abgeschlossen 0 % abgeschlossen Weitere Einzelheiten finden Sie in der Logdatei "/opt/oracle/cfgtoollogs/dbca/XE/XE4.log".

The problem, there is no running Oracle database and inside the Logdatei we only find the running Oracle Database. Have you any idea what we can try to make it run? Best wishes Hans

calegrias commented 4 years ago

Hi Michael, I tried your instructions on an Ubuntu 20.04 Desk using the same version of Oracle rpm package oracle-database-xe-18c-1.0-1.x86_64.rpm and got the following error several times on step 3 of your instructions with the deb conversion unsuccessful:

warning: oracle-database-xe-18c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Also on that step I had to execute the alien command using sudo and the parameter was scripts plural: sudo alien --scripts oracle-database-xe-18c-1.0-1.x86_64.rpm

Any help would be appreciated,

mikhailidim commented 4 years ago

Hin, Thank you for the question. I haven't tried it with Ubuntu, plus 20.04 has a different kernel and C libraries. Let me look into it.

On Tue, Jun 30, 2020 at 1:13 PM calegrias notifications@github.com wrote:

Hi Michael, I tried your instructions on an Ubuntu 20.04 Desk using the same version of Oracle rpm package oracle-database-xe-18c-1.0-1.x86_64.rpm and got the following error several times on step 3 of your instructions with the deb conversion unsuccessful:

warning: oracle-database-xe-18c-1.0-1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Also on that step I had to execute the alien command using sudo and the parameter was scripts plural: sudo alien --scripts oracle-database-xe-18c-1.0-1.x86_64.rpm

Any help would be appreciated,

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/mikhailidim/chronicler-comments/issues/7#issuecomment-651928609, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACNMKYCQTJPY5HJASTGHHFLRZIMMJANCNFSM4IPLVT5Q .

calegrias commented 4 years ago

Thanks for the response, I did more tinkering and was able to generate the deb file, apparently those warnings did not compromise the creation (?) but now I'm running into another snag configuring the database. On step 10 a copy of oracle-xe-18c-cfg is created, in that file I did the modifications as you instructed, but when running it there is a command part of the function check_space around line 489 that runs a df command to validate space with a parameter "--direct", seems like this command is part of the Red hat set of instructions and not valid in debian, that threw an error executing that script:

/bin/df: unrecognized option '--direct' Try '/bin/df --help' for more information.

The shell continued but now it cannot initialize the listener not start the database. Here's the log at the end of that script:

Prepare for db operation 7% complete Copying database files 8% complete [WARNING] ORA-03113: end-of-file on communication channel

9% complete [FATAL] ORA-03114: not connected to ORACLE

29% complete 100% complete [FATAL] ORA-03114: not connected to ORACLE

7% complete 0% complete Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Database configuration failed. Check logs under '/opt/oracle/cfgtoollogs/dbca'.

I cannot run the configuration again as it states the DB is already configured, I was going to try and remove the --direct, but I'm not sure that is the actual problem I'm having.

When I try to start the database I get:

Dell:/opt/oracle/product/18c/dbhomeXE/lib$ sudo /etc/init.d/oracle-xe-18c start Starting Oracle Net Listener. Starting Oracle Database instance XE. Oracle Database instance XE started.

Failed to start Oracle Net Listener using /opt/oracle/product/18c/dbhomeXE/bin/tnslsnr and Oracle Database using /opt/oracle/product/18c/dbhomeXE/bin/sqlplus

Not sure if you will be able to help, but your article was the best one I could find to execute the install, there are many subtle differences and I'm sure I wasn't able to fix all of them. Thanks

mikhailidim commented 4 years ago

Hi @caegrias, I created 20.04 box and updated it to the recent state. I have a slightly different output. I went through trace files, and tried to start an empty database instance. I don't have much time nor interest to dig dipper, but right now I tend to say that 18c XE is not compatible with Ubuntu 20.04 at all. I can't bring even an empty instance. My box is 

Linux ubuntu20 5.4.0-40-generic #44-Ubuntu SMP Tue Jun 23 00:01:04 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
calegrias commented 4 years ago

Thanks Michael, appreciate the effort. I would agree, still trying though; have been able to bring a listener up, but SQLPlus is not starting the DB and other methods have not worked either. I get errors like: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory

I could be close or I could be way off. I'm about ready to give up and change the parameters for my project, either give up on Oracle and install another light DB, or try an Oracle Linux or red hat family.

GeekFavour commented 4 years ago

Hey there, thanks for a good article. I followed your doc on Ubuntu 18.04 and i get the below error during configure,

/etc/init.d/oracle-xe-18c configure /bin/df: unrecognized option '--direct' Try '/bin/df --help' for more information. Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts: Confirm the password: Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database XE. Enter SYS user password:

Enter SYSTEM user password:

Enter PDBADMIN User Password:

Prepare for db operation 7% complete Copying database files 8% complete [WARNING] ORA-12547: TNS:lost contact

29% complete 100% complete [FATAL] Error while cataloging RMAN Backups 7% complete 0% complete Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE0.log" for further details.

Database configuration failed. Check logs under '/opt/oracle/cfgtoollogs/dbca'.

Do you suggest something on this?

littlephone commented 4 years ago

@GeekFavour I also have the same issue. I also tried to use sqlplus to connect as sysdba but I also got warning:
[WARNING] ORA-12547: TNS:lost contact

Not sure how to fix that

@mikhailidim any ideas?

mikhailidim commented 4 years ago

@littlephone I'm afraid the new kernel is beyound compatibility. I have tried to rebuild all the main binaries but it didn't help much.