i have the following script which when run from the linux sercer does not give me the sqlplus prompt. it does the su and leaves it there insted of continuing. The target is to run the script and it shd su and login to sqlplus
<#!/bin/sh
su -l oracle
export ORACLE_SID=MYDB
sqlplus user/password
#>
~
me as to how i should go about accessing the oracle-xe db that I just installed on my ubuntu 10.04 notebook via sqlplus? I have successfully installed the �oracle-xe 10g server� and client� and I can access the admin page from the browser.However when I try to say sqlplus on the s me this:�error while loading shared libraries:libsqlplus.so: cannot open shared object file: No such file or directory�I have set the paths and variables right Im sure, but I just cant connect with sqlpolus
View 1 Replies View RelatedI am working as oracle DBA on 10g . Till last day I had worked on windows platform. Now my company want me to work on Linux platform. I am first time using Linux dont know A,B,C of Linux . I want to connect sqlplus through linux command prompt. I have exported enviornment variable of oracle but I am getting permission denied Below mention steps I ahd followed . Please help me to solve it
[oracle@bhel1 mj]$ ORACLE_SID=V7;export ORACLE_SID
[oracle@bhel1 mj]$ ORACLE_HOME=/usr/lib/oracle/v7/app/oracle/prod
ver;export ORACLE_HOME
[oracle@bhel1 mj]$ PATH=$ORACLE_HOME/bin:$PATH;export PATH
[oracle@bhel1 mj]$ NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_
[oracle@bhel1 mj]$ LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_P
LIBRARY_PATH
[Code]....
tried hard to install oracle-11g-R2 in my CentOS5.5,during the install,I did all my job step by step as this article says: Q1: when I 'su oracle 'sqlplus /nolog',it said:"sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory".The article has a ution for this problem:"Solution: Install libaio and libaio-devel packages. If packages already installed and error still occurs try execute "ldconfig" as root."Then i executed "ldconfig" as root ,and run "sqlplus /nolog",it occured another problem:"SP2-0667: Message file sp1<lang>.msbSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory"
View 2 Replies View RelatedHow i will use sqlplus in shell script? Can any one provide sample code which explain following:
1. Connect to oracle DB
2. Exceute select * from tablename
3. Release connection to the DB
4. Append output in file everytime when query executes.
I am trying to write a script to access sqlplus and use the output to replace the result in another file. But I am having some issues with it (This script is just a test script and I am just trying to print the updated value.
#!/bin/bash
I am not able to post the sqlplus connection, but it works.
bb=$a
[code]....
I am trying to write a script to access sqlplus and use the output to replace the result in another file. But I am having some issues with it (This script is just a test script and I am just trying to print the updated value.
#!/bin/bash
a=`echo exit|sqlplus -S -L xxx/xxx@xxx @test.sql`
bb=$a
[code].....
How can I make shell script to use sqlplus to update some database table? This is what I'd like to make:
- login to db server (I have create ssh-keygen to bypass the login session)
- login sqlplus / as sysdba
- update status set status='END' where status='BEGIN';
- commit;
- quit;
I'm using oracle 10g database and SLES 9.0
I have no idea what happened to my OS(ubuntu10.04).it doesn't give me any option to enter my login name & passwd.i just get a blank(default) login screen.last time when it worked,i was trying to install GTK+2.8,but due to my mistake i deleted glib using cmd (sudo apt-get purge glib)and after that i even tried to launch terminal but it failed to launch.also tried to play media files using vlc but it didn't work.so i tried to restart my os and finally got stuck in the problem.i have no idea what to do,please help.Is there any cmd to see what problem occurred or which package is missing.
View 14 Replies View RelatedI am not able to login to server from console attached to server, every time i enter username & password but it again asks for username & password. But when i try to login to server from remote machine, login happens properly.
View 4 Replies View RelatedI'm hoping someone can help me out.I made configurations changes to/etc/pam.d/system-auth and /etc/pam.d/login. When these files are configured the way they are, I can't login and/or I can't login in the GUI interface and a terminal. Contents of /etc/pam.d/login
Code:
#%PAM-1.0
#line added per security guide
[code]....
I've set up password-less login for user1 on a Ubuntu machine to login automatically into a Fedora box using the publickey authentication method. Everything is working smoothly. Now, there is a user2 on Fedora but he does not have an account on Ubuntu.
I tried to login as user2 from Ubuntu to but got the following error :
Code:
Predictably neither scp or sftp work either. I have several questions as a result.
1.Is the SSH server rejecting user2 login because I am inadvertently using user1 keys (as I am logged in as user1) ?
2. Do I need to have a user2 account on Ubuntu and public/private key authentication setup with Fedora for user2 to be able to login ?
3. Is there a method I can use to password login as user2 from Ubuntu to Fedora (even though there is no user2 account on Ubuntu) AND still keep password-less login for user1 or do I have to have password-less login for both ?
At present the only way to access the user2 account from Ubuntu is to SSH using the user1 account and then su to user2.
i'm currently using fedora15 Gnome3...i was just wondering that i have seen many different login box and login screens of users. how do i change my login box and login screen
View 14 Replies View Relateddiffrence between login and non login shell. What does it mean by user enviorment.
View 3 Replies View RelatedI'm asking this in the right place. I'm using Ubuntu 10.04 LTS and recently started getting a pop-up similar to the following at every boot up: Login keyring failed Your login keyring did not succeed. Enter login keyring here: That's not [exactly] what it says, but very similar. I should probably add that I have not set up any different 'user profiles' or whatever they're called, but am the only one using this PC...at least, at the present time. Again, this only started a couple of weeks ago and I don't know what I did to start it nor what to do to stop it. I guess it's not extremely painful to have to type my password in every time, but a PITA nevertheless.
View 5 Replies View RelatedPossible Duplicate: SSH asks for password, even with public key installed [URL]...I am trying to login from machine A to machine B with password-less SSH login as described in the above link.I have followed all the steps but still the password is being prompted for.How to diagnose this and resolve the issue
View 2 Replies View Relateddifference b/w a login shell and a non-login shell ?
I know that when we use su - <username> we are getting a login shell & when we use su <user-name> we are getting a non-login shell.
Do we get any additional privileges when we have a login shell compared to a non-login shell ?
My OpenSUSE 11.2 is working fine as samba server, no problems, but I have a problem with KDM.My default init runlevel is set to 5 and every time I try to login at KDM (KDE4), the monitor goes black and returns to the login screen.If I hit Ctrl+Alt+F1 to go to console and start /usr/sbin/console-kit-daemon manually, press Ctrl+Alt+F7 to return to KDM login, everything is fine.What do I have to do to fix this issue?
View 5 Replies View RelatedWhen I try and login at the main login in prompt after boot, it just returns me back to the prompt again.
If I login as root it's fine...OpenSuse: 11.3 Kde: Latest
I have used Ubuntu since 7-4; I now have 10.4. However, in the last week I have been taken to the login screen three times. This could be potentially calamitous. Ctrl+Alt +Backspace have by default been disable since 9-4. There is no way I am pressing atl+Prtscr +K. I wonder if there is a new zap command in 10.4, and if so, how to disable it. I have never found the need to go back back to the login window. I am generally using the command line when doing this.
View 1 Replies View RelatedI just finished installing 10.10 on my pc. the problem is that i cant login to the desktop i enter the password, the login sound plays and im stuck looking at the wallpaper. nothing else. i tried logging in safe mode and it worked. how can i get it to work normally?
pc specs:
Pentium 4 2.6 ghz
512mb ram
ati radeon 9600 graphics card
And i installed it using wubi.
I recently powered up my netbook... Selected my user log in, entered my password, and after a couple seconds I briefly see what looks to be the console and am returned to the login splash screen... I can Ctrl+Alt+F2 to get to the console and log in... but that is as far as I can get. This is the case for Gnome, Remix, and Remix 2D.
I can sudo apt-get (update, upgrade, etc) as well. It is the right password because if I type in a wrong one it presents an authentication failure dialog box.
How can I fix my log in screen and get to my desktop? I am Currently running 10.04.... waiting to get 10.10
yesterday i installed slim login manager on my computer (eee pc 1018p, ubuntu 11.04), and now it cannot get passed the ubuntu loading screen (with orange dots underneath) when booting. i tried booting into recovery mode and that didn't work either. i also left the computer trying to boot overnight and that didn't work.
basically, during this loading screen that should eventually bring you to the login screen, i can alt+tab to see the progress of the load. the progress is stuck on
Is there anything I can do from grub to remove slim?or, is there any way I can access my ubuntu partition and save all my files?
I just installed Fedora 12 on a laptop. I changed the default shell on the root account to /bin/tcsh and changed the runlevel to 3 and then rebooted. Now I can't login into the root account: it returns me immediately to the login prompt and I can't see any error message (the screen is cleared).Why is this happening?Can I boot into some sort of safe mode so I can undo my changes to the /etc/inittab and /etc/passwd file?I tried booting with a Live CD with the intention of mounting the filesystem and making the changes, but the new filesystem is a LVM and it won't let me mount it (or I don't know how to mount a Logical Volume).
View 3 Replies View RelatedI don't what happened but yesterday I was working normally and then I shutdown the computer, today when I opened ubuntu it took me to tyy1 login screen, I entered my username and password then it took me to the normal login screen with the login drums sound and it wrote on my account (logged in) so I clicked it and I entered my password again and then I got to my ubuntu so what went wrong and how to fix it also I noticed that a new terminal in system tools occurred called Kernel (I didn't add it)
I'm using ubuntu 10.10 on Dell inspiron 1520 with Nvidia 8600GT and 3GB RAM
Important: this happened after update to generic-headers-24
I just bought this desktop from my friend and it runs win 7 and ubuntu 10.04. it worked very well the first two days until I changed the hostname of the system.
I did like: hostname myNewName
And everything worked fine. The problem now is when I start ubuntu and and reach username and password screen , I enter my password to login the screen becomes black and return me again to the screen where I put my password again. If I entered wrong password , the system message stating wrong password. On the other hand, when I try to run ubuntu from live-cd I can login easily and access my account.
My friend told me he removed Naultius package and reinstall it for some reason before he gave it to me. Note windows 7 is working properly.
been using 11.2 with KDE on a Sony laptop since 11.2 was released always ran perfect suddenly I can't login, I get to the login screen type in password it begins to load my desktop, then fails and dumps me back to the login screen I can login as root, all my stuff is there (under /home/me) I tried changing my password, no luck I went to run level 3 and there I can login just fine seems to be something with my KDE profile
any ideas where I might find some error messages telling me what's going on?
this seemed to happen when I was running "blender" and making the machine do some heavy number crunching, it actually locked up.
System was fine with :Ubuntu 9.04 (had also installed kde )then....I wanted to try some change to gdm so i downloaded gdm while building it , it asked "PAM" libraries to be installed so i installed PAM ... but ignored the instruction to reinstall SHADOW (library i guess..),Now :on booting system i get login menu but i am not able to login , it says some critical error occured
1) install new copy of UBUNTU and remove old
ps :1) i can log into system through live cd
2) i can use recovery mode boot and log into terminal as root(startx is not working from this terminal..
My computer was working this morning and both hard drives were working fine, then all of a sudden for about two hours I was stuck with this "problem", then after fumbling and moving and stablizing things, then Windows works? See below for details. I've finally reinstalled both hard drives, but the one with the Linux partition doesn't work: it says nothing is discovered on the disk. I can't login at the LUKS login after grub starts, therefore I can't get into Linux, but Windows works?! I used to be able to go directly into Grub when the computer starts, I forgot how to do that but it doesn't matter. If you need details I'd be glad to provide them. I just wondered why Linux doesn't work, but Windows does. I have Linux & Windows on two different separate hard drives
View 5 Replies View Relatedi am having a boot problem with opensuse.i installed a theme named suse-elegant under personal settings(configure desktop)-system administration-login screen.
i had also added vbox users(i ticked vboxusers) under yast-security and users-user and group management-edit-details to make virtual box work.
i want to check that installed theme so i restarted my laptop.after the restart opensuse taking too long time to boot
note:the login theme also not working.
after the boot i restored defaults in login screen themes.it is also not working.
i don't know which cause this problem(vboxusers or login theme).i am also seeing a root user has been added in my login area.i tried opensuse failsafe also.