sqlplus not found

[pablogmorales]

Hello Im getting this error:

puppet agent -t Info: Using configured environment 'test' Info: Retrieving pluginfacts Info: Retrieving plugin Info: Retrieving locales Info: Loading facts Info: Applying configuration version '1527787015' Info: instance action: start with command startup

-bash: sqlplus: command not found

Error: Error: /Stage[main]/mystuff::Packages::Oracle::Dbinstance/Oradb::Dbactions[start testDB_Create]/Db_control[instance control start testDB_Create]/ensure: change from 'stop' to 'start' failed:

But I think the DB is up and running.

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu May 31 12:13:37 2018

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

Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL>SQL> select * from v$database;

DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#

ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#

CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE PROTECTION_MODE

PROTECTION_LEVEL REMOTE_A ACTIVATION# SWITCHOVER# DATABASE_ROLE

ARCHIVELOG_CHANGE# ARCHIVEL SWITCHOVER_STATUS DATAGUAR GUARD_S SUPPLEME SUP

SUP FORCE_LOGGING PLATFORM_ID

PLATFORM_NAM

##########

oradb::database{ 'testDb_Create': oracle_base => '/oracle', oracle_home => '/oracle/product/12.2/db', version => '12.2', user => 'oracle', group => 'dba', download_dir => '/install', action => 'create', / template => 'dbtemplate_12.2', template_variables => { 'automaticMemoryManagement' => 'False', 'db_recovery_file_dest_size' => '4'}, / automatic_memory_management => false, db_name => 'test', db_domain => 'test.com', db_port => 1521, sys_password => 'Welcome01', system_password => 'Welcome01', data_file_destination => "/oracle/oradata", recovery_area_destination => "/oracle/flash_recovery_area", character_set => "AL32UTF8", nationalcharacter_set => "UTF8", init_params => {'open_cursors' => '1000', 'processes' => '600', 'job_queue_processes' => '4' }, sample_schema => 'TRUE', memory_percentage => 40, memory_total => 1024, database_type => "MULTIPURPOSE", em_configuration => "NONE", require => Oradb::Listener['start listener'],

puppet_download_mnt_point => $puppet_download_mnt_point, }

oradb::dbactions{ 'start testDB_Create': oracle_home => ('$oracle_home'), user => ('$user'), group => ('$group'), action => 'start', db_name => ('$db_name'), require => Oradb::Database['testDb_Create'], }

########### Do you now why is not finding the sqlplus command?

Thanks for your time and support Regards

[pablogmorales]

Hello, any clue about what this error could be? Thanks Regards

[biemond]

I guess , it ran in an old session before .profile was set or did not execute .oraenv

strange , so I think installdb already went wrong.

[pablogmorales]

This is what's set for oracle user, is there something missing? , should I take care of .profile , path environment or that should be taken care of by the module itself?
env output. ORACLE_BASE=/oracle ORACLE_TERM=xterm ORACLE_HOME=/oracle/product/12.2/db

env|grep PATH LD_LIBRARY_PATH=$/oracle/product/12.2/db/lib PATH=/bin:/usr/local/bin:/usr/bin:/bin:/oracle/product/12.2/db/bin QT_PLUGIN_PATH=/usr/lib64/kde4/plugins:/usr/lib/kde4/plugins

pwd /home/oracle

-rw-------. 1 oracle oinstall 200 May 31 12:16 .bash_history -rw-r--r--. 1 oracle oinstall 18 Aug 3 2017 .bash_logout -rwxrwxr-x. 1 oracle dba 430 May 30 20:52 .bash_profile -rw-r--r--. 1 oracle oinstall 231 Aug 3 2017 .bashrc -rw-r--r--. 1 oracle oinstall 172 Feb 14 08:48 .kshrc drwxr-xr-x. 2 oracle oinstall 4096 May 31 11:56 .oracle_jre_usage

Thanks Regards

[pablogmorales]

Any comments? you said that could be because of an old session, how do I clear/remove that session? should I start it over? remove all data, oracle home, users and so on?

Thanks