linux - issue with environment...login to sqlplus -

-

so trying figure out simple issue know related environment setting....as can see oracle database (mcq) , running , when login server set , can login database sqlplus.... issue comes in when switch bash mode typing bash(default csh, when things work)....when switch bash , unset , set oracle_sid, home, path sqlplus can see "connected idle instance." message, means not connecting database....

the reason why unsetting , wanting work because of script trying write. not want relay on things have been set, on servers have env set oracle , on dont...so if work work on both env...

hostname:oramcq 51> ps -ef|grep pmon oramcq     3810      1  0 aug14 ?        00:08:29 ora_pmon_mcq oramcq   121914 121660  0 13:55 pts/0    00:00:00 grep pmon hostname:oramcq 52> hostname:oramcq 52> env | grep ora dbms_type=ora oracle_sid=mcq oracle_base=/oracle oracle_home=/oracle/mcq/112_64 hostname:oramcq 53> hostname:oramcq 53> env | grep path path=/oracle/mcq/112_64/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/mcq/sys/exe/uc/linuxx86_64:/usr/sap/mcq/sys/exe/run:/oracle/mcq/11204:. modulepath=/usr/share/modules/modulefiles:/etc/modulefiles rsec_ssfs_datapath=/usr/sap/mcq/sys/global/security/rsecssfs/data rsec_ssfs_keypath=/usr/sap/mcq/sys/global/security/rsecssfs/key ld_library_path=/usr/sap/mcq/sys/exe/run:/usr/sap/mcq/sys/exe/uc/linuxx86_64:/oracle/mcq/112_64/lib hostname:oramcq 54> hostname:oramcq 54> sqlplus / sysdba  sql*plus: release 11.2.0.4.0 production on thu oct 22 13:56:11 2015  copyright (c) 1982, 2013, oracle.  rights reserved.   connected to: oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production partitioning , real application testing options  sql> exit disconnected oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production partitioning , real application testing options hostname:oramcq 55> hostname:oramcq 55> hostname:oramcq 55> bash bash-4.1$ bash-4.1$ oracle_sid="" bash-4.1$ oracle_home="" bash-4.1$ path=/usr/sbin:/sbin:/bin:/sbin:/usr/bin bash-4.1$ export oracle_sid=mcq bash-4.1$ export oracle_home=/oracle/mcq/11204 bash-4.1$ export path=$oracle_home/bin:$path bash-4.1$ sqlplus /oracle/mcq/11204/bin/sqlplus bash-4.1$ bash-4.1$ env | grep ora dbms_type=ora oracle_sid=mcq oracle_base=/oracle oracle_home=/oracle/mcq/11204 bash-4.1$ bash-4.1$ env | grep path rsec_ssfs_datapath=/usr/sap/mcq/sys/global/security/rsecssfs/data ld_library_path=/usr/sap/mcq/sys/exe/run:/usr/sap/mcq/sys/exe/uc/linuxx86_64:/oracle/mcq/112_64/lib path=/oracle/mcq/11204/bin:/usr/sbin:/sbin:/bin:/sbin:/usr/bin modulepath=/usr/share/modules/modulefiles:/etc/modulefiles rsec_ssfs_keypath=/usr/sap/mcq/sys/global/security/rsecssfs/key bash-4.1$ bash-4.1$ sqlplus / sysdba  sql*plus: release 11.2.0.4.0 production on thu oct 22 13:57:20 2015  copyright (c) 1982, 2013, oracle.  rights reserved.  connected idle instance.  sql>


Comments

Post a Comment

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u
Read more

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork
Read more